Quiz about Advanced Database Management Systems (ADBMS)

Question 1

If every non-key attribute is functionally dependent on the primary key, then the relation
will be in:

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Fourth normal form

Question 2

Given the functional dependencies  X →W; X→Y; Y→Z and Z→PQ   Which of the following doesn’t hold well?

Accepted Answer

W→Z

Answer

X→Z

Answer

X→WY

Answer

None of the above

Question 3

Relations produced from an E-R model will always be in

Accepted Answer

First normal form

Answer

Second normal form

Answer

Third normal form

Answer

Fourth normal form

Question 4

An attribute of one table matching the primary key of another table, is called as

Accepted Answer

Foreign key

Answer

Secondary key

Answer

Candidate key

Answer

Composite key

Question 5

If a relation scheme is in BCNF, then it is also in

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Fourth normal form

Question 6

A primary key when combined with a foreign key create

Accepted Answer

Parent child relationship between the tables that connect them.

Answer

Network model between the tables that connect them.

Answer

Many-to-many relationship between the tables that connect them.

Answer

None of the above.

Question 7

The set of permitted value for each attribute is called its

Accepted Answer

Domain

Answer

Attribute set

Answer

Attentive range

Answer

Group

Question 8

The airline reservation system, the enables are date, flight number, place of departure,
destination, type of plane & seats available. The primary key is

Accepted Answer

Flight number+ date

Answer

Flight number

Answer

Flight number + place of departure

Answer

Flight number + destination

Question 9

A functional dependency of the form X→Y is trivial if

Accepted Answer

YC= X

Answer

Y C X

Answer

X C =Y

Answer

X C Y and Y C X

Question 10

In transactions, in ACID property A stands for

Accepted Answer

Atomicity

Answer

Acidity

Answer

Alphabetically

Answer

None of the above.

Practice Test On: Advanced Database Management Systems (ADBMS)

Practice Test On:
Advanced Database Management Systems (ADBMS)