MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
F+ is called as the ________ of F |
| A. | tClosure |
| B. | tSum |
| C. | tCartesian product |
| D. | tNone of the mentioned |
| Answer» B. tSum | |
| 2. |
Which of the following is not a condition for the third normal form in the case of X Y? |
| A. | tX Y is trivial |
| B. | tX is the superkey for R |
| C. | tEach attribute in Y-X is a candidate key for R |
| D. | tEach attribute in X-Y is a candidate key for R |
| Answer» E. | |
| 3. |
Which of the following is not a condition for X Y in Boyce codd normal form? |
| A. | tX Y is trivial |
| B. | tX is the superkey for the relational schema R |
| C. | tY is the superkey for the relational schema R |
| D. | tAll of the mentioned |
| Answer» D. tAll of the mentioned | |
| 4. |
X Y is trivial if? |
| A. | tX Y |
| B. | tY X |
| C. | tX Y |
| D. | tNone of the mentioned |
| Answer» B. tY X | |
| 5. |
X Y holds on a schema k(K) if? |
| A. | tAt least one legal instance satisfies the functional dependency |
| B. | tNo legal instance satisfies the functional dependency |
| C. | tEach and every legal instance satisfies the functional dependency |
| D. | tNone of the mentioned |
| Answer» D. tNone of the mentioned | |
| 6. |
If K R then K is said to be the _______ of R |
| A. | tCandidate key |
| B. | tForeign key |
| C. | tSuper key |
| D. | tDomain |
| Answer» D. tDomain | |