Free Oracle 1z0-063 Exam Dumps Questions & Answers

One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open?
(Choose four.)

• A.  Take both tablespaces OFFLINE NORMAL.
• B.  Take both tablespaces OFFLINE IMMEDIATE.
• C.  Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.
• D.  Restore both tablespaces from the most recent backup.
• E.  Recover both tablespaces.
• F.  Bring both tablespaces ONLINE.

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement? (Choose three.)

• A.  The flashback any table privilege must be granted to the user.
• B.  Minimal supplemental logging must be enabled.
• C.  Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• D.  The select any transaction privilege must be granted to the user.
• E.  The recycle bin parameter must be set to on.
• F.  The database must be running in archivelog mode.

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A.  You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• B.  You can create and configure pluggable databases by using EM express.
• C.  You can use EM express to manage multiple databases running on the same server.
• D.  By default, EM express is available for a database after database creation.
• E.  You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

• A.  maximum number of sessions for a PDB
• B.  CPU
• C.  parallel server limit
• D.  maximum idle time for a session in a PDB
• E.  maximum undo per consumer group

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

• A.  to automatically delete obsolete backups after a specified period of time
• B.  to store backup information of multiple databases in one place
• C.  to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• D.  to restrict the amount of space that is used by backups
• E.  to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause