A.It registers database services with all local and remote listeners known to the database instance

B.It frees resources held by abnormally terminated processes

C.It records checkpoint information in the control file

D.It frees unused temporary segments

E.It kills sessions that exceed idle time

A.connecting a user process to a server process

B.creating a user session in the System Global Area (SGA)

C.returning the results of processing from the server process to the user process

D.verifying a user's authentication credentials

E.verifying the service name in an incoming user request

F.maintaining the connection to a client's user process until the user request is completed

A.Each SELECT statement in the compound query can have its own ORDER BY clause

B.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

C.Only column names from the first SELECT statement in the compound query are recognized

D.Each SELECT statement in the compound query must have its own ORDER BY clause

E.Column positions must be used in the ORDER BY clause

A.It must be smaller than the smallest BIGFILE tablespace

B.Free space is managed using freelists

C.Any data files added to the tablespace must have a size of 5 gigabytes

D.It uses the database default blocksize

E.It is a locally managed tablespace

A.Data Recovery Advisor can be used to restore a single file from an RMAN backupset.

B.Oracle Data Guard can prevent data loss caused by a site failure.

C.Data Recovery Advisor can be used to validate backup strategies.

D.RMAN can be used to roll back committed transactions.

E.RMAN can be used to FLASHBACK a database.