MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: The aggregation functions can be implemented in the same way as that of duplicate elimination. |
| A. | tTrue |
| B. | tFalse |
| Answer» B. tFalse | |
| 2. |
Which of the following joins preserves the tuples of the relation on the left side of the operator? |
| A. | tLeft outer join |
| B. | tNatural join |
| C. | tRight outer join |
| D. | tNone of the mentioned |
| Answer» B. tNatural join | |
| 3. |
Which of the following is not a set operation |
| A. | tUnion |
| B. | tIntersection |
| C. | tAnd operation |
| D. | tSet difference |
| Answer» D. tSet difference | |
| 4. |
Overflow resolution is performed when, |
| A. | tA hash index overflow is detected |
| B. | tExtra hash indices are to be added |
| C. | tWhen the number of partitions are to be increased |
| D. | tNone of the mentioned |
| Answer» B. tExtra hash indices are to be added | |
| 5. |
A join of the form r r.A=s.B s is called as |
| A. | tEqui join |
| B. | tLeft outer join |
| C. | tRight outer join |
| D. | tFull outer join |
| Answer» B. tLeft outer join | |