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. |
If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side? |
| A. | tThey are given null values |
| B. | tThey are given a random value |
| C. | tThe user is asked to enter data |
| D. | tThe query is declared invalid by the compiler |
| Answer» B. tThey are given a random value | |
| 2. |
Which off the following is not a valid type of join? |
| A. | tleft outer join |
| B. | touter join |
| C. | tjoin |
| D. | tfull join |
| Answer» E. | |
| 3. |
State true or false: on and where behave differently for outer join |
| A. | tTrue |
| B. | tFalse |
| Answer» B. tFalse | |
| 4. |
What is the function of a right outer join? |
| A. | tIt preserves tuples only in the relation named before the operation |
| B. | tIt preserves tuples only in the relation named after the operation |
| C. | tIt preserved tuples in the relations named on both the sides of the operation |
| D. | tIt does not preserve any tuples on either side of the relation |
| Answer» C. tIt preserved tuples in the relations named on both the sides of the operation | |
| 5. |
What is the function of a full outer join? |
| A. | tIt preserves tuples only in the relation named before the operation |
| B. | tIt preserves tuples only in the relation named after the operation |
| C. | tIt preserved tuples in the relations named on both the sides of the operation |
| D. | tIt does not preserve any tuples on either side of the relation |
| Answer» D. tIt does not preserve any tuples on either side of the relation | |