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

B.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

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

D.Display the minimum PROD_LIST_PRICE for each product status

E.Display suppliers whose PROD_LIST_PRICE is less than 1000

A.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

B.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

C.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

D.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

E.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

F.when issuing a DML statement after a DML statement failed in the same session

A.user process failure

B.media failure

C.a user error such as dropping the wrong table

D.network interface card (NIC) failure

E.statement failure

A.Configure a nonstandard block size for a new database

B.Register a new database with an available Enterprise Manager Management server

C.Change the standard block size of an existing database

D.Configure incremental backups for a new database

E.Enable flashback database for an existing database