Oracle 1Z0-047 問題集

質問 1：
Which statement is true regarding external tables?
A. The default REJECT LIMIT for external tables is UNLIMITED.
B. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.
C. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table.
D. The data and metadata for an external table are stored outside the database.
正解：C

質問 2：
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 1123.90 would be displayed as $1,123.
B. The LIST_PRICE column having value 11235.90 would be displayed as $1,123.
C. The LIST_PRICE column having value 1123.90 would be displayed as $1,124.
D. The LIST_PRICE column having value 11235.90 would be displayed as #######.
正解：C,D

質問 3：
Evaluate the following SQL statement:
ALTER TABLE hr.emp SET UNUSED (mgr_id);
Which statement is true regarding the effect of the above SQL statement?
A. Any synonym existing on the EMP table would have to be re-created.
B. Any constraints defined on the MGR_ID column would be removed by the above command.
C. Any index created on the MGR_ID column would continue to exist until the DROP UNUSED COLUMNS command is executed.
D. Any views created on the EMP table that include the MGR_ID column would have to be dropped and re-created.
正解：B

質問 4：
Given below is the list of meta character syntaxes and their descriptions in random order: Meta character syntax Description 1) ^a) Matches character not in the list
2) [^...] b) Matches character when it occurs at the beginning of a line 3) | c) Treats the subsequent meta character as a literal 4) \ d) Matches one of the characters such as the OR operator
Identify the option that correctly matches the meta character syntaxes with their descriptions.
A. 1-b, 2-a, 3-d.4-c
B. 1-a, 2-b, 3-d.4-c
C. 1-d, 2-b, 3-a.4-c
D. 1-b, 2-c, 3-d, 2-a
正解：A

質問 5：
View the Exhibit and examine the data in the
PRODUCT INFORMATION table.
Which two tasks would require subqueries? (Choose two.)
A. displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
B. displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
C. displaying the number of products whose list prices are more than the average list price
D. displaying the minimum list price for each product status
E. displaying all supplier IDs whose average list price is more than 500
正解：B,C

質問 6：
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER__ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

A. DELETE FROM orders WHERE (SELECT order_id FROM order_items);
B. DELETE order_id FROM orders WHERE order_total < 1000;
C. DELETE orders o, order_items i
WHERE o.order id = i.order id;
D. DELETE orders WHERE order_total < 1000;
正解：D