MCQOPTIONS
Saved Bookmarks
This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Select_name,course_id_from_teaches,instructor_where_instructor_id=course_id;$ |
| A. | Select name, course_id from instructor natural join teaches; |
| B. | Select name, course_id from instructor; |
| C. | Select course_id from instructor join teaches; |
| Answer» C. Select course_id from instructor join teaches; | |
| 2. |
The ________ clause is used to list the attributes desired in the result of a query? |
| A. | Where |
| B. | Select |
| C. | From |
| D. | Distinct |
| Answer» E. | |
| 3. |
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate. |
| A. | Where, from |
| B. | From, select |
| C. | Select, from |
| D. | From, where |
| Answer» C. Select, from | |
| 4. |
All |
| A. | From |
| B. | Distinct |
| C. | Name |
| Answer» D. | |