MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________ |
| A. | CARTESIAN JOIN |
| B. | CROSS JOIN |
| C. | INNER JOIN |
| D. | RIGHT JOIN |
| Answer» E. | |
| 2. |
In which join all the rows from the left table appear in the output irrespective of the content of the other table? |
| A. | RIGHT JOIN |
| B. | LEFT JOIN |
| C. | INNER JOIN |
| D. | OUTER JOIN |
| Answer» C. INNER JOIN | |
| 3. |
IN_WHICH_JOIN_ALL_THE_ROWS_FROM_THE_LEFT_TABLE_APPEAR_IN_THE_OUTPUT_IRRESPECTIVE_OF_THE_CONTENT_OF_THE_OTHER_TABLE??$ |
| A. | RIGHT JOIN |
| B. | LEFT JOIN |
| C. | INNER JOIN |
| D. | OUTER JOIN |
| Answer» C. INNER JOIN | |
| 4. |
The_join_in_which_all_the_rows_from_the_right_table_appear_in_the_output_irrespective_of_the_content_of_the_other_table_is____________$ |
| A. | CARTESIAN JOIN |
| B. | CROSS JOIN |
| C. | INNER JOIN |
| D. | RIGHT JOIN |
| Answer» E. | |
| 5. |
What is joining a table to itself called? |
| A. | COMPLETE |
| B. | SELF |
| C. | OBSOLETE |
| D. | CROSS |
| Answer» C. OBSOLETE | |
| 6. |
The left and right joins are also known as __________ |
| A. | INNER JOIN |
| B. | NATURAL JOIN |
| C. | OUTER JOIN |
| D. | CARTESIAN JOIN |
| Answer» D. CARTESIAN JOIN | |
| 7. |
The comma operator can also be used to join tables. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
CROSS JOIN and JOIN are similar to __________ |
| A. | INNER JOIN |
| B. | NATURAL JOIN |
| C. | OUTER JOIN |
| D. | CARTESIAN JOIN |
| Answer» B. NATURAL JOIN | |
| 9. |
The clause that filters JOIN results is called _________ |
| A. | WHERE |
| B. | SORT |
| C. | GROUP |
| D. | GROUP BY |
| Answer» B. SORT | |
| 10. |
The join where all possible row combinations are produced is called _________ |
| A. | INNER JOIN |
| B. | OUTER |
| C. | NATURAL |
| D. | CARTESIAN |
| Answer» E. | |
| 11. |
In inner join, result is produced by matching rows in one table with rows in another table. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? |
| A. | select_list |
| B. | table_list |
| C. | row_constraint |
| D. | grouping_columns |
| Answer» B. table_list | |