Free Oracle 1Z0-051 Exam Dumps Questions & Answers

Which two statements are true regarding views? (Choose two.)

• A.  A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated
• B.  A sub query that defines a view cannot include the GROUP BY clause
• C.  A view is created with the sub query having the DISTINCT keyword can be updated
• D.  A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table

View the Exhibit and examine the description for the CUSTOMERS table.

You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customer with the CUST_ID 2360. You want the value for the CUST_INCOME_LEVEL to have the same value as that of the customer with the CUST_ID 2560 and the CUST_CREDIT_LIMIT to have the same value as that of the customer with CUST_ID 2566.
Which UPDATE statement will accomplish the task?

• A.  UPDATE customers SET (cust_income_level,cust_credit_limit) = (SELECT cust_income_level, cust_credit_limit
  FROM customers
  WHERE cust_id IN(2560, 2566)
  WHERE cust_id=2360;
• B.  UPDATE customers SET (cust_income_level,cust_credit_limit) = (SELECT cust_income_level, cust_credit_limit FROM customers WHERE cust_id=2560 OR cust_id=2566) WHERE cust_id=2360;
• C.  UPDATE customers SET cust_income_level = (SELECT cust_income_level FROM customers WHERE cust_id = 2560), cust_credit_limit = (SELECT cust_credit_limit FROM customers WHERE cust_id = 2566) WHERE cust_id=2360;
• D.  UPDATE customers SET (cust_income_level,cust_credit_limit) = (SELECT cust_income_level, cust_credit_limit FROM customers WHERE cust_id=2560 AND cust_id=2566) WHERE cust_id=2360;

You are currently located in Singapore and have connected to a remote database in
Chicago.
You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

• A.  Number of days since the promo started based on the current Chicago data and time
• B.  An error because the ROUND function specified is invalid
• C.  Number of days since the promo started based on the current Singapore data and time.
• D.  An error because the WHERE condition specified is invalid

The following data exists in the PRODUCTS table: PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456;
What would be the outcome?

• A.  **152525.99
• B.  152525**
• C.  an error message
• D.  152526****

Which statement is true regarding the UNION operator?

• A.  By default, the output is not sorted
• B.  The number of columns selected in all SELECT statements need to be the same
• C.  NULL values are not ignored during duplicate checking
• D.  Names of all columns must be identical across all SELECT statements