Database Administration Questions


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 5035
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 5012
Q:

Logical puzzle

You have 10 coins….arrange them in 4 straight lines such that each line contains 4 coins.

Report Error

View answer Workspace Report Error Discuss

27 4986
Q:

Can character data be stored in computer memory? 

A) Yes---a primitive data type is used to store characters B) No---computer memory can only store patterns
C) Yes---characters are stored in special memory D) No---computers can only store numbers
 
Answer & Explanation Answer: A) Yes---a primitive data type is used to store characters

Explanation:
Report Error

View Answer Report Error Discuss

7 4980
Q:

Prince of Wales cup is associated with the game of

A) Golf B) Hockey
C) Volleyball D) Basketball
 
Answer & Explanation Answer: A) Golf

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Sports
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

8 4979
Q:

A sum is equally invested in two different schemes on CI at the rate of 15% and 20% for two years. If interest gained from the sum invested at 20% is Rs. 528.75 more than the sum invested at 15%, find the total sum?

A) Rs. 7000 B) Rs. 4500
C) Rs. 9000 D) Rs. 8200
 
Answer & Explanation Answer: C) Rs. 9000

Explanation:

Let Rs. K invested in each scheme

Two years C.I on 20% = 20 + 20 + 20x20/100 = 44%

Two years C.I on 15% = 15 + 15 + 15x15/100 = 32.25%

Now,

(P x 44/100) - (P x 32.25/100) = 528.75

=> 11.75 P = 52875

=> P = Rs. 4500

 

Hence, total invested money = P + P = 4500 + 4500 = Rs. 9000.

Report Error

View Answer Report Error Discuss

19 4944
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 4940
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 4905