Online Access Free 1z1-067 Exam Questions

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?

• A.All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time
• B.An error is returned because the retention period cannot be reduced
• C.All historical data older than two years, if any, is purged from the flashback archive FDA1.
• D.All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

Which two statements are true regarding an Automatic Storage Management (ASM) instance?
(Choose two.)

• A.Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
• B.An ASM instance mounts an ASM control file
• C.An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
• D.An ASM instance uses the ASMB process for rebalancing of disks within a disk group

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

• A.default encryption
• B.password-mode encryption
• C.dual-mode encryption
• D.transparent encryption

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1.Start the RMAN client by using the RMAN target / command.
2.Start the RMAN client by using the OSB user.
3.RMAN creates the backup pieces.
4.Run the RMAN backup command with the sbt channels.
5.OSB creates a backup job and assigns a unique identifier.
6.OSB creates a backup job request through the OSB sbt library.
7.OSB stores metadata about RMAN backup pieces in the OSB catalog.
8.OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

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

View the Exhibit showing steps to create a database resource manager plan.
SQL>executedbms_resource_manager.create_pendingarea();
PL/SQLproceduresuccessfully completed.
3QL>execdbms_resource_manager,create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQLproceduresuccessfullycompleted.
SQL>execdbras_resource_raanager.create_plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comraent=>'on PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A.The pending area is automatically submitted when creating plan directives.
• B.Pending areas can not be validated until submitted.
• C.The other_groups group is not included in the resource plan.
• D.The procedure must be executed before creating any plan directive.
• E.The sys_group group is not included in the resource plan.