A.The generation of REDO generates UNDO

B.DML modifies Oracle database objects and generates UNDO and REDO

C.The generation of UNDO generates REDO

D.DML modifies Oracle database objects and only generates UNDO

E.DML modifies Oracle database objects and only generates REDO

A.Dynamic service registration cannot be used for this database instance

B.The LREG process registers services dynamically with the LISTENER_1 listener

C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances

E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

A.The LREG process registers services dynamically with the LISTENER_1 listener

B.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

C.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

D.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

E.Dynamic service registration cannot be used for this database instance

A.Multiple row pieces from the same row may be stored in different database blocks

B.Index block free space is always contiguous in the middle of the block

C.Data block headers contain their own Data Block Address (DBA)

D.Data block free space is always contiguous in the middle of the block

E.A table row piece can be chained across several database blocks

F.Multiple row pieces from the same row may be stored in the same block

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

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

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

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

E.SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;