1Z1-047 무료 덤프문제 온라인 액세스

View the Exhibit and examine the structure of the ORDERS table:
The ORDER_ID column has the PRIMARY KEY constraint and CUSTOMER_ID has the NOT
NULL constraint.
Evaluate the following statement:
INSERT INTO (SELECT order_id.order_date.customer_id FROM ORDERS WHERE order_total
= 1000 WITH CHECK OPTION) VALUES (13, SYSDATE, 101);
What would be the outcome of the above INSERT statement?

• A.It would execute successfully and the ORDER_TOTAL column would have the value 1000 inserted automatically in the new row.
• B.It would not execute successfully because the ORDER_TOTAL column is not specified in the SELECT list and no value is provided for it.
• C.It would execute successfully and the new row would be inserted into a new temporary table created by the subquery.
• D.It would not execute successfully because all the columns from the ORDERS table should have been included in the SELECT list and values should have been provided for all the columns.

Which three statements are true regarding single-row functions? (Choose three.)

• A.They can be used in SELECT, WHERE, and ORDER BY clauses.
• B.They can be nested up to only two levels.
• C.They can accept only one argument.
• D.They can modify the data type of the argument that is referenced.
• E.They can accept a column name, expression, variable name, or a user-supplied constant as arguments.
• F.They can return multiple values of more than one data type.

View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
Which SQL statement would retrieve from the table the number of products having LIST_PRICE
as NULL?

• A.SELECT COUNT(DISTINCT list_price)
  FROM product_information
  WHERE list_price IS NULL;
• B.SELECT COUNT(list_price)
  FROM product_information
  WHERE list_price = NULL;
• C.SELECT COUNT(NVL(list_price, 0))
  FROM product_information
  WHERE list_price IS NULL;
• D.SELECT COUNT(list_price)
  FROM product_information
  WHERE list_price IS NULL;

Which two statements best describe the benefits of using the WITH clause? (Choose two.)

• A.It enables users to store the results of a query permanently.
• B.It enables users to store the query block permanently in the memory and use it to create complex queries.
• C.It enables users to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.
• D.It can improve the performance of a large query by storing the result of a query block having the WITH clause in the user's temporary tablespace.

View the Exhibit and examine the structure of the ORDERS table.
You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101 Which query would give you the desired output?

• A.SELECT order_id, order_date FROM orders
  WHERE order_date > ANY (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• B.SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• C.SELECT order_id, order_date FROM orders
  WHERE order_date IN (SELECT order_date FROM orders
  WHERE customer id = 101);
• D.SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT MAX(order_date) FROM orders) AND
  Customer_id = 101;