A.They can be used only in the WHERE clause of a SELECT statement

B.The argument can be a column name, variable, literal or an expression

C.The data type returned can be different from the data type of the argument

D.They can be nested to any level

E.They can accept only one argument

F.They return a single result row per table

A.It prevents FLASHBACK DATABASE operation failure.

B.It prevents "Snapshot too old" errors.

C.It is a static parameter.

D.It is a tablespace attribute.

E.It prevents out-of-space errors.

A.SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

B.SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

C.SALES1 is created with 55,000 rows.

D.SALES1 is created with 1 row.

E.SALES1 is created with no rows.

A.Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

B.A single transaction may use multiple undo segments simultaneously

C.An undo segment may be used by multiple transactions simultaneously

D.Undo segments must be stored in a SMALLFILE tablespace

E.Undo segments must be stored in a BIGFILE tablespace

F.Undo segments have a minimum of three extents

G.Undo segments can extend when a transaction fills the last extent of the undo segment

A.SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

B.SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

C.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

D.SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

E.SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;