A.To shrink a table it must have a PRIMARY KEY constraint

B.It is not possible to shrink either indexes or Index Organized Tables (IOTs)

C.To shrink a table it must have row movement enabled

D.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

E.To shrink a table it must have a UNIQUE KEY constraint

F.It always eliminates all migrated rows if any exist in the table

A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

C.It can display multiple rows but only a single column

D.It can be used to display only constants or pseudo columns

E.It can be accessed by any user who has the SELECT privilege in any schema

F.It can display multiple rows and columns

A.enabling online redo log archiving

B.renaming data files

C.creating a database

D.re-creating control files

E.full database recovery

A.V$SYSTEM_EVENT

B.V$SESSION_EVENT

C.V$SESSION_WAIT_CLASS

D.V$SESSION

E.V$SESSION_WAIT

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

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

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

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

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