Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. A DBMS query language is designed to
a. support end users who use English-like commands.
b. support in the development of complex applications software.
c. specify the structure of a database.
d. all of the above.
Q. Which of the following is correct
a. a SQL query automatically eliminates duplicates.
b. SQL permits attribute names to be repeated in the same relation.
c. a SQL query will not work if there are no indexes on the relations
d. None of these
Q. Which of the following is a legal expression in SQL?
a. SELECT NULL FROM EMPLOYEE;
b. SELECT NAME FROM EMPLOYEE;
c. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
d. none of the above
Q. If every non-key attribute is functionally dependent on the primary key, then therelation will 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. Third normal form is inadequate in situation where the relation
a. Has multiple candidate keys
b. Has candidate keys that are composite
c. Has overlapped candidate keys
d. None of the above
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. The concept of locking can be used to solve the problem of
a. Lost update
b. Uncommitted dependency
c. Inconsistent data
d. Deadlock
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. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)
a. it is not in 2 NF
b. it does not have composite key
c. non-key attributes course no and course max. marks are functionally dependent
d. it has more than 3 non-key attributes