Oracle 1Z0-047 問題集

質問 1：
Which statement correctly differentiates a system privilege from an object privilege?
A. System privileges can be granted only by the DBA whereas object privileges can be granted by DBAs or the owner of the object.
B. A system privilege is the right to perform specific activities in a database whereas an object privilege is a right to perform activities on a specific object in the database.
C. System privileges give the rights to only create user schemas whereas object privileges give rights to manipulate objects in a schema.
D. Users require system privileges to gain access to the database whereas they require object privileges to create objects in the database.
正解：B

質問 2：
View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
You want to display the expiration date of the warranty for a product. Which SQL statement would you execute?

A. SELECT product_jd, TO_YMINTERVAL(warranty_period)
FROM product_information;
B. SELECT product_id, SYSDATE + warranty_period
FROM product_information;
C. SELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period
FROM product_information;
D. SELECT product_jd, TO_YMINTERVAL(SYSDATE + warranty_period)
FROM product_information;
正解：B

質問 3：
View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price FROM product_information WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;
Which statement is true regarding the execution of the query?

A. It would execute and the output would display the desired result.
B. It would not execute because the same column has been used in both sides of the AND logical operator to form the condition.
C. It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.
D. It would execute but the output would return no rows.
正解：D

質問 4：
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

質問 5：
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
Evaluate the following UPDATE statement:
UPDATE (SELECT order_date, order_total, customer_id FROM orders) SET order_date = 22-mar-2007' WHERE customer_id = (SELECT customer_id FROM customers WHERE cust_last_name = 'Roberts'AND Credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

A. It would execute and restrict modifications to only the columns specified in the SELECT statement.
B. It would not execute because the SELECT statement cannot be used in place of the table name.
C. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
D. It would not execute because two tables cannot be used in a single UPDATE statement.
正解：A

質問 6：
Which view would you use to display the column names and DEFAULT values for a table?
A. USER TAB COLUMNS
B. DBA_COLUMNS
C. DBA_TABLES
D. USER_COLUMNS
正解：A