MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
HOW_MANY_TABLES_MAY_BE_INCLUDED_WITH_A_JOIN??$ |
| A. | One |
| B. | Two |
| C. | Three |
| D. | All of the mentioned |
| Answer» B. Two | |
| 2. |
WHICH_OFF_THE_FOLLOWING_IS_NOT_A_VALID_TYPE_OF_JOIN??$ |
| A. | left outer join |
| B. | outer join |
| C. | join |
| D. | full join |
| Answer» E. | |
| 3. |
Which_are_the_join_types_in_join_condition:$ |
| A. | Cross join |
| B. | Natural join |
| C. | Join with USING clause |
| D. | All of the mentioned |
| Answer» C. Join with USING clause | |
| 4. |
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. | They are given null values |
| B. | They are given a random value |
| C. | The user is asked to enter data |
| D. | The query is declared invalid by the compiler |
| Answer» B. They are given a random value | |
| 5. |
State true or false: on and where behave differently for outer joi? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
What is the function of inner join? |
| A. | It preserves tuples only in the relation named before the operation |
| B. | It preserves tuples only in the relation named after the operation |
| C. | It preserved tuples in the relations named on both the sides of the operation |
| D. | It does not preserve any tuples on either side of the relation |
| Answer» E. | |
| 7. |
What is the function of a left outer join? |
| A. | It preserves tuples only in the relation named before the operation |
| B. | It preserves tuples only in the relation named after the operation |
| C. | It preserved tuples in the relations named on both the sides of the operation |
| D. | It does not preserve any tuples on either side of the relation |
| Answer» B. It preserves tuples only in the relation named after the operation | |
| 8. |
The join operations that do not retain mismatched tuples are called as _________ operations |
| A. | outer join |
| B. | natural join |
| C. | full outer join |
| D. | inner join |
| Answer» E. | |
| 9. |
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 |
| Answer» D. Natural join | |
| 10. |
What is the difference between a join and an outer join operation? |
| A. | There is no difference |
| B. | Join preserves a few tuples that are otherwise lost in the outer join |
| C. | Outer join preserves a few tuples that are otherwise lost in the join |
| D. | An outer join can be used only on outer queries whereas a join operation can be used in Subqueries |
| Answer» D. An outer join can be used only on outer queries whereas a join operation can be used in Subqueries | |
| 11. |
The on condition appears at the _______ of the join expression |
| A. | Beginning |
| B. | End |
| C. | Between |
| D. | The on condition is not related to join expression |
| Answer» C. Between | |