The following SQL is which type of join? – McqOptions

MCQOPTIONS

1.	The following SQL is which type of join?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» B. Natural join

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