Which of the following statement is TRUE about FULL OUTER JOIN created – McqOptions

MCQOPTIONS

1.	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

Discussion

No Comment Found

Related MCQs

<code>SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;</code>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?
<code>SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T</code>17.Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?
<code>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_ID</code>16.The following SQL is which type of join?
The following SQL is which type of join?
Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2?
A_____ is a query that retrieves rows from more than one table or view