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

Which of the following menu types is also called a drop down menu?

A) fly-out B) cascading
C) pop-up D) pull-down
 
Answer & Explanation Answer: D) pull-down

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Computer

35 11913
Q:

Moving from one website to another is called

A) Browsing B) Attaching
C) Downloading D) Uploading
 
Answer & Explanation Answer: A) Browsing

Explanation:

Moving from one website to another is called Browsing.

Report Error

View Answer Report Error Discuss

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

42 11904
Q:

Which team won the 10th Indian Premier League trophy 2017  ?

A) Mumbai Indians B) Rising Pune Supergiants
C) Kolkata Knight Riders D) Sunrisers Hyderabad
 
Answer & Explanation Answer: A) Mumbai Indians

Explanation:

In Cricket, Mumbai Indians lifted the 10th Indian Premier League trophy for the third time, as they recorded a scintillating 1-run win against Rising Pune Supergiant in the title clash at Hyderabad during final.  Mumbai successfully defended a total of 129 and restricted Pune to 128/6 to lift their third IPL trophy. Krunal Pandya from Mumbai Indians was named the man of the match.

Report Error

View Answer Report Error Discuss

Filed Under: Sports

23 11899
Q:

Which state government has launched Pashu Bazar website for online cattle sale  ?

A) Telangana B) Andhra Pradesh
C) Haryana D) Gujarat
 
Answer & Explanation Answer: A) Telangana

Explanation:

The Telangana government has launched Pashu Bazar website for online cattle sale. The online sale or purchase of cattle through pashubazar.telangana.gov.in website will help farmers as the cattle need not be brought to shandies every time and farmers can save on transportation cost on cattle. Farmer can keep maximum five registrations for sale at any time. Thus, the online platform has been developed to help farmers to sell their animals without physically taking them to weekly markets.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness

51 11889
Q:

The Government of India Act of 1935 borrowed its preamble from

A) The Constitution of the USA B) The Constitution of Australia
C) From the Government of India Act of 1919 D) From Pitt's India Act
 
Answer & Explanation Answer: C) From the Government of India Act of 1919

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian History

8 11853
Q:

The upper part of the mantle upon which the crust of the earth floats is called

A) Barysphere B) Mesosphere
C) Mohorovic discontinuity D) Asthenosphere
 
Answer & Explanation Answer: D) Asthenosphere

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Geography

20 11832
Q:

The Capacity of a Communication Channel is Measured in

A) Band rate B) Band width
C) Data flow D) Bit capacity
 
Answer & Explanation Answer: B) Band width

Explanation:

The path that data takes from source to destination is called a Channel. A channel is a communication medium. A channel has a certain capacity for transmitting information. 

 

The "capacity" of a channel is the theoretical upper-limit to the bit rate over a given channel that will result in negligible errors. Channel capacity is often measured by its Bandwidth in Hz or its data rate in bits per second.

Report Error

View Answer Report Error Discuss

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

15 11815