Database Administration Questions


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

44 7428
Q:

12 boys decided to constribute Rs. 750 each to an Orphange. Suddenly few of them boys dropped out and consequently the rest had to pay Rs. 150 more. Then the number of boys who dropped out?

A) 4 B) 6
C) 2 D) 3
 
Answer & Explanation Answer: C) 2

Explanation:

Total money decided to contribute = 750 x 12 = 9000

Let 'b' boys dropped

The rest paid 150/- more

=> (12 - b) x 900 = 9000

=> b = 2

Hence, the number of boys who dropped out is 2.

Report Error

View Answer Report Error Discuss

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

26 7267
Q:

The brain of any computer system is

A) CPU B) Memory
C) Control D) ALU
 
Answer & Explanation Answer: A) CPU

Explanation:

Central Processing Unit (CPU) is the brain of any computer system.

Report Error

View Answer Report Error Discuss

19 7249
Q:

A DBMS query language is designed to

A) Specify the structure of a database B) Support in the development of complex applications software
C) Support end users who use English-like commands D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

2 7221
Q:

Fifth generation computer is also known as

A) Very Large Scale Integration (VLSI) B) Knowledge information processing system
C) Both A & B D) None of the above
 
Answer & Explanation Answer: B) Knowledge information processing system

Explanation:
Report Error

View Answer Report Error Discuss

13 7177
Q:

A shop keeper sells an article at a loss of 8%, but when he increases the selling price of the article by Rs. 164 he earns a profit of 2.25% on the cost price. If he sells the same article at Rs. 1760, what is his profit percentage?

A) 2.5% B) 5%
C) 10% D) 7.5%
 
Answer & Explanation Answer: C) 10%

Explanation:

According to the given data,

Let Cost price of the article be 'cp'

Then,

102.25 cp - 92 cp = 164 x 100

10.25 cp = 16400

cp = 1600

Now, if he sells at Rs. 1760

Profit = 1760 - 1600 = 160

 

Profit% = 160/1600 x 100 = 10%.

 

Report Error

View Answer Report Error Discuss

10 7161
Q:

What is always coming but never arrives?

Answer

It is Tomorrow. It always be tomorrow which represents coming but never arrives.

Report Error

View answer Workspace Report Error Discuss

7 7105
Q:

80% of 900 + 162 x 4 x ? = 113 - 99

A) 0.5 B) 1
C) 4 D) 0
 
Answer & Explanation Answer: A) 0.5

Explanation:

80x900/100 + 256 x 4 x ? = 1331 - 99

720 + 1024 x ? = 1232

? = 1232 - 720/1024

? = 512/1024 = 0.5

? = 0.5 

Report Error

View Answer Report Error Discuss

Filed Under: Percentage
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

11 7040