Database Administration Questions


Q:

In 1990 a person is 15 years old. In 2000 that same person is 5 years old. How can this be possible?

Answer

 It can be possible in only B.C. i.e, Before Christ. That was about 2000 years ago.


 Given, 


 In 1990 B.C = 2000 + 1990 = 3990 years ago, a person is 15 years Old  


=> In 1995 B.C = 2000 + 1995 = 3995 years ago, the same person will be 10 years Old 


Therefore, In 2000 B.C = 2000 + 2000 = 4000 years ago, the same person will be 5 years Old.

Report Error

View answer Workspace Report Error Discuss

48 9679
Q:

Data integrity constraints are used to

A) Ensure that duplicate records are not entered into the table B) Prevent users from changing the values stored in the table
C) Control who is allowed access to the data D) Improve the quality of data entered for a specific property like table column
 
Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

 

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

27 9530
Q:

Who is the primary Author of HTML?

A) Sabeer Bhatiya B) Tim Berners-Lee
C) Brendan Eich D) Google Inc.
 
Answer & Explanation Answer: B) Tim Berners-Lee

Explanation:

The primary Author of HTML is Tim Berners-Lee, a scientist and academic, with the assistance of his colleagues at CERN, an international scientific organization based in Geneva, he did this. Berners-Lee invented the World Wide Web in 1989 at CERN.

Report Error

View Answer Report Error Discuss

5 9495
Q:

18 tens 20 ones =

A) 1820 B) 180
C) 200 D) 160
 
Answer & Explanation Answer: C) 200

Explanation:

18 tens 20 ones, the given stateent can be split into

18 tens = 18 x 10 = 180

20 ones = 20 x 1 = 20

 

Then add both => 180 + 20 = 200

 

Hence, 18 tens 20 ones = 200.

Report Error

View Answer Report Error Discuss

12 9487
Q:

The digital computer was developed primarily in

A) USA B) UK
C) Russia D) Japan
 
Answer & Explanation Answer: A) USA

Explanation:

A digital computer accepts, processes and outputs data in digitized forms. The digital computer was developed primarily in Unites States of America.

Report Error

View Answer Report Error Discuss

28 9459
Q:

Three taps I, J and K can fill a tank in 20,30and 40 minutes respectively. All the taps are opened simultaneously and after 5 minutes tap A was closed and then after 6 minutes tab B was closed .At the moment a leak developed which can empty the full tank in 70 minutes. What is the total time taken for the completely full ?

A) 24.315 minutes B) 26.166 minutes
C) 22.154 minutes D) 24 minutes
 
Answer & Explanation Answer: B) 26.166 minutes

Explanation:

Upto first 5 minutes I, J and K will fill => 5[(1/20)+(1/30)+(1/40)] = 65/120


For next 6 minutes, J and K will fill => 6[(1/30)+(1/40)] = 42/120


So tank filled upto first 11 minutes = (65/120) + (42/120) = 107/120
So remaining tank = 13/120


Now at the moment filling with C and leakage @ 1/60 per minute= (1/40) - (1/70) = 3/280.
So time taken to fill remaining 13/120 tank =(13/120) /(3/280) = 91/6 minutes

 

Hence total time taken to completely fill the tank = 5 + 6 + 91/6 = 26.16 minutes.

Report Error

View Answer Report Error Discuss

13 9430
Q:

Count function in SQL returns the number of

A) groups B) values or rows
C) columns D) distinct values
 
Answer & Explanation Answer: B) values or rows

Explanation:

Count function in SQL returns the number of values or rows.

Report Error

View Answer Report Error Discuss

36 9341
Q:

Two main measures for the efficiency of an algorithm are

A) Time and Space B) Complexity and Memory
C) Data and Space D) Memory and Processor
 
Answer & Explanation Answer: A) Time and Space

Explanation:

Two main measures for the efficiency of an algorithm are Time and Space.

Report Error

View Answer Report Error Discuss

26 9328