Advance Database Management System (ADBMS) MCQs and Notes

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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.

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

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

(A) Attribute set

(B) Attentive range

(C) Domain

(D) Group

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. 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

Renu Phogat Advance Database Management System (ADBMS)
Master · 1.50K points

Q. In transactions, in ACID property A stands for

(A) Atomicity

(B) Acidity

(C) Alphabetically

(D) None of the above

Advance Database Management System (ADBMS)

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

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

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

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

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

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

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

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

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

Q. In transactions, in ACID property A stands for

Contributors

More Faculties

Basics of Database Management System

Basics of Computer Architecture

Assam State General Knowledge

MCA - Multimedia Technologies

Advanced Web Technologies

Current Affairs May 2023

8086 Microprocessor

Computer Architecture

8085 Microprocessor

Advance Database Management System (ADBMS)