Which logical storage relationship is correct?

A. Tablespace< Segment < Extent < Oracle Datablock

B. B) Segment < Extent < Oracle Datablock

C. Tablespace< Extent < Segment < Oracle Datablock

D. Data File

Your database instance is down because there was a user-initiated shutdown. Which option represents

the actions performed, in the correct order, if you start up the instance?

a - The control file is read.

b - Memory is allocated.

c - Background processes pre started.

d -The initialization parameter file is read,

e- Redo log files and data files are opened.

A. b, c, a

B. d, a, e

C. a, e, d, b

D. d, b, c, a, e

E. c, b, d, a, e

Which command do you use to check for block corruption by validating the database?

A. RMAN> VALIDATE CHECK LOGICAL

B. RMAN> VALIDATE BACKUP

C. RMAN> VALIDATE CORRUPT BLOCKS

D. RMAN> VALIDATE DATABASE

Which option represents a function of Global Data Services (GDS)?

A. performs data replication

B. performs database failovers

C. replaces the functionality of Oracle Clusterware and Oracle RAC

D. coordinates site failovers

E. works seamlessly with Oracle Site Guard

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

A. cluster

B. database link

C. mapping table

D. materialized view

Your database instance is running. db01 is a net service name. You issue a connection request by using the command:

SQL> CONNECT scott/tiger@db01

Which component receives the request and establishes the appropriate connection?

A. listener

B. user process

C. service name

D. server process

Which two statements about Automatic Data Optimization (ADO) are true?

A. ADO policies can automatically compress data when it qualifies.

B. ADO policies can automatically move segments when necessary.

C. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D. You cannot compress at block level, but you can compress at segment level.

E. You can compress at row level only for QUERY LOW.

When executing shutdown abort in a pluggable database (PDB), you ____________.

A. shut down abort the CDB

B. shut down abort the PDB

C. shut down immediate the PDB

D. shut down immediate the CDB

Which three are initialization parameters for backup and recovery?

A. CLONEDB

B. FILESYSTEMIO_OPTIONS

C. DB_CREATE_FILE_DEST

D. RECYCLEBIN

E. TAPE_ASYNCH_IO

In which situation would you use static database registration for a listener?

A. when multiple databases are to be registered with the listener

B. when DBAs need to connect remotely to start up the database instance

C. when users need to connect the database instance by using the host naming method

D. when the database instance to be registered with the listener is configured in shared server mode