View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A.It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column.
• B.It executes successfully.
• C.It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.
• D.It returns an error because the BETWEEN operator cannot be used in the HAVING clause.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the descriptions of the DEPT and LOCATIOMS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

• A.UPDATE dept d
  SET city = (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
• B.UPDATE dept d
  SET city = ALL (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
• C.UPDATE dept d
  SET city = ANY (SELECT city FROM locations l);
• D.UPDATE dept d
  SET city = (SELECT city FROM locations l)
  WHERE d.location_id = l.location_id;

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYYES table:

Which two statements will run successfully?

• A.SELECT 'The first-name is ' | | first_name | | ' ' FROM employees;
• B.SELECT 'The first-name is \ ' ' | | first_name | | ' ' FROM employees;
• C.SELECT 'The first-name is \ ' ' | | first_name | | ' \ ' ' FROM employees;
• D.SELECT 'The first-name is ' ' ' | | first_name | | ' ' ' FROM employees;
• E.SELECT 'The first-name is ' ' ' | | first_name | | ' ' ' ' FROM employees;

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
CHOOSE THREE
SQL > DROP TABLE employees;
Which three statements are true?

• A.If there is an uncommitted transaction in the session, it is committed.
• B.The space used by the EMPLOYEES table is always reclaimed immediately.
• C.The EMPLOYEES table may be moved to the recycle bin.
• D.Sequences used in the EMPLOYEES table become invalid.
• E.All indexes and constraints defined on the table being dropped are also dropped.
• F.The EMPLOYEES table can be recovered using the ROLLBACK command.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table and the foreign key of the ORDER_ITEMS table, whose constraint is defined with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

• A.DELETEFROM ordersWHERE (SELECT order_idFROM order_items);
• B.DELETE order_idFROM ordersWHERE order_total < 1000;
• C.DELETE orders o, order_items iWHERE o.order_id = i.order_id;
• D.DELETE ordersWHERE order_total < 1000;

Comment: *

Name: *

Email: *

Verification: *