A.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c.department_id);

B.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d.department_id);

C.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d.department_id);

D.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c.department_id);

A.INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

B.INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

C.INTERVAL DAY TO SECOND columns support fractions of seconds.

D.The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

E.The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

F.INTERVAL YEAR TO MONTH columns support yearly intervals.

A.It is used to test whether the values retrieved by the inner query exist in the result of the outer query.

B.It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.

C.The outer query stops evaluating the result set of the inner query when the first value is found.

D.The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.

A.It produces an error because conditions on the CUST_CREDIT_LIMITcolumn are not valid.

B.It produces an error because the condition on the CUST_CITYcolumn is not valid.

C.It produces an error because the condition on the CUST_FIRST_NAMEcolumn is not valid.

D.It executes successfully.

A.Performance would improve query 2 only if there are null values in the CUST__CREDIT__LIMIT column.

B.Performance would improve in query 2.

C.There would be no change in performance.

D.Performance would degrade in query 2.