QUESTION: 13

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?

DELETE orders o, order_items i
WHERE o.order_id = i.order_id;
DELETE
FROM orders
WHERE (SELECT order_id FROM order_items);
DELETE orders
WHERE order_total < 1000;
DELETE order_id FROM orders
WHERE order_total < 1000;

Answer(s): C

Show Answer Next Question

QUESTION: 14

View the Exhibit and examine the structure of CUSTOMERS table.

Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.

Which SQL statement would produce the required result?

SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"
FROM customers;
SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"
FROM customers;
SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"
FROM customers;
SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"
FROM customers;

Answer(s): A

Show Answer Next Question

QUESTION: 15

View the exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.

You want to update EMPLOYEES table as follows:
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department_id corresponding to London (location_id 2100).
-Set the employees' salary in location_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission in location_id 2100 to 1.5 times the average commission of their department.

You issue the following command:

What is outcome?

It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in an UPDATE statement.
It generates an error because a subquery cannot have a join condition in a UPDATE statement.
It executes successfully and gives the desired update
It executes successfully but does not give the desired update

Answer(s): D

Show Answer Next Question

QUESTION: 16

Evaluate the following two queries:

Which statement is true regarding the above two queries?

Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
There would be no change in performance.
Performance would degrade in query 2.
Performance would improve in query 2.

Answer(s): B

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16

1Z0-071 Exam Discussions & Posts