A.The subquery is executed for every row in the EMPLOYEES table.

B.The subquery is not a correlated subquery.

C.All existing rows in the EMPLOYEE table are deleted.

D.The subquery is executed before the DELETE statement is executed.

E.The DELETE statement executes successfully even if the subquery selects multiple rows.

A.Substituting a character string in a text expression with a specified string

B.Finding the number of characters in an expression

C.Combining more than two columns or expressions into a single column in the output

D.Displaying a date in a nondefault format

A.SELECT DISTINCT promo_cost, promo_category FROM promotions

B.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

C.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1

D.SELECT promo_category, DISTINCT promo_cost FROM promotions

A.A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.

B.A GLOBAL TEMPORARY TABLE can have multiple indexes

C.Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

D.A trigger can be created on a GLOBAL TEMPORARY TABLE

E.A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

F.A GLOBAL TEMPORARY TABLE can have only one index.

A.The IN operator cannot be used in a condition that Involves an outer join.

B.The outer join operator (+) is used next to the column of the table without the matching rows.

C.An outer join is used to retrieve only the rows that do not meet the join condition.

D.A condition representing an outer join cannot be linked to another condition using the or logical operator.

E.The outer join operator (+) can be used on both sides of the join condition in an outer join.