Classical

Database MCQ - Database design

21:  

Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe following functional dependecies:
I. Title Author —› Catalog no.
II. Catalog_no ---> Title Author Publisher Year
III. Publisher Title Year --> Price.
Assume {Author, Title) is the key for both schemes: which ofthe following statements is true?

A.

Both Book and collection are in BCNF

B.

Both Book and collection are in 3NF only

C.

Book is in 2NF and Collection is in 3NF

D.

Both Book and Collection are in 2NF only

 
 

Option: C

Explanation :


22:  

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 :


23:  

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 :


24:  

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 :


25:  

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 :




Suggest an improvement