View the Exhibit and examine the data in EMP and DEPT tables.

In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing the DEPTNO column in the DEPT table.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2, 'SCOTT', 10);
INSERT INTO emp VALUES (3, 'KING', 55);

• A.Only the SECOND INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.
• B.Both the INSERT statements would fail because the constraints are automatically retrieved when the table is flashed back.
• C.Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.
• D.Only the first INSERT statement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.

Comment: *

Name: *

Email: *

Verification: *

Which task can be performed by using a single Data Manipulation Language (DML) statement?

• A.adding a column with a default value while inserting a row into a table
• B.removing all data only from a single column on which a primary key constraint is defined
• C.adding a column constraint while inserting a row into a table
• D.removing all data from a single column on which a unique constraint is defined

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.

You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table.
Which two DELETE statements are valid (Choose two.)

• A.DELETE *FROM order_itemsWHERE order_id IN (SELECT order_id)FROM ordersWHERE order_status IN (0,1));
• B.DELETEFROM order_itemsWHERE order_id IN (SELECT order_idFROM ordersWHERE orders_status in (0,1));
• C.DELETEFROM (SELECT * FROM order_items I,orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));
• D.DELETE FROM order_items iWHERE order_id = (SELECT order_id FROM orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));

Comment: *

Name: *

Email: *

Verification: *

You issue the following command to drop the PRODUCTStable:
SQL > DROP TABLE products;
Which three statements are true about the implication of this command? (Choose three.)

• A.All data in the table is deleted but the table structure remains.
• B.All views and synonyms on the table remain but they are invalidated.
• C.All data along with the table structure is deleted.
• D.A pending transaction in the session is committed.
• E.All indexes on the table remain but they are invalidated.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONS table.

You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHERE clause to perform the required update?

• A.MEMBER_ID IS NULL;
• B.MEMBER_ID = NULL;
• C.MEMBER_ID = '';
• D.MEMBER_ID = "";

Comment: *

Name: *

Email: *

Verification: *