A.It is available only when the database is open

B.It can be used to perform database recovery

C.The same port number can be used for Database Express configurations for databases on different hosts

D.It can be used to switch a database into ARCHIVELOGMODE

E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

A.Aggregate functions can be used in any clause of a SELECT statement

B.The MAX and MIN functions can be used on columns with character data types

C.The AVG function implicitly converts NULLS to zero

D.Aggregate functions can be nested to any number of levels

A.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

C.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

D.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

E.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

A.The concatenation operator | | is always evaluated before addition and subtraction in an expression

B.NULLS influence the precedence of operators in an expression

C.The + binary operator has the highest precedence in an expression in a SQL statement

D.Arithmetic operators with equal precedence are evaluated from left to right within an expression

E.Multiple parentheses can be used to override the default precedence of operators in an expression

A.Connect Time Failover requires the use of Transparent Application Failover (TAF)

B.Source Routing requires the use of a name server

C.Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

D.Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

E.Load Balancing requires the use of a name server

F.Connect Time Failover requires the connect string to have two or more listener addresses configured