Question:

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

A.

Instance

B.

Snapshot

C.

Both Instance and Snapshot

D.

All of the mentioned

Answer» b. Snapshot

Question:

Which of the following gives a logical structure of the database graphically?

A.

Entity-relationship diagram

B.

Entity diagram

C.

Database diagram

D.

Architectural representation

Answer» a. Entity-relationship diagram

Question:

_____________ can help us detect poor E-R design.

A.

Database Design Process

B.

E-R Design Process

C.

Relational scheme

D.

Functional dependencies

Answer» d. Functional dependencies

Question:

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here theonly 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» b. BCNF

Question:

Which of the following is example of Object based logical model ?

A.

Relational Model

B.

Hierarchical Model

C.

Network Model

D.

Entity Relationship Model

Answer» d. Entity Relationship Model

Question:

Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set.

A.

A many-to-many relationship set

B.

A multivalued attribute of an entity set

C.

A one-to-many relationship set

D.

All of the mentioned

Answer» a. A many-to-many relationship set

Question:

Data Model is collection of conceptual tools for describing –

A.

Data

B.

All of these

C.

Data Schema

D.

Consistency Constaints

Answer» b. All of these

Question:

Designers use which of the following to tune the performance of systems to support timecritical operations?

A.

Denormalization

B.

Redundant optimization

C.

Optimization

D.

Realization

Answer» a. Denormalization

Question:

In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Whichdependency have lead to this relation ?

A.

Dept name, year->size

B.

Year->size

C.

Dept name->size

D.

Size->year

Answer» a. Dept name, year->size

Question:

If a multivalued dependency holds and is not implied by the corresponding functionaldependency, 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 many-to-many relationship set and A multivalued attribute of an entity set

Answer» d. Both A many-to-many relationship set and A multivalued attribute of an entity set