Database Design Process - DBMS

1.

Designers use which of the following to tune performance of systems to support time-critical operations?

   A.) Redundant optimization
   B.) Denormalization
   C.) Optimization
   D.) Realization

Answer: Option 'B'

Denormalization

2.

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

   A.) Instance
   B.) Snapshot
   C.) Both a and b
   D.) All of the mentioned

Answer: Option 'B'

Snapshot

3.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

   A.) A many-to-many relationship set
   B.) A multivalued attribute of an entity set
   C.) A one-to-many relationship set
   D.) Both a and b

Answer: Option 'D'

Both a and b

4.

In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.

   A.) A many-to-many relationship set
   B.) A multivalued attribute of an entity set
   C.) A one-to-many relationship set
   D.) Both a and b

Answer: Option 'B'

A multivalued attribute of an entity set

5.

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in

   A.) Fourth NF
   B.) BCNF
   C.) Third NF
   D.) Second NF

Answer: Option 'B'

BCNF

Database Design Process Download Pdf