A.Revoke the CREATE SESSION privilege from other users

B.Revoke the CREATE SESSION privilege from user HR

C.Log in to the database instance

D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.Execute DDL statements in the HR schema

F.Execute DML statements in the HR schema

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

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

C.Display suppliers whose PROD_LIST_PRICE is less than 1000

D.Display the minimum PROD_LIST_PRICE for each product status

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

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

B.Change the standard block size of an existing database

C.Configure incremental backups for a new database

D.Configure a nonstandard block size for a new database

E.Enable flashback database for an existing database

A.It will be a dictionary-managed tablespace by default

B.Additional data files may not be added

C.It will always have a 32K blocksize

D.It must be bigger than the largest SMALLFILE tablespace

E.AUTOEXTEND is possible for the datafile

A.Duplicates are eliminated automatically by the UNION ALL operator

B.NULLS are not ignored during duplicate checking

C.The output is sorted by the UNION ALL operator

D.The number of columns selected in each SELECT statement must be identical

E.The names of columns selected in each SELECT statement must be identical