A.It must be the value of the SERVICE_NAMES parameter on the client side

B.It must resolve to a valid connect descriptor in the server's tnsnames.ora file

C.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

D.It must be the name of the server running the database to whose instance HR wishes to connect

E.It must be the name of the database to whose instance HR wishes to connect

A.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

B.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

C.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

D.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

E.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

F.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

A.re-creating control files

B.full database recovery

C.creating a database

D.enabling online redo log archiving

E.renaming data files

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 NUMBERand DATEvalues

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

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

A.They can accept only one argument

B.They can be used only in the WHERE clause of a SELECT statement

C.They can be nested to any level

D.The argument can be a column name, variable, literal or an expression

E.The data type returned can be different from the data type of the argument

F.They return a single result row per table