Online Access Free 1z1-063 Exam Questions

Which three statements are true about compression of backup sets? (Choose three.)

• A.It works only for locally managed tablespaces.
• B.Compressed backups cannot have section size defined during a backup operation.
• C.Unused blocks below the high-water mark are not backed up.
• D.Binary compression creates performance overhead during a backup operation.
• E.Compressed backups can only be written to media.

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

• A.The sql_trace parameter is set to false.
• B.The event parameter was not set.
• C.Enterprise Manager was not used.
• D.The statistics_level parameter is set to basic.
• E.The timed_statistics parameter is set to false.

A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?

• A.The backup succeeds and only the used blocks are backed up with a maximum backup piece size of
  1024 MB.
• B.The backup succeeds only if the RMAN default device for backup is set to disk.
• C.The backup succeeds only if all the tablespaces are locally managed.
• D.The backup fails because you cannot specify section size for a compressed backup.

You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOGS option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option.
Identify the required steps in the correct order.

• A.4, 8, 11, 5
• B.1, 3, 8, 11, 9
• C.1, 2, 6, 3, 8, 11, 9
• D.1, 3, 7, 10, 9
• E.1, 2, 6, 3, 7, 10, 9

In which three scenarios is media recovery required? (Choose three.)

• A.when data files are lost
• B.when a tablespace is accidentally dropped from a database
• C.when all control files are lost
• D.when archived redo log files are lost
• E.when one of the online redo log members is corrupted