A.SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

B.SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

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

D.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

E.SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

A.in the undo tablespace

B.in the SYSAUX tablespace

C.in the SGA

D.in the PGA

E.in the temporary tablespace

A.The database must have FLASHBACK enabled in order to perform incomplete recovery.

B.Uncommitted transactions will be rolled back after incomplete recovery completes.

C.Incomplete recovery is possible only when the database is open.

D.Only incremental backups can be used to roll forward the database while performing complete recovery.

E.Uncommitted transactions will be rolled back after complete recovery completes.

A.The file is renamed and stored in the same location

B.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

C.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

D.DML may be performed on tables with one or more extents in this data file during the execution of this command.

E.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

A.Free space is managed using freelists

B.It must be smaller than the smallest BIGFILE tablespace

C.Any data files added to the tablespace must have a size of 5 gigabytes

D.It uses the database default blocksize

E.It is a locally managed tablespace