Online Access Free 1z0-063 Practice Test

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

• A.Tables or table partitions can be recovered by using an auxiliary instance only.
• B.Tables with NOT NULL constraints cannot be recovered.
• C.Tables or table partitions with a foreign key cannot be recovered.
• D.Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.
• E.Tables or table partitions can be recovered only when the database is in MOUNT state.

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

• A.It provides a summary of the upgrade results.
• B.It generates a log file containing the fixes that can be made to the source database.
• C.It generates fixup scripts to be run on the source database before upgrade.
• D.It recompiles all invalid PLSQL and Java code.
• E.It provides parallel upgrade options to finish the upgrade process with a reduced down time.

Which three statements are true about the SQL*Loader utility? (Choose three.)

• A.It can be used to load data from multiple external files into multiple tables.
• B.It can be used to generate unique sequential values in specified columns while loading data.
• C.It can be used to extract and reorganize data from external files, and then load it into a table.
• D.It can be used to create tables using data that is stored in external files.
• E.It can be used to load data from external files using direct path only.

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

• A.An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
• B.Only the SALES PDB is duplicated as the non-CDB CDBDUP.
• C.RMAN must be connected to a recovery catalog for the execution of the command.
• D.The root and seed databases are included in the duplication.
• E.A backup of the SALES PDB must exist before the execution of the command.

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