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

"If a system A is in thermal equilibrium with B and B is in thermal equilibrium with C, then A and C are in equilibrium with each other". This is a statement of 

A) Cyclic rute B) Zeroth law of thermodynamics
C) First law of thermodynamics D) Second law of thermodynamics
 
Answer & Explanation Answer: B) Zeroth law of thermodynamics

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Chemistry

4 5801
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 5795
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 5795
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 5793
Q:

Which vehicle is spelled the same forwards and backwards?

Answer

Racecar and Civic are the two vehicles which spelled the same forwards an backwards.

Report Error

View answer Workspace Report Error Discuss

7 5784
Q:

I am the first on Earth, the second in Heaven. I appear two times in a week you can only see me once in a year. Although I am in the middle of the sea, l am not found in month, but l am in February, June, September, October, November & December.

Who am I?

Answer

The letter 'E'.


As of the above given data,


It is in the 1st place in Earth, 2nd in Heaven and in the middle of the Sea.


It appears once in a Year and twice in a Week.


It is present in February, June, September, October, November & December.


But not in the Month.


 


Hence, it is the letter 'E'.

Report Error

View answer Workspace Report Error Discuss

15 5784
Q:

Which statement about interstate compacts is true?

A) States cannot form compacts with foreign states. B) They may involve no more than two states.
C) Congress generally must approve interstate compacts. D) Most are between the national government and foreign states.
 
Answer & Explanation Answer: C) Congress generally must approve interstate compacts.

Explanation:

Agreements made between two or more states are known as Interstate compacts. These may involve several states.

 

* Congress generally must approve interstate compacts.

Report Error

View Answer Report Error Discuss

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

1 5784