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 5882
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 5882
Q:

Select the antonym of

to envisage

 

A) oblivious B) to apprehend
C) to confront D) to visualize
 
Answer & Explanation Answer: A) oblivious

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 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:

Which of the following is/are the function(s) of bile juice released from the liver?

 

I. Make the food coming from stomach alkaline.

II. Conversion of proteins into amino acids.

III. Break down of fats into smaller globules.

 

A) Only I   B) Only II and III  
C) Only I and III   D) All I, II and III  
 
Answer & Explanation Answer: C) Only I and III  

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Biology
Exam Prep: Bank Exams

1 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