Database Administration Questions


Q:

I am an 8 letter word.

First 4 is the question.

2, 3, 4 protects our head.

5, 6, 7 IT company name.

7 & 8 are the same letters.

Who am I?

Answer

That 8 letter word is Whatsapp (a messenger app)


First four letters:   WHAT a question
 
Letters 2,3,4:     HAT protects our head

Letters 5,6,7:   SAP an IT company

Letters 7,8:    PP same.

Report Error

View answer Workspace Report Error Discuss

9 5363
Q:

Data flow analysis studies

A) The use of data on paths through the code B) Possible communications bottlenecks in a program
C) The intrinsic complexity of the code D) The rate of change of data values as a program executes
 
Answer & Explanation Answer: A) The use of data on paths through the code

Explanation:

Data flow analysis studies the use of data on paths through the code.

Report Error

View Answer Report Error Discuss

8 5345
Q:

Tilak rides on a cycle to a place at speed of 22 kmph and comes back at a speed of 20 kmph. If the time taken by him in the second case is 36 min. more than that of the first case, what is the total distance travelled by him (in km)?

A) 132 km B) 264 km
C) 134 km D) 236 km
 
Answer & Explanation Answer: B) 264 km

Explanation:

Let the distance travelled by Tilak in first case or second case = d kms

Now, from the given data,

d/20 = d/22 + 36 min

=> d/20 = d/22 + 3/5 hrs

=> d = 132 km.

 

Hence, the total distance travelled by him = d + d = 132 + 132 = 264 kms.

Report Error

View Answer Report Error Discuss

5 5299
Q:

Find the Odd one out of the following Numbers?

A) 3 B) 19
C) 67 D) 133
 
Answer & Explanation Answer: D) 133

Explanation:

Here among the given numbers, 3, 19, 67 are prime numbers. And 133 is not a prime number.

 

Hence, the odd number of the given numbers is 133.

Report Error

View Answer Report Error Discuss

4 5295
Q:

Chennai express left Hyderabad for Chennai at 14 : 30 hours, travelling at a speed of 60 kmph and Charminar Express left Hyderabad for Chennai on the same day at 16 : 30 hours, travelling at a speed of 80 kmph. How far away from Hyderabad will the two trains meet? 

A) 360 kms B) 480 kms
C) 520 kms D) 240 kms
 
Answer & Explanation Answer: B) 480 kms

Explanation:

Now, the distance covered by Chennai express in 2 hrs = 60 x 2 = 120 kms

Let the Charminar Express takes 't' hrs to catch Chennai express

=> 80 x t = 60 x (2 + t)

=> 80 t = 120 + 60t

=> t = 6 hrs

 

Therefore, the distance away from Hyderabad the two trains meet = 80 x 6 = 480 kms.

Report Error

View Answer Report Error Discuss

10 5287
Q:

Which planet rotates clockwise?

A) Uranus B) Saturn
C) Venus D) Earth
 
Answer & Explanation Answer: C) Venus

Explanation:

Venus is the only planet that rotates in clockwise where all other planets in the solar system rotates in anti - clockwise direction.

 

which_planet_rotates_clockwise1556602727.jpg image

Report Error

View Answer Report Error Discuss

6 5275
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

36 5269
Q:

Which SQL keyword is used to sort the result-set?

A) ORDER B) ORDER BY
C) SORT BY D) SORT
 
Answer & Explanation Answer: B) ORDER BY

Explanation:

SQL keyword ORDER BY is used to sort the result-set.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 5220