Database Management System (DBMS) MCQ Questions and answers

A

Admin • 833.24K Points
Coach

Q. Which forms has a relation that possesses data about an individual entity:

(A) 2NF
(B) 3NF
(C) 4NF
(D) 5NF

A

Admin • 833.24K Points
Coach

Q. Which forms are based on the concept of functional dependency:

(A) 1NF
(B) 2NF
(C) 3NF
(D) 4NF

A

Admin • 833.24K Points
Coach

Q. Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

(A) 1 NF only
(B) 2 NF and hence also in 1 NF
(C) 3NF and hence also in 2NF and 1NF
(D) BCNF and hence also in 3NF, 2NF and 1NF

A

Admin • 833.24K Points
Coach

Q. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

(A) Axioms
(B) Armstrong’s axioms
(C) Armstrong
(D) Closure

A

Admin • 833.24K Points
Coach

Q. Which of the following is not Armstrong’s Axiom?

(A) Reflexivity rule
(B) Transitivity rule
(C) Pseudotransitivity rule
(D) Augmentation rule

A

Admin • 833.24K Points
Coach

Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)
employee2 (name, street, city, salary) This type of decomposition is called

(A) Lossless decomposition
(B) Lossless-join decomposition
(C) All of the mentioned
(D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under

(A) Lossy-join decomposition
(B) Lossy decomposition
(C) Lossless-join decomposition
(D) Both Lossy and Lossy-join decomposition

A

Admin • 833.24K Points
Coach

Q. There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC A->B
This can be combined as

(A) A->BC
(B) A->B
(C) B->C
(D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE and
D -> AB The number of superkeys of R is:

(A) 2
(B) 7
(C) 10
(D) 12

A

Admin • 833.24K Points
Coach

Q. Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?

(A) Both I and II
(B) I only
(C) II only
(D) Neither I nor I

Database Management System (DBMS) MCQs with answers Page - 47

Q. Which forms has a relation that possesses data about an individual entity:

Q. Which forms are based on the concept of functional dependency:

Q. Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

Q. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

Q. Which of the following is not Armstrong’s Axiom?

Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)
employee2 (name, street, city, salary) This type of decomposition is called

Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under

Q. There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC A->B
This can be combined as

Q. Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE and
D -> AB The number of superkeys of R is:

Q. Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?

Add MCQ in this Category

Browse Categories

Database Management System (DBMS) MCQs with answers Page - 47

Q. Which forms has a relation that possesses data about an individual entity:

Q. Which forms are based on the concept of functional dependency:

Q. Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

Q. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

Q. Which of the following is not Armstrong’s Axiom?

Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary) This type of decomposition is called

Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under

Q. There are two functional dependencies with the same set of attributes on the left side of the arrow: A->BC A->B This can be combined as

Q. Consider a relation R(A,B,C,D,E) with the following functional dependencies: ABC -> DE and D -> AB The number of superkeys of R is:

Q. Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?

Add MCQ in this Category

Browse Categories

Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)
employee2 (name, street, city, salary) This type of decomposition is called

Q. There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC A->B
This can be combined as

Q. Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE and
D -> AB The number of superkeys of R is: