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

A subquery is called a single-row subquery when

• A.the inner query uses an aggregate function and returns one or more values
• B.the inner query returns a single value to the main query
• C.the inner query returns one or more values and the main query returns a single value as output
• D.there is only one inner query in the main query and the inner query returns one or more values

Which three statements are true? (Choose three.)

• A.The minimum column width that can be specified for a varchar2 data type column is one.
• B.Only one LONG column can be used per table.
• C.The BLOB data type column is used to store binary data in an operating system file.
• D.ATIMESTAMP data type column stores only time values with fractional seconds.
• E.The value for a CHAR data type column is blank-padded to the maximum defined column width.

View the Exhibit and examine the description of the EMPLOYEES table.
You executed the following SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the output of the above query? (Choose two.)

• A.The values in the SALARY column would be sorted in descending order for all the employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• B.The values in the FIRST_NAME column would be sorted in the descending order for all the employees having the same value in the DEPARTMENT_ID column.
• C.The values in the SALARY column would be sorted in descending order for all the employees having the same value in the DEPARTMENT_ID column.
• D.The values in all the columns would be sorted in the descending order.
• E.The values in the FIRST_NAME column would be sorted in ascending order for all the employees having the same value in the DEPARTMENT_ID column.

View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
SELECT product_name, list_price, min_price, list_price - min_price Difference FROM product_information
Which options when used with the above SQL statement can produce the sorted output in ascending order of the price difference between LIST_PRICE and MIN_PRICE? (Choose all that apply.)

• A.ORDER BY LIST_PRICE
• B.ORDER BY MIN_PRICE
• C.ORDER BY LIST_PRICE - MIN_PRICE
• D.ORDER BY 4
• E.ORDER BY DIFFERENCE

View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.
You executed the following SQL statement:
SELECT order_id, product_id, unit_price*quantity "Total Price" FROM order_items WHERE
unit_price*quantity > 50000 NATURAL JOIN orders;
Which statement is true regarding the execution of the statement?

• A.The statement would not execute because the ON keyword is missing in the NATURAL JOIN clause.
• B.The statement would execute and provide the desired result.
• C.The statement would not execute because the WHERE clause is before the NATURAL JOIN clause.
• D.The statement would not execute because the USING keyword is missing in the NATURAL JOIN clause.