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

9 5903
Q:

Which is true of the 1912 presidential election?

A) Because all three major candidates were Progressive, the Socialist won B) Because all three major candidates were Progressive, Progressive votes were split
C) Although none of the candidates was Progressive, the Progressives decided the election D) Although none of the candidates was Progressive, Progressive ideas were important
 
Answer & Explanation Answer: B) Because all three major candidates were Progressive, Progressive votes were split

Explanation:

Because all three major candidates were Progressive, Progressive votes were split" is the one among the following that is true of the 1912 presidential election.

The correct option among all the options that are given in the question is the option "B".

Report Error

View Answer Report Error Discuss

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

4 5902
Q:

Which state government has inaugurated the upgraded version of police helpline Namma 100, where police officials will be deputed within 15 minutes to the spot of emergency  ?

A) Karnataka B) Telangana
C) Tamil Nadu D) Madhya Pradesh
 
Answer & Explanation Answer: A) Karnataka

Explanation:

Karnataka CM Siddaramaiah has inaugurated the upgraded version of police helpline Namma 100, where police officials will be deputed within 15 minutes to the spot of emergency, for Bengaluru. Based on the model adapted in London, which has helpline 999, and USA, where 911 helpline operates, Namma 100 helpline allows the public to access several facilities on a single number.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: Bank Exams

11 5900
Q:

The International Development Association, a lending agency, is administered by the

A) International Bank for Reconstruction and Development B) International Fund for Agricultural Development
C) United Nations Development Programme D) United Nations Industrialized Development Organization
 
Answer & Explanation Answer: A) International Bank for Reconstruction and Development

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Organisations

8 5899
Q:

Cathode rays are 

A) electromagnetic wave B) stream of alpha particle
C) stream of electrons D) radiations
 
Answer & Explanation Answer: C) stream of electrons

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Chemistry

13 5899
Q:

I can be broken or attacked, I can be clogged or crushed, I can be given and I can be kept, sometimes I am warm and other times I am cold. What am I?

Answer

A Heart.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: Bank Exams

17 5896
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 5893
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 5893