Top 150+ Solved Advanced Database Management Systems (ADBMS) MCQ Questions Answer
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
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
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
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
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.
Q. The set of permitted value for each attribute is called its
a. Attribute set
b. Attentive range
c. Domain
d. Group
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
Q. In transactions, in ACID property A stands for
a. Atomicity
b. Acidity
c. Alphabetically
d. None of the above.
Q. Which property ensures that each functional dependency is represented in someindividual relations resulting after decomposition?
a. Dependency preservation property
b. Fully Functional dependency
c. Lossless Join
d. None of the above
Q. A table that contains one or more repeating groups is in which normal form?
a. 1NF
b. 2NF
c. 3NF
d. Unnormalized Form
Q. The DBMS acts as an interface between what two components of an enterprise-classdatabase system?
a. Database application and the database
b. Data and the database
c. The user and the database application
d. Database application and SQL
Q. Which of the following products was an early implementation of the relational modeldeveloped by E.F. Codd of IBM?
a. IDMS
b. DB2
c. dBase-II
d. R:base
Q. The following are components of a database except ________ .
a. user data
b. Metadata
c. Reports
d. Indexes
Q. An application where only one user accesses the database at a given time is an exampleof a(n) ________ .
a. single-user database application
b. multiuser database application
c. e-commerce database application
d. data mining database application