Question:

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.

A.

Cross-tabs

B.

Snapshot

C.

Both Cross-tabs and Snapshot

D.

All of the mentioned

Answer» a. Cross-tabs

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