A.By default, EM express is available for a database after database creation using DBCA.

B.You can shut down a database instance using EM Express.

C.You can use a single instance of EM Express to manage multiple database running on the same server.

D.You cannot start up a database instance using EM Express.

E.EM Express uses a separate repository database to store target database metadata.

A.Undo segments can extend when a transaction fills the last extent of the undo segment

B.An undo segment may be used by multiple transactions simultaneously

C.Undo segments must be stored in a SMALLFILE tablespace

D.Undo segments must be stored in a BIGFILE tablespace

E.A single transaction may use multiple undo segments simultaneously

F.Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

G.Undo segments have a minimum of three extents

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

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

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

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

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

A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

A.MOD : returns the quotient of a division operation

B.FLOOR : returns the smallest integer greater than or equal to a specified number

C.TRUNC : can be used with NUMBER and DATE values

D.CONCAT : can be used to combine any number of values

E.CEIL : can be used for positive and negative numbers