Advance Database Management System (ADBMS) MCQs

R

Renu Phogat • 1.50K Points
Master

Q 1. If every non-key attribute is functionally dependent on the primary key, then the relationwill be in

(A) First normal form
(B) Second normal form
(C) Third normal form
(D) Fourth normal form
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

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

(A) X→Z
(B) W→Z
(C) X→WY
(D) None of the above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

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

(A) First normal form
(B) Second normal form
(C) Third normal form
(D) Fourth normal form
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

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

(A) Foreign key
(B) Secondary key
(C) Candidate key
(D) Composite key
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

Q 5. If a relation scheme is in BCNF, then it is also in

(A) First normal form
(B) Second normal form
(C) Third normal form
(D) Fourth normal form
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

Q 6. A primary key when combined with a foreign key create

(A) Parent child relationship between the tables that connect them.
(B) Network model between the tables that connect them.
(C) Many-to-many relationship between the tables that connect them.
(D) None of the above.
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

Q 7. The set of permitted value for each attribute is called its

(A) Attribute set
(B) Attentive range
(C) Domain
(D) Group
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

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

(A) Flight number
(B) Flight number + place of departure
(C) Flight number+ date
(D) Flight number + destination
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

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

(A) YC= X
(B) Y C X
(C) X C =Y
(D) X C Y and Y C X
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

R

Renu Phogat • 1.50K Points
Master

Q 10. In transactions, in ACID property A stands for

(A) Atomicity
(B) Acidity
(C) Alphabetically
(D) None of the above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share