Examine this statement:

What is returned upon execution?

• A.1 row
• B.0 rows
• C.2 rows
• D.an error

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a new transaction always start? (Choose three.)

• A.when issuing a TRUNCATEstatement after a SELECT statement was issued in the same session
• B.when issuing a CREATE INDEXstatement after a CREATE TABLEstatement completed successfully in the same session
• C.when issuing a CREATE TABLEstatement after a SELECTstatement was issued in the same session
• D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session
• E.when issuing a DML statement after a DML statement failed in the same session
• F.when issuing a SELECT FOR UPDATEstatement after a CREATE TABLE AS SELECTstatement was issued in the same session

Comment: *

Name: *

Email: *

Verification: *

Examine these SQL statements which execute successfully:

Which two statements are true after execution? (Choose two.)

• A.The foreign key constraint will be disabled.
• B.The foreign key constraint will be enabled and IMMEDIATE.
• C.The primary key constraint will be enabled and DEFERRED.
• D.The primary key constraint will be enabled and IMMEDIATE.
• E.The foreign key constraint will be enabled and DEFERRED.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

• A.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
• B.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id)WHERE quantity_on_hand < 5;
• C.SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;
• D.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iUSING (product_id) AND quantity_on_hand < 5;

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *