Database Administration Questions


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 5265
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 5248
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 5237
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 5203
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 5199
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 5154
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 5127
Q:

IP address is currently

A) 4 bytes long B) available in plenty
C) 6 bytes long D) not assigned as it is all used up
 
Answer & Explanation Answer: A) 4 bytes long

Explanation:

IP address is currently 4 bytes long. An IP address is written in "dotted decimal" notation, which is 4 sets of numbers separated by period each set representing 8-bit number ranging from (0-255).

Report Error

View Answer Report Error Discuss

1 5117