A. During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.

B. During executing, the oracle server may read data from storage if the required data is not already in memory.

C. During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

D. During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.

A.

B.

C.

D.

A. The table used for the self-join must have two different alias names in the query.

B. Only equijoin conditions may be used in the query.

C. There must be a condition on which the self-join is performed.

D. No other condition except the self-join may be specified.

E. Outer joins must not be used in the query.

A. A role is named group of related privileges that can only be assigned to a user.

B. A single user can be assigned multiple roles.

C. Privileges are assigned to a role using the ALTER ROLE statement.

D. Privileges are assigned to a role using the GRANT statement.

E. A single role can be assigned to multiple users.

F. Roles are assigned to roles using the ALTER ROLE statement.

G. Roles are assigned to users using the ALTER USER statement.

A. It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

B. It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators.

C. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

D. It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

A. You can explicitly provide the join condition with a NATURAL JOIN.

B. You can use the USING clause to join tables on more than one column.

C. You can use the JOIN clause to join only two tables.

D. You can use the ON clause to specify multiple conditions while joining tables.

A.

B.

C.

D.

E.

A. an error

B. 3 rows

C. 1 row

D. 8 rows

E. 0 rows

F. 6 rows

A. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

B. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

C. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

D. NOT NULL can be specified at the column and at the table level.

E. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.

F. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent table must have the same names.

A. Any uncommitted transaction in the session is committed.

B. All the table's indexes if any exist, are invalidated but retained.

C. Table data and the table structure are deleted.

D. All existing views and synonyms that refer to the table are invalidated but retained.

E. Table data is deleted but the table structure is retained.