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

What is the largest seabird ?

Answer

Albatross

Report Error

View answer Workspace Report Error Discuss

31 5766
Q:

In the structure of Planet Earth, below the mantle, the core is mainly made up of which one of the following ?

A) Aluminium B) Chromium
C) Iron D) Silicon
 
Answer & Explanation Answer: C) Iron

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Geography

13 5763
Q:

The first of its kind road from plastic waste has been constructed in?

 

A) Tripura B) Delhi
C) Telangana D) Kerala
 
Answer & Explanation Answer: A) Tripura

Explanation:

Tripura, in a first-ever initiative, has started using plastic waste for the construction of roads.

 

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: Bank Exams

5 5763
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 5763
Q:

1990 was declared as the SAARC year

A) Of shelter for the homeless B) Of girl child
C) Of mutual cooperation D) Against drug abuse
 
Answer & Explanation Answer: A) Of shelter for the homeless

Explanation:
Report Error

View Answer Report Error Discuss

5 5762
Q:

Which of the following sectors is NOT considered ' Infrastructure Sector '

A) Software B) Cement
C) Petroleum D) Steel
 
Answer & Explanation Answer: A) Software

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Economy

6 5762
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 5757