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

You executed this UPDATE statement:

Which statement is true regarding the execution? (Choose the best answer.)

• A.It would execute and restrict modifications to the columns specified in the SELECT 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 not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about external tables?

• A.Their data can be retrieved by using only SQL or PL/SQL.
• B.You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command.
• C.DML statements cannot be used on them.
• D.Indexes can be created on them.
• E.Their metadata and actual data are both stoned outside the database.

Comment: *

Name: *

Email: *

Verification: *

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in
EMPLOYEE_RECORDS, but don't commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

• A.Andrew will be able to modify any rows in the table that have not been modified by your transaction
• B.Andrew will be unable to see the changes you have made
• C.Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble
• D.Andrew will be able to see the changes you habe made
• E.Andrew will be able to SELECT from the table, but be unable to modify any existing rows.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding subqueries? (Choose three.)

• A.Multiple columns or expressions can be compared between the main query and subquery.
• B.Subqueries can contain ORDER BY but not the GROUP BY clause.
• C.Main query and subquery can get data from different tables.
• D.Subqueries can contain GROUP BY and ORDER BY clauses.
• E.Main query and subquery must get data from the same tables.
• F.Only one column or expression can be compared between the main query and subquery.

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.DELETE ordersWHERE order_total < 1000;
• B.DELETE orders o, order_items iWHERE o.order_id = i.order_id;
• C.DELETE order_idFROM ordersWHERE order_total < 1000;
• D.DELETEFROM ordersWHERE (SELECT order_idFROM order_items);

Comment: *

Name: *

Email: *

Verification: *