Database Administration Questions


Q:

What has a head and a tail but nobody?

Answer

A Coin has a Head and tail but no body. Since the two sides of coin are called as heads and tails.

Report Error

View answer Workspace Report Error Discuss

12 9219
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 9168
Q:

A person of good understanding knowledge and Reasoning power

A) Snob B) Expert
C) Literate D) Intellectual
 
Answer & Explanation Answer: D) Intellectual

Explanation:

The one word substitute for A person of good understanding knowledge and Reasoning power is Intellectual.

Report Error

View Answer Report Error Discuss

9 9101
Q:

'Brothers and sisters, I have none. But that man's father is my father's son'.
How I and that man are related respectively?

A) Father & Son B) Brothers
C) Son & Father D) Nephews
 
Answer & Explanation Answer: A) Father & Son

Explanation:

Given that man's father is my father's son => Me because i have no brothers

=> Mans father is me.

Hence, that man is my Son.

Report Error

View Answer Report Error Discuss

12 9014
Q:

What is the meaning of the four colour dots in the news paper?

newspaper-color-dots1525935299.jpg image

Answer

If you read newspaper daily, then you may be aware of the four coloured dots on the corner of the newspaper. 


 


The four dots CMYK — blue (Cyan), pink (Magenta), Yellow and black (Kalio) are registration marks used during printing to help ensure the print is aligned properly. Any colour can be obtained by adding the correct proportion of these four colours.


 


CMYK is used as a base for the colours used in printing newspapers, and these four colours are often printed on the paper in either a heart, dot, or square shape.


 


To print an image, the plates of all these colours are laid out on a page separately and lined up in the same spot while printing. If those four dots are blur or you find the colours overlapping on the image it means the printing is not good. To print an accurate and perfect image, the colors and shape must be arranged precisely and must be claear sharp in order to get the best output.


 



That's why CMYK is also called registration mark. As physically checking all the pages of the paper is not possible for a printer who prints number of news papers daily, he just checks these dots.

Report Error

View answer Workspace Report Error Discuss

15 8989
Q:

Optimist is to cheerful as Pessimist is to

A) Helpful B) Mean
C) Petty D) Gloomy
 
Answer & Explanation Answer: D) Gloomy

Explanation:

The given words are related in a way that, an optimist is a person whose outlook is cheerful. Similarly, a pessimist is a person whose outlook is gloomy.

 

The answer is not (b) because a pessimist does not have to be mean. Options (c) and (a) are incorrect because neither words describe the outlook of a pessimist.

 

Hence, Optimist is to cheerful as Pessimist is to Gloomy.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

3 8973
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 8878
Q:

Solve the Riddle?

bana1522056999.jpg image

A) 79 hrs B) 72 hrs
C) 52 hrs D) 18 hrs
 
Answer & Explanation Answer: D) 18 hrs

Explanation:

From the given data,

18 snakes can eat 18 bananas in 18 hrs.

=> 1 snake can eat 1 banana in 18 hrs

=> 79 snakes can eat 79 bananas in 18 hrs.

 

Hence, 18 hrs.

Report Error

View Answer Report Error Discuss

21 8872