A.They can be performed only by using a subquery.

B.They can be performed on remote tables.

C.They can be performed on external tables using SQL* Loader.

D.They can insert each computed row into more than one table.

E.They can be performed on relational tables.

F.They can be performed on views.

A.SELECT minsal, maxsal
FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365)
GROUP BY maxsal, minsal;

B.SELECT MIN(Salary), MAX(salary)
FROM (SELECT salary FROM
employees
WHERE hire_date < SYSDATE-365);

C.SELECT MIN(Salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365
GROUP BY MIN(salary), MAX(salary);

D.SELECT minsal, maxsal
FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365
GROUP BY MIN(salary), MAX(salary);

A.Performance would degrade in query 2.

B.There would be no change in performance.

C.Performance would improve in query 2.

D.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.

A.Reversing the order of the intersected tables can sometimes affect the output.

B.Column names in each SELECTin the compound query can be different.

C.INTERSECTignores NULLs.

D.The number of columns in each SELECTin the compound query can be different.

E.INTERSECTreturns rows common to both sides of the compound query.

A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
COUNT(*) > 10 GROUP BY COUNT(*) > 10;

B.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;

C.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

D.SELECT prod Id FROH sales NHERE quantity sold > 55000 3RODI BY prod_id HAVING COUNT(*) > 10;

E.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;