MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
AS clause is used in SQL for |
| A. | Selection operation |
| B. | Rename operation |
| C. | Join operation |
| D. | Projection operation |
| Answer» C. Join operation | |
| 2. |
In SQL, the command(s) is(are) used to create an index for a table or cluster |
| A. | CREATE INDEX |
| B. | MODIFY INDEX |
| C. | SET INDEX TO FILE |
| D. | All of the above |
| Answer» B. MODIFY INDEX | |
| 3. |
Which of the following query finds the total rating of the sailors who have reserved boat 103 ? |
| A. | SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103, |
| B. | SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 |
| C. | SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 |
| D. | SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 |
| Answer» E. | |
| 4. |
. joins two or more tables based on a specified column value not equaling a specified column value in another table. |
| A. | EQUIJOIN |
| B. | NON-EQUIJOIN |
| C. | OUTER JOIN |
| D. | NATURAL JOIN |
| Answer» C. OUTER JOIN | |