Database Administration Questions


Q:

Which one of the following sorts rows in SQL?

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

Explanation:
Report Error

View Answer Report Error Discuss

0 5654
Q:

Important Time and Distance formulas with examples.

Answer

1. How to find Speed(s) if distance(d) & time(t) is given:


 


 Speed (S) = Distance (D)Time (T)  


 


Ex: Find speed if a person travels 4 kms in 2 hrs?


Speed = D/T = 4/2 = 2 kmph.


 


2.  Similarly, we can find distance (d)  if speed (s) & time (t) is given by


 


Distance (D) = Speed (S) x Time (T)


 


Ex : Find distance if a person with a speed of 2 kmph in 2 hrs?


Distance D = S X T = 2 x 2 = 4 kms. 


 


3.  Similarly, we can find time (t) if speed (s) &  distance (d) is given by


 


Time (T) = Distance (D)Speed (S)


 


Ex : Find in what time a person travels 4 kms with a speed of 2 kmph?


Time T = D/S = 4/2 = 2 hrs.


 


4. How to convert  km/hr into m/sec :


 


P km/hr = P x 518 m/sec


 


Ex : Convert 36 kmph into m/sec?


36 kmph = 36 x 5/18 = 10 m/sec 


 


5. How to convert  m/sec into km/hr :


 


P m/sec = P x 185 kmph.


 


Ex : Convert 10 m/sec into km/hr?


10 m/sec = 10 x 18/5 = 36 kmph.


 


6.  If the ratio of the speeds of A and B is a:b, then the ratio of the times taken by them to cover the same distance is b : a.


 


7.  Suppose a man covers a certain distance at x km/ hr and an equal distance at y km/hr . Then, the average speed during the whole journey is 2xyx+y km/hr.

Report Error

View answer Workspace Report Error Discuss

6 5650
Q:

What has a foot but no legs?

Answer

A measuring device.


 


Measuring devices have feet on them to measure distance.

Report Error

View answer Workspace Report Error Discuss

8 5645
Q:

Solve the Math puzzle?

maths_puzzle1535777263.jpg image

A) 9 B) 15
C) 6 D) 12
 
Answer & Explanation Answer: C) 6

Explanation:

In the given puzzle, the logic is the product of the number and its preceeding number gives the result.

 

9 = 9 x 8 = 72

8 = 8 x 7 = 56

7 = 7 x 6 = 42

6 = 6 x 5 = 30

5 = 5 x 4 = 20

 

Similarly,

3 = 3 x 2 = 6.

Report Error

View Answer Report Error Discuss

13 5624
Q:

Verification of a login name and password is known as

A) Trouble shooting B) Logging in
C) Configuration D) Authentication
 
Answer & Explanation Answer: D) Authentication

Explanation:

Verification of a login name and password is known as Authentication.

Report Error

View Answer Report Error Discuss

9 5550
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 5539
Q:

The PHP Syntax is most similar to

A) Visual Basic B) VB Script
C) PERL & C D) Java Script
 
Answer & Explanation Answer: C) PERL & C

Explanation:

PHP is similar to the C style syntax in terms of keywords and language syntax.

 

If conditions, for and while loops, and function returns are similar in syntax to languages such as C, C++, C#, Java and Perl.

Report Error

View Answer Report Error Discuss

1 5530
Q:

CPU speed of a personal computer is

A) 1 MIPS B) 100 KIPS
C) 32 KIPS D) 32 MIPS
 
Answer & Explanation Answer: C) 32 KIPS

Explanation:

Instructions per second (IPS) is a measure of a computer's processor speed. CPU speed of a personal computer is 32 KIPS (Kilo Instructions per second).

Report Error

View Answer Report Error Discuss

5 5505