Top 50+ Solved Relational Database Design MCQ Questions Answer
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
Q. The main task carried out in the __________ is to remove repeating attributes toseparate tables.
a. First Normal Form
b. Second Normal Form
c. Third Normal Form
d. Fourth Normal Form
Q. Which forms has a relation that possesses data about an individual entity?
a. 2NF
b. 3NF
c. 4NF
d. 5NF
Q. Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set?
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. None of the mentioned
Q. Fifth Normal form is concerned with
a. Functional dependency
b. Multivalued dependency
c. Join dependency
d. Domain-key
Q. n which of the following, a separate schema is created consisting of that attribute andthe primary key of the entity set.
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. None of the mentioned
Q. In 2NF
a. No functional dependencies (FDs) exist
b. No multivalued dependencies (MVDs) exist
c. No partial FDs exist
d. No partial MVDs exist