Classical

Database MCQ - Database design

21:  

Manager's salary details are hidden from the employee. This is 

A.

conceptual level data hiding

B.

physical level data hiding

C.

external level data hiding

D.

none of these 

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



22:  

The employee salary should not be greater than Rs. 2000. This is 

A.

 integrity constraint

B.

referential constraint

C.

over-defined constraint

D.

feasible constraint 

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



23:  

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period offtime 

A.

Report writer

B.

Query language

C.

Data manipulation language

D.

Transaction log 

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



24:  

Updating a data base means 

A.

revising the file structure

B.

reorganizing the database

C.

 modifying or adding record occurrences 

D.

All of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



25:  

Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time

A.

4-GL

B.

d-BASE

C.

Oracle

D.

SQL

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



Related MCQ




*********
X