Question: Hurry. please write why it is false. SECTION (1) (WORTH 40 points): Select TRUE or FALSE for the following statements. If the statement is FALSE,
Hurry. please write why it is false.


SECTION (1) (WORTH 40 points): Select TRUE or FALSE for the following statements. If the statement is FALSE, you must explain why the statement is false. 1- When joining two tables, we use WHERE clause to restrict the result to rows that have common values in matching columns. TRUE( FALSE ( When joining two tables, we have to qualify the PK of both tables. TRUE FALSE ) 2- 3- When using subquery, both results of the outer (main query) and the inner (subquery) will be displayed TRUE FALSE ) 4- When using subquery with IN operator, the subquery is called correlated subquery cause it involves a table listed in the outer query (main query). TRUE() FALSE( ) be When joining a table to itself, we MUST use the original name of the table to qualify common columns instead of the alias name of the table. 5- TRUE FALSE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
