Database Administration Questions


Q:

Sravan drove from home to a neighboring town at the speed of 50 km/h and on his returning journey, he drove at the speed of 45 km/h and also took an hour longer to reach home. What distance did he cover?

A) 350 kms B) 450 kms
C) 900 kms D) 700 kms
 
Answer & Explanation Answer: C) 900 kms

Explanation:

Let the distance he covered each way = d kms

According to the question,

d/45 - d/50 = 1

=> d = 450 kms.

 

Hence, the total distance he covered in his way = d + d = 2 d = 2 x 450 = 900 kms.

Report Error

View Answer Report Error Discuss

14 3890
Q:

Which of the following memory is volatile?

A) RAM B) Floppy disc
C) ROM D) Magnetic tape
 
Answer & Explanation Answer: A) RAM

Explanation:

Volatile memory is computer memory that requires power to maintain the stored information. It is a temporary memeory which cannot contain information permanently.

Example :: RAM or Random Access Memory

Report Error

View Answer Report Error Discuss

4 3890
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 3884
Q:

Component Testing is also called as

component_testing_is_also_called_as1542088267.jpg image

A) Unit testing B) Module testing
C) Program testing D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

Component Testing is also called as Module or Unit or Program testing. It is testing of all the components in an application separately.

Report Error

View Answer Report Error Discuss

6 3851
Q:

From a group of 7 boys and 6 girls, five persons are to be selected to form a team, so that at least 3 girls are there in the team. In how many ways can it be done?

A) 427 B) 531
C) 651 D) 714
 
Answer & Explanation Answer: B) 531

Explanation:

Given in the question that, there are 7 boys and 6 girls. 

Team members = 5

Now, required number of ways in which a team of 5 having atleast 3 girls in the team = 

6C3  x 7C2  + 6C4 x 7C1 + 6C5= 6x5x43x2x1 x 7x62x1 + 6x5x4x34x3x2x1 x 7 + 6x5x4x3x25x4x3x2x1= 420 + 105 + 6= 531.

Report Error

View Answer Report Error Discuss

5 3836
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

5 3834
Q:

What's the difference between Session and Cookie?

Answer

The principle distinction amongst sessions and cookies is that sessions are put away on the server, and cookies are put away on the client's PCs in the content record position. Cookies can not hold various variables,But Session can hold numerous variables.We can set expiry for a cookie,The session just stays dynamic the length of the program is open.Users don't have admittance to the information you put away in Session,Since it is put away in the server. Session is mostly utilized for login/logout reason while cookies utilizing for client movement following.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

1 3833
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

3 3822