A.Multiple columns or expressions can be compared between the subquery and main query.

B.The subquery and main query must retrieve date from the same table.

C.A Main query can have many subqueries.

D.A subquery can have more than one main query.

E.Only one column or expression can be compared between the subquery and main query.

F.The subquery and main query can retrieve data from different tables.

A.After issuing a savepoints, you can roll back to the savepoint name within the current transaction.

B.A ROLLBACK TO SAVEPOINTcommand issued before the start of a transaction results in an error.

C.They make uncommitted updates visible to other sessions owned by the same user.

D.After issuing a savepoint, you cannot roll back the complete transaction.

E.You can commit updates done between two savepoints without committing other updates in the current transaction.

F.They make uncommitted updates visible to sessions owned by other users.

A.changing the password for an existing database user

B.connecting to a database instance

C.querying data from tables in different databases

D.starting up a database instance

E.executing operating system (OS) commands in a session

A.They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

A.It fails because a column alias cannot be used in the ORDER BY clause.

B.It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

C.It displays all cities in descending order, within which the last names are further sorted in descending order.

D.It displays all cities in ascending order, within which the last names are further sorted in descending order.