Questions

Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

8 5883
Q:

We remember Charles Babbage (1792-1871) for what ?

A) Computers B) Radio-Telegraphy
C) Steam Boating D) Telescopes
 
Answer & Explanation Answer: A) Computers

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Inventions

9 5882
Q:

Contour bunding is a method of soil conservation used in

A) Scrublands, liable to spread of weed growth B) Hilly and Slopy or mountain areas
C) Low flat plains, close to stream courses, liable to flooding D) Desert margins, liable to strong wind action
 
Answer & Explanation Answer: B) Hilly and Slopy or mountain areas

Explanation:

Contour bunding is a proven sustainable land management practice for mountainous areas, marginal, sloping, and hilly land where the soil productivity is very low.

 

It is widely adopted by the ethnic minorities of Nepal who practice the shifting cultivation system of farming.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

11 5881
Q:

Which statement fits the Frontier Ethic?

A) Recycle plastic B) Help those in need
C) He who has more toys wins D) Walk lightly on Earth
 
Answer & Explanation Answer: C) He who has more toys wins

Explanation:

Frontier Ethic is Spending Earth's assets at the cost of losing resource capital. A frontier ethic assumes that the earth has an unlimited supply of resources. It is the notion of disregarding the Earth for the benefit or gain of man.

If resources run out in one area, more can be found elsewhere or alternatively human ingenuity will find substitutes. This attitude sees humans as masters who manage the planet. It is completely Anthropocentric.

Report Error

View Answer Report Error Discuss

Filed Under: General Science
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

10 5880
Q:

India's forest sponge iron plant is at

A) Kothagudam B) Kurnool
C) Kadapa D) Kavaratti
 
Answer & Explanation Answer: A) Kothagudam

Explanation:

Kothagudam is in Andhra Pradesh. The sponge iron will act as a substitute for steel scrap and be used as feed stock of electric arc steel making.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography

9 5878
Q:

In India, the first hour of every Parliamentary sitting is allotted for ________.

 

A) Question hour B) Half an hour
C) Zero hour D) No option is correct
 
Answer & Explanation Answer: A) Question hour

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Politics
Exam Prep: Bank Exams

0 5877
Q:

National Rural Development Institute is situated at

 

A) Assam B) Patna
C) Shimla D) Hyderabad
 
Answer & Explanation Answer: D) Hyderabad

Explanation:

National Institute of Rural Development is situated in Hyderabad. It is an organization involved in rural research and training in rural development.

 

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography
Exam Prep: Bank Exams

1 5876
Q:

What structure separates the thoracic cavity from the abdominal cavity?

A) Diaphragm B) Liver
C) Lungs D) Heart
 
Answer & Explanation Answer: A) Diaphragm

Explanation:

A Dome-shaped, muscular and membranous structure that separates as a partition of the thoracic and abdominal cavities is Diaphragm. 

 

                                               What_structure_separates_the_thoracic_cavity_from_the_abdominal_cavity1533705594.png image

 

Thoracic or chest cavity ::  It is the cavity where the heart and lungs are present. It is the second largest hallow space in the body.It also has vertebral column, ribs, breast bone,...

 

Abdominal cavity :: It is the cavity where the digestive tract, liver, kidneys, the spleen, pancreas,... are located. It is the largest hallow space of the body.

 

Report Error

View Answer Report Error Discuss

Filed Under: General Science
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

6 5875