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

20 11423
Q:

Penny has 5 children, 1st is January, 2nd kid February, 3rd is called march , 4th is April. What is the name of the 5th.

Answer

Here If you notice the difference, There is no question mark (?) at the end of the puzzle.


In that case, "What" is the name of the 5th child.

Report Error

View answer Workspace Report Error Discuss

65 11421
Q:

What is the scientific name for washing soda?

A) Sodium carbonate B) Sodium bicarbonate
C) Calcium carbonate D) Calcium bicarbonate
 
Answer & Explanation Answer: A) Sodium carbonate

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: General Science

62 11407
Q:

When body is accelerated

A) its velocity never changes B) its speed always changes
C) its direction always changes D) its speed may or maynot change
 
Answer & Explanation Answer: D) its speed may or maynot change

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Physics

53 11396
Q:

Erg cross Sec is the unit of

A) Angular momentum B) Linear Momentum
C) Planck's constant D) Energy
 
Answer & Explanation Answer: C) Planck's constant

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Physics

33 11379
Q:

Which musician composed the raga Priyadarshini on Mrs. Indira Gndhi's death?

Answer

Amjad Ali Khan

Report Error

View answer Workspace Report Error Discuss

35 11376
Q:

Who was the only Lok Sabha Speaker to have become the President of India

A) VV Giri B) Zail Singh
C) Neelam Sanjiva Reddy D) S.Radhakrishnan
 
Answer & Explanation Answer: C) Neelam Sanjiva Reddy

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Politics

28 11373
Q:

Simla is cooler than Amritsar although they are on the same latitude. This is because

A) Simla is further north B) Simla is at greater height above sea level than Amritsar
C) Simla is farther from the equator D) Their longitudes differ
 
Answer & Explanation Answer: B) Simla is at greater height above sea level than Amritsar

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Geography

26 11368