1Z0-047 試験問題を無料オンラインアクセス

Which statement is true regarding the CUBE operator in the GROUP BY clause of a SQL statement?

• A.It produces 2 n possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.
• B.It produces n+1 possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.
• C.It produces only aggregates for the groups specified in the GROUP BY clause.
• D.It finds all the NULL values in the superaggregates for the groups specified in the GROUP BY clause.

View the Exhibit and examine the structure of the ORDERS table. Which UPDATE statement is valid?

• A.UPDATE orders
  SET order_date = TO_DATE('12-mar-2007,l,dd-mon-yyyy')l SET order_total =
  TO_NUMBER(NULL) WHERE order id = 2455;
• B.UPDATE orders
  SET order_date = 12-mar-2007\ order_total IS NULL WHERE order_id = 2455;
• C.UPDATE orders
  SET order_date = 12-mar-2007', order_total = NULL WHERE order_id = 2455;
• D.UPDATE orders
  SET order_date = '12-mar-2007'
  AND order_total = TO_NUMBER(NULL)
  WHERE order_id = 2455;

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute the following query successfully? SELECT'FROM ord;

• A.CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.
• B.CREATE SYNONYM ord FOR orders; This command is issued by OE.
• C.CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
• D.CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.
You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or
1 in the ORDERS table.
Which DELETE statements are valid? (Choose all that apply.)

• A.DELETE FROM order_items WHERE order_id IN (SELECT order_id FROM orders WHERE 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 i WHERE order_id = (SELECT order_id FROM orders o
  WHERE i. order_id = o. order_id AND
  order_status IN (0,1));

Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR:
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

• A.Do not enclose the character literal string in the SELECT clause within the single quotation marks.
• B.Enclose the character literal string in the SELECT clause within the double quotation marks.
• C.Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause.
• D.Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.