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

View the Exhibit and examine the details of the ORDER_ITEMS table.
Evaluate the following SQL statements:
Statement 1: SELECT MAX(unit_price*quantity) "Maximum Order" FROM order items;
Statement 2:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items GROUP BY order_id;
Which statements are true regarding the output of these SQL statements? (Choose all that apply.

• A.Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
• B.Both the statements would give the same output.
• C.Statement 2 would return multiple rows of output.
• D.Statement 1 would not return any row because the GROUP BY clause is missing.
• E.Statement 1 would return only one row of output.

View the Exhibit and examine the details of the
PRODUCT_INFORMATION table.
Evaluate the following SQL statement:
SELECT TO_CHAR(list_price ,'$9,999")
FROM product_information;

Which two statements would be true regarding the output for this SQL statement? (Choose two.)

• A.The LIST_PRICE column having value 11235.90 would be displayed as $1,123.
• B.The LIST_PRICE column having value 1123.90 would be displayed as $1,124.
• C.The LIST_PRICE column having value 11235.90 would be displayed as #######.
• D.The LIST_PRICE column having value 1123.90 would be displayed as $1,123.

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

• A.to create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals
• B.to create group-wise grand totals for the groups specified within a GROUP BY clause
• C.to find the groups forming the subtotal in a row
• D.to create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals

View the Exhibit and examine the description of the EMPLOYEES table.
You want to know the EMPLOYEE_ID and FIRST_NAME of all the records in the EMPLOYEES table wherein the JOB_ID column has ST_CLERK or ST_MAN values, the DEPARTMENT_ID column has value 30, and the SALARY column has a value greater than 3,000.
Which SOL statement would get you the desired result?

• A.SELECT employee_id, first_name
  FROM employees
  WHERE job_id like 'MAN%' OR job_id like 'CLERK%'
  AND department_id = 30 AND salary > 3000;
• B.SELECT employee_ id, first_name
  FROM employees
  WHERE (job_id like '%MAN' AND job_id like '%CLERK')
  AND department_id = 30 OR salary > 3000;
• C.SELECT employee_ d, first_name
  FROM employees
  WHERE job_id like '%MAN' OR job_id like '%CLERK'
  AND (department_id = 30 OR salary > 3000);
• D.SELECT employee_ id, first_name
  FROM employees
  WHERE (job_id like '%MAN' OR job_id like '%CLERK')
  AND department_id = 30 AND salary > 3000;

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

• A.It enables users to store the query block permanently in the memory and use it to create complex queries.
• B.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.
• 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 enables users to store the results of a query permanently.