Online Access Free 1z0-034 Exam Questions

View the Exhibit and examine the RMAN commands.

Which statement describes the effect of a backup retention policy on the backup of a backup set?

• A.Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
• B.The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.
• C.All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.
• D.The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.

Which three file types are managed by Data Pump jobs?

• A.out files
• B.SQL files
• C.alert files
• D.error files
• E.dump files
• F.log files

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

• A.Restoring the server parameter file (SPFILE) to the new host
• B.Opening the database in RESTRICTED mode
• C.Opening the database with the RESETLOGS option
• D.Setting a new DBID for the newly restored database

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

• A.The plans can be nested up to four levels.
• B.Each nested plan gets a proportion of the CPU resources assigned to its parent group.
• C.Only one nested subplan is allowed per parent plan
• D.Nested plans control only the degree of parallelism and I/O requests
• E.Nested plans only control resources used by recursive SQL

What two are the prerequisites for enabling Flashback Database?

• A.The database must be opened in RESTRICTED mode
• B.The database instance must have the keep buffer pool defined
• C.The database must be in ARCHIVELOG mode
• D.The database must be in MOUNT EXCLUSIVE mode
• E.The database instance must be started in the NOMOUNT state