Which two statements are true about the use of the procedures listed in the
Which statement is true about Oracle Net Listener?
You are administering a database stored in Automatic Storage Management (ASM). You
use RMAN to back up the database and the MD_BACKUP command to back up the ASM
metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which
three ways can you re-create the lost disk group and restore the data?
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two
pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the
database. You issue the command to open ACCOUNTS_PDB and find that the
USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to
ACCOUNTS_PDB is corrupted. What should you do before executing the commands to
restore and recover the data file in ACCOUNTS_PDB?
Which Oracle Database component is audited by default if the unified Auditing option is
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running
in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root
container. The steps to recover the tablespace are as follows: Which option identifies the
correct sequence to recover the SYSAUX tablespace?
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle
Database 12c when it is enabled?
In order to exploit some new storage tiers that have been provisioned by a storage
administrator, the partitions of a large heap table must be moved to other tablespaces in
your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on
the table. A high volume of transactions access the table during the day and a medium
volume of transactions access it at night and during weekends. Minimal disrupt ion to
availability is required. Which three statements are true about this requirement?