User OE, the owner of the ORDERS table, issues the following command:
GRANT SELECT .INSERT ON orders TO hr WITH GRANT OPTION;
The user HR issues the following command:
GRANT SELECT ON oe. orders
TO scott;
Then, OE issues the following command: REVOKE ALL ON orders FROM hr;
Which statement is correct?

• A. The user SCOTT loses the privilege to select rows from OE.ORDERS.
• B. The REVOKE statement generates an error because OE has to first revoke the SELECT privilege from SCOTT.
• C. The REVOKE statement generates an error because the ALL keyword cannot be used for privileges that have been granted using WITH GRANT OPTION.
• D. The user SCOTT retains the privilege to select rows from OE.ORDERS.

The following are the steps for a correlated subquery, listed in random order:
1) The WHERE clause of the outer query is evaluated.
2) The candidate row is fetched from the table specified in the outer query.
3) The procedure is repeated for the subsequent rows of the table, till all the rows are processed.
4) Rows are returned by the inner query, after being evaluated with the value from the candidate
row in the outer query. Identify the option that contains the steps in the correct sequence in which
the Oracle server evaluates a correlated subquery.

• A. 2,4,1,3
• B. 4,1,2,3
• C. 4,2,1,3
• D. 2,1,4,3

SCOTT is a user in the database.
Evaluate the commands issued by the DBA:
1 - CREATE ROLE mgr;
2 - GRANT CREATE TABLE, SELECT
ON oe. orders
TO mgr;
3 - GRANT mgr, create table TO SCOTT;
Which statement is true regarding the execution of the above commands?

• A. Statement 1 would not execute because the WITH GRANT option is missing.
• B. Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
• C. Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
• D. Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.

View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables. Which is the best method to load data from the MARKS_DETAILStable to the MARKStable?

• A. Pivoting INSERT
• B. Unconditional INSERT
• C. Conditional ALL INSERT
• D. Conditional FIRST INSERT