Oracle 1Z0-047 問題集

質問 1：
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?

A. displaying the number of orders whose order total is more than the average order total for all online orders
B. displaying the order total for sales representative 161 in the year 1999
C. displaying the total order value for sales representatives 161 and 163
D. displaying the number of orders that have order mode online and order date in 1999
正解：A

質問 2：
Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)
A. You can use the JOIN clause to join only two tables.
B. You can explicitly provide the join condition with a NATURAL JOIN.
C. You can use the USING clause to join tables on more than one column.
D. You can use the ON clause to specify multiple conditions while joining tables.
正解：C,D

質問 3：
Which statements are true regarding the hierarchical query in Oracle Database 10g? (Choose all
that apply.)
A. It is possible to retrieve data only in top-down hierarchy.
B. It is possible to remove an entire branch from the output of the hierarchical query.
C. You cannot specify conditions when you retrieve data by using a hierarchical query.
D. It is possible to retrieve data in top-down or bottom-up hierarchy.
正解：B,D

質問 4：
View the Exhibit and examine the descriptions for ORDERS and ORDER_ITEMS tables.
Evaluate the following SQL statement:
SELECT o.customer_id, oi.product_id, SUM(oi.unit_price*oi. quantity) "Order Amount"

FROM order_items oi JOIN orders o ON oi.order_id = o.order_id GROUP BY CUBE (o.customer_id, oi.product_id);
Which three statements are true regarding the output of this SQL statement? (Choose three.)

A. t would return the subtotals for the Order Amount for every PRODUCT_ID.
B. t would return the subtotals for the Order Amount of every CUSTOMER_ID.
C. t would return only the grand total for the Order Amount of every CUSTOMER_ID and PRODUCT_ID as one group.
D. t would return the subtotals for the Order Amount of every PRODUCT_ID and CUSTOMER_ID as one group.
E. t would return the subtotals for the Order Amount of every CUSTOMER_ID and PRODUCT_ID as one group.
正解：A,B,E

質問 5：
View the Exhibit and examine the description of the ORDERS table.
Your manager asked you to get the SALES_REP_ID and the total numbers of orders placed by each of the sales representatives. Which statement would provide the desired result?
A. SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders
GROUP BY sales_rep_id;
B. SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders;
C. SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders
WHERE sales_rep_id IS NOT NULL;
D. SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders
GROUP BY sales_rep_id, total_orders;
正解：A

質問 6：
Which statement is true regarding synonyms?
A. The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid.
B. Synonyms are used to reference only those tables that are owned by another user.
C. A public synonym and a private synonym can exist with the same name for the same table.
D. Synonyms can be created for tables but not views.
正解：C