Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
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
Q. Which of the following is not Armstrong’s Axiom?
a. Reflexivity rule
b. Transitivity rule
c. Pseudotransitivity rule
d. Augmentation rule
Q. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (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
Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed intoinstructor (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
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
Q. Which, if any, of the two queries above will correctly (in SQL2) get the desired set ofemployee ID’s?
a. Both I and II
b. I only
c. II only
d. Neither I nor I
Q. Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in theresult of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
a. m = min(r,s)
b. 0 <= m <= r + s
c. min(r,s) <= m <= max(r,s)
d. 0 <= m <= min(r,s)
Q. Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
a. Both the statements are true
b. Statement 1 is correct but Statement 2 is false
c. Statement 1 is false but Statement 2 is correct
d. Both the statements are false
Q. The____condition allows a general predicate over the relations being joined.
a. On
b. Using
c. Set
d. Where
Q. Which of the join operations do not preserve non matched tuples?
a. Left outer join
b. Right outer join
c. Inner join
d. Natural join
Q. The normal form which satisfies multivalued dependencies and which is in BCNF is
a. 4 NF
b. 3 NF
c. 2 NF
d. All of the mentioned
Q. Which of the following is a tuple-generating dependencies?
a. Functional dependency
b. Equality-generating dependencies
c. Multivalued dependencies
d. Non-functional dependency