Category: 1Z0-051

Exam 1Z0-051: Oracle Database 11g, SQL Fundamentals I

Which UPDATE statement will accomplish the task?

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?

Which statement is true regarding the execution of the above UPDATE statement?

View the Exhibit and examine the structure of CUSTOMERS and SALES tables.
Evaluate the following SQL statement:
UPDATE (SELECT prod_id, cust_id, quantity_sold, time_id
FROM sales)
SET time_id = ’22-MAR-2007′
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = ‘Roberts’ AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

What could be the reason the following INSERT statement?

View the Exhibit and examine the structure of the CUSTOMERS table.
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have
the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers (cust_id, cust_name, cust_city)
VALUES(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed. What could be the reason?


Page 1 of 1612345...10...Last »