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

The Mudumalai National Park is located in which state  ?

A) Chattisgarh B) Haryana
C) Tamil Nadu D) Karnataka
 
Answer & Explanation Answer: C) Tamil Nadu

Explanation:

The Mudumalai National Park (MNP) is located about 150 kilometres north-west of Coimbatore city in Tamil Nadu. The protected area is home to several endangered and vulnerable species including Indian elephant, Bengal tiger, gaur and Indian leopard. There are at least 266 species of birds in the sanctuary, including critically endangered Indian white-rumped vulture and long-billed vulture.

Report Error

View Answer Report Error Discuss

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

31 12740
Q:

Agrostology is the study of

A) Seed of oil B) Crop
C) Grass D) Fruits
 
Answer & Explanation Answer: C) Grass

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Biology

86 12739
Q:

Sandal Wood trees are mostly found in____

A) Trophical Evergreen Forests B) Tropical most Decidous
C) Alpine forests D) Trophical Thorn Forests
 
Answer & Explanation Answer: D) Trophical Thorn Forests

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Geography

13 12731
Q:

How many layers of skin does a human have?

A) 1 B) 2
C) 3 D) 4
 
Answer & Explanation Answer: C) 3

Explanation:

The human skin is made of 3 layers. They are ::

1) The Epidermis

2) The Dermis

3) The Hypodermis

 

how_many_layers_does_human_skin_have1542259835.jpg image

 

Epidermis :: 

It is the outermost layer of skin, provides a waterproof barrier and creates our skin tone.

 

Demis ::

It is beneath the epidermis, contains tough connective tissue, hair follicles, and sweat glands.

 

Hypodermis ::

It is deeper layer and is made of fat and connective tissue.

Report Error

View Answer Report Error Discuss

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

11 12728
Q:

The germans calls this the 'spider monkey' and the italians call it the 'snail'.Which symbol is this?

A) + B) @
C) $ D) #
 
Answer & Explanation Answer: B) @

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: Bank Exams
Job Role: Bank Clerk

66 12728
Q:

To produce deflection in a television picture tube:

A) an electric field is used B) a magnetic field is used
C) both electric and magnetic field are used D) none of the above
 
Answer & Explanation Answer: B) a magnetic field is used

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Physics

72 12713
Q:

EPROM can be used for

A) Erasing and reconstructing the contents of ROM B) Duplicating ROM
C) Reconstructing the contents of ROM D) Erasing the contents of ROM
 
Answer & Explanation Answer: A) Erasing and reconstructing the contents of ROM

Explanation:

EPROM stands for Erasable Programmable Read-only Memory.

eprom_can_be_used_for1563542842.jpg image

It is a programmable read-only memory that can be used for erased and re-used.

Report Error

View Answer Report Error Discuss

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

12 12710