A.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

B.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

C.SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;

D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

E.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

A.undo segments are owned by SYSTEM.

B.An instance will crash if the active undo tablespace is lost.

C.undo segments are owned by SYSBACKUP.

D.An undo tablespace may be owned by only one instance.

E.There can be only one undo tablespace created in a database.

A.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

C.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

D.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

A.Roles must be password protected.

B.The SET ROLE statement can enable one or more roles for a session.

C.Roles may be granted to roles.

D.Object privileges may not be granted to roles.

E.All roles granted to a user are set on by default when the user logs in,

F.The SET ROLE statement can disable one or more roles for a session.

A.Change the standard block size of an existing database

B.Configure incremental backups for a new database

C.Configure a nonstandard block size for a new database

D.Enable flashback database for an existing database

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