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

Entomology is the science that studies

A) Insects B) Behaviour of Human beigns
C) Scientific Names D) Formation of Rocks
 
Answer & Explanation Answer: A) Insects

Explanation:

Entomology is the science branch of Zoology that studies Insects

entomology_is_the_study_of1549696118.jpg image

Report Error

View Answer Report Error Discuss

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

18 5784
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 5783
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 5783
Q:

Select the synonym of

 

redemption

 

A) forfeit B) atonement
C) retribution D) penalty
 
Answer & Explanation Answer: B) atonement

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams , TOEFL

0 5777
Q:

Which best describes transformation in bacteria?

A) Bacteria take DNA from their environment. B) Bacteria inject DNA into another cell.
C) Bacteria lie dormant for many weeks. D) Bacteria transfer DNA with a bacteriophage.
 
Answer & Explanation Answer: A) Bacteria take DNA from their environment.

Explanation:

"Bacteria take DNA from their environment" is what best describes transformation in bacteria.

Report Error

View Answer Report Error Discuss

Filed Under: Biology
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

4 5777
Q:

What is the largest seabird ?

Answer

Albatross

Report Error

View answer Workspace Report Error Discuss

31 5775
Q:

One who dies for a noble cause

A) Martyr B) Pilgrim
C) Astronomer D) Pantomath
 
Answer & Explanation Answer: A) Martyr

Explanation:

One who dies for a noble cause is called a martyr. He is a person who dies fighting for what they believe in like advocating religious or other beliefs, refusing to renounce, etc...

Report Error

View Answer Report Error Discuss

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

10 5774