1z1-063 무료 덤프문제 온라인 액세스

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

Which three RMAN persistent settings can be set for a database? (Choose three.)

• A.multiple backup device types for a single backup
• B.default backup device type
• C.backup retention policy
• D.default section size for backups
• E.default destinations for backups

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

• A.from the beginning of the current redo log file until the instance failure
• B.from the last complete checkpoint position
• C.from the most recent incremental checkpoint
• D.from the beginning of the current redo log file to the checkpoint position
• E.from the last committed transaction

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

• A.The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
• B.The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
• C.Block change tracking must be enabled before executing this command.
• D.The database must be running in ARCHIVELOG mode for the successful execution of this command.
• E.A complete database backup must exist before executing this command.

Your database is running in ARCHIVELOG mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state.
Identify the required steps in the correct order.

• A.1, 2, 5, 3, 6, 4
• B.1, 2, 3, 5, 6, 4
• C.2, 1, 5, 6, 7, 4, 3
• D.2, 1, 5, 7, 3, 4