View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
(Choose the best answer.)

You executed this UPDATE statement:
UPDATE
( SELECT order_date, order_total, customer_id FROM orders)
Set order_date = '22-mar-2007'
WHERE customer_id IN
(SELECT customer_id FROM customers
WHERE cust_last_name = 'Roberts' AND credit_limit = 600);
Which statement is true regarding the execution?

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEEStable:

Which query is valid?
SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

• A.join_date;
  SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,
• C.
• D.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *

Examine the command to create the BOOKS table.

The BOOK_IDvalue 101does not exist in the table.
Examine the SQL statement:

Which statement is true?

• A.It executes successfully only if the PUBLISHER_IDcolumn name is added to the columns list and NULL is explicitly specified in the INSERTstatement.
• B.It executes successfully and the row is inserted with a rule PUBLISHER_ID.
• C.It executes successfully only if NULLis explicitly specified in the INSERTstatement.
• D.It executes successfully only if the PUBLISHER_IDcolumn name is added to the columns list in the INSERTstatement.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATE VIEW statement would create the views successfully?

• A.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;
• B.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;
• C.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  ||"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_dateWHITH CHECK OPTION;
• D.CREATE OR REPLACE VIEW ord_vu (order_id, order_date)AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;

Comment: *

Name: *

Email: *

Verification: *

View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A.Only statement 2 executes successfully and gives the required result.
• B.Both statements 1 and 2 execute successfully and give different results.
• C.Only statement 1 executes successfully and gives the required result.
• D.Both statements 1 and 2 execute successfully and give the same required result.

Comment: *

Name: *

Email: *

Verification: *