MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 20 Mcqs, each offering curated multiple-choice questions to sharpen your Database 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. | 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 | |
| 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. |
State true or false: on and where behave differently for outer join |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
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. | |
| 5. |
What is the function of a right 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» C. It preserved tuples in the relations named on both the sides of the operation | |
| 6. |
What is the function of a full 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» D. It does not preserve any tuples on either side of the relation | |
| 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. |
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 | |
| 10. |
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 | |
| 11. |
WHICH_VIEW_THAT_CONTAINS_MORE_THAN_ONE_TABLE_IN_THE_TOP-LEVEL_FROM_CLAUSE_OF_THE_SELECT_STATEMENT:?$ |
| A. | Join view |
| B. | Datable join view |
| C. | Updatable join view |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 12. |
Which operation are allowed in a join view? |
| A. | UPDATE |
| B. | INSERT |
| C. | DELETE |
| D. | All of the mentioned |
| Answer» E. | |
| 13. |
Which join refers to join records from the write table that have no matching key in the left table are include in the result set: |
| A. | Left outer join |
| B. | Right outer join |
| C. | Full outer join |
| D. | Half outer join |
| Answer» C. Full outer join | |
| 14. |
Which is a join condition contains an equality operator: |
| A. | Equijoins |
| B. | Cartesian |
| C. | Both Equijoins and Cartesian |
| D. | None of the mentioned |
| Answer» B. Cartesian | |
| 15. |
Which product is returned in a join query have no join condition: |
| A. | Equijoins |
| B. | Cartesian |
| C. | Both Equijoins and Cartesian |
| D. | None of the mentioned |
| Answer» C. Both Equijoins and Cartesian | |
| 16. |
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» E. | |
| 17. |
How many join types in join condition: |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» E. | |
| 18. |
Which oracle is the join condition is specified using the WHERE clause: |
| A. | Oracle 9i |
| B. | Oracle 8i |
| C. | Pre-oracle 9i |
| D. | Pre-oracle 8i |
| Answer» D. Pre-oracle 8i | |
| 19. |
A condition is referred to as __________ |
| A. | Join in SQL |
| B. | Join condition |
| C. | Join in SQL & Condition |
| D. | None of the mentioned |
| Answer» C. Join in SQL & Condition | |
| 20. |
A_____ is a query that retrieves rows from more than one table or view: |
| A. | Start |
| B. | End |
| C. | Join |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |