A.when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

B.when the session logs out successfully

C.when a COMMIT statement is issued by the same user from another session in the same database instance

D.when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

E.when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

F.when a CREATE INDEX statement is executed successfully in the same session

A.tables

B.undo

C.clusters

D.sequences

E.stored procedures

F.index

A.All tablespaces may have one or more data files

B.The extents of a segment must always reside in the same datafile

C.A segment can span multiple data files in some tablespaces

D.A smallfile tablespace might be bigger than a bigfile tablespace

E.Segments can span multiple tablespaces

F.A segment's blocks can be of different sizes

G.A segment might have only one extent

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.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

B.Display suppliers whose PROD_LIST_PRICE is less than 1000

C.Display the total number of products supplied by supplier 102 which have a product status of obsolete

D.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

E.Display the minimum PROD_LIST_PRICE for each product status