최신Oracle Database SQL Expert - 1Z0-047무료샘플문제

A. DELETE FROM order_items i WHERE order_id = (SELECT order_id FROM orders o
WHERE i. order_id = o. order_id AND
order_status IN (0,1));

B. DELETE FROM (SELECT* FROM order_items i.orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));

C. DELETE FROM order_items WHERE order_id IN (SELECT order_id FROM orders WHERE order_status in (0,1));

D. DELETE * FROM order_items WHERE order_id IN (SELECT order_id FROM orders WHERE order_status IN (0,1));

A. It produces higher-level subtotals, moving from right to left through the list of grouping columns specified in the GROUP BY clause.

B. It produces only the subtotals for the groups specified in the GROUP BY clause.

C. It produces higher-level subtotals, moving in all the directions through the list of grouping columns specified in the GROUP BY clause.

D. It produces only the grand totals for the groups specified in the GROUP BY clause.

A. SELECT product_id, TO_YMINTERVAL(warranty_period) FROM product_information;

B. SELECT product_id, SYSDATE + warranty_period FROM product_information;

C. SELECT product_id, TO_YMINTERVAL(SYSDATE + warranty_period) FROM product_information;

D. SELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period FROM product_information;

A. SELECTviewjiame, text FROM user_view;

B. SELECTviewjiame, text FROM user_objects;

C. SELECTviewjiame, text FROM user_object;

D. SELECTview_name, text FROM user views;

A. They can be used to retrieve multiple rows from a single table only.

B. They always contain a subquery within a subquery.

C. They can contain group functions.

D. They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.

E. They use the < ALL operator to imply less than the maximum.

A. SELECT first_name, salary FROM employees WHERE (manager_id, salary) >= ANY (SELECT manager_id, salary FROM employees WHERE first_name = 'Neena' AND first_name <> 'Neena';

B. SELECTfirst_name, salary FROM employees WHERE (manager_id, salary) >= ALL (SELECT manager_id, salary FROM employees WHERE first_name = 'Neena' AND first_name <> 'Neena';

C. SELECT first_name, salary FROM employees WHERE (manager_id = (SELECT manager_id FROM employees WHERE first_name = 'Neena') AND salary >= (SELECT salary FROM employees WHERE first_name = 'Neena')) AND first name <> 'Neena';

D. SELECT first_name, salary FROM employees WHERE (manager_id, salary) >= (SELECT manager_id, salary FROM employees WHERE first_name = 'Neena') AND first_name <> 'Neena';

A. Only the second DELETE statement would be rolled back.

B. No SQL statement would be rolled back.

C. Both the DELETE statements would be rolled back.

D. Both the DELETE statements and the UPDATE statement would be rolled back.

A. INSERT using WITH CHECK OPTION

B. the MERGE command

C. external table

D. the multitable INSERT command

A. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders "
WHERE COUNT(customer_id) > 10
GROUP BY sales_rep_id;

B. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders "
HAVING COUNT(customer_id) > 10;

C. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders "
GROUP BY sales_rep_id
HAVING total > 10;

D. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders "
GROUP BY sales_rep_id
HAVING COUNT(customer_id) > 10;