MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;18.A SELECT statement can be used to perform these three functions: - Choose rows from a table. - Choose columns from a table. - Bring together data that is stored in different tables by creating a link between them.Which set of keywords describes these capabilities? |
| A. | difference, projection, join |
| B. | selection, projection, join |
| C. | Selection, intersection, join |
| D. | Intersection, projection, join |
| E. | |
| Answer» C. Selection, intersection, join | |
| 2. |
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T17.Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed? |
| A. | Selection, projection, join |
| B. | Difference, projection, join |
| C. | Selection, intersection, join |
| D. | Intersection, projection, join |
| Answer» B. Difference, projection, join | |
| 3. |
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID16.The following SQL is which type of join? |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» E. | |
| 4. |
The following SQL is which type of join? |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» B. Natural join | |
| 5. |
Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2? |
| A. | Retrieves all the unmatched rows of Table1 |
| B. | Retrieves all the unmatched rows of Table2 |
| C. | Retrieves both matched and unmatched rows of Table1 and Table2 |
| D. | Retrieves only matched rows of table1 and Table2 |
| Answer» D. Retrieves only matched rows of table1 and Table2 | |
| 6. |
A_____ is a query that retrieves rows from more than one table or view |
| A. | Start |
| B. | End |
| C. | Join |
| D. | All of the above |
| Answer» D. All of the above | |