Database Administration Questions


Q:

A sum of Rs. 8,000 is deposited for 3 years at 5% per annum compound interest (compounded annually). The difference of interest for 3 years and 2 years will be

 

A) Rs. 387 B) Rs. 441
C) Rs. 469 D) Rs. 503
 
Answer & Explanation Answer: B) Rs. 441

Explanation:

Given principal amount = Rs. 8000

Time = 3yrs

Rate = 5%

C.I for 3 yrs = 8000 x 105100 x 105100 x 105100 - 8000= Rs. 1261

 

Now, C.I for 2 yrs = 8000 x 105100 x 105100= Rs. 820 

 

Hence, the required difference in C.I is 1261 - 820 = Rs. 441

Report Error

View Answer Report Error Discuss

14 6521
Q:

The ratio of K’s and M’s ages is 4: 5. If the difference between the present age of M and the age of K, 5 years hence is 3 years, then what is the difference and total of present ages of K and M?

A) 8, 72 yrs B) 16, 65 yrs
C) 12, 84 yrs D) 10, 60 yrs
 
Answer & Explanation Answer: A) 8, 72 yrs

Explanation:

Let the present ages be K,M

Given K/M = 4/5

5K - 4M = 0 ......(1)

Also given that,

M - (K + 5) = 3

M - K = 8 .........(2)


Then, by solving (1) & (2)

M = 40 yrs and K = 32 yrs

Hence, Total of ages = 40 + 32 = 72 yrs

Difference of ages = 40 - 32 = 8 yrs.

Report Error

View Answer Report Error Discuss

3 6486
Q:

Only if Sheela is happy, then she does not go to work.

A) Sheela is not happy and she goes to work. B) Sheela is happy and she does not go to work
C) Sheela is not happy and she does not go to work. D) Sheela is happy and she goes to work.
 
Answer & Explanation Answer: A) Sheela is not happy and she goes to work.

Explanation:

The event of "Sheela is not going to work" happens only when the event "Sheela is happy" happens. Also, if the event "Sheela is happy" does not happen, then the event "Sheela is not going to work" will not happen. In other words, if it is true that Sheela is not happy, then it means that Sheela is going to work.

Report Error

View Answer Report Error Discuss

21 6472
Q:

The memory unit is one part of

A) Input Device B) Central Processing Unit
C) Control Unit D) Output device
 
Answer & Explanation Answer: B) Central Processing Unit

Explanation:

In a computer, memory is one part of Central processing unit i.e, CPU.

Report Error

View Answer Report Error Discuss

14 6465
Q:

GUI stands for

A) Graphical Universal Interface B) Graph Use Interface
C) Graphical Unique Interface D) Graphical User Interface
 
Answer & Explanation Answer: D) Graphical User Interface

Explanation:

GUI stands for Graphical User Interface.

 

A Graphical User Interface is a computer interface that allows users to interact with a device through graphical elements such as pictures and animations, as opposed to text-based commands.

Report Error

View Answer Report Error Discuss

9 6423
Q:

Although glory but not at my best. Power will fall to me when the man who made me dies. What am I?

Answer

PRINCE.

Report Error

View answer Workspace Report Error Discuss

20 6370
Q:

Find the speed of stream if a boat covers 36 km in downstream in 6 hours which is 3 hours less in covering the same distance in upstream?

A) 1.5 kmph B) 1 kmph
C) 0.75 kmph D) 0.5 kmph
 
Answer & Explanation Answer: B) 1 kmph

Explanation:

Speed of the boat upstream = 36/9 = 4 kmph

Speed of the boat in downstream = 36/6 = 6 kmph

Speed of stream = 6-4/2 = 1 kmph

Report Error

View Answer Report Error Discuss

18 6341
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

7 6329