Passing exam with 1z0-063 latest training materials

You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

• A. The target database must be in MOUNT state.
• B. RMAN must be connected to the target database instance and the auxiliary instance.
• C. Flashback must be enabled for the PROD database.
• D. A most recent backup set of the PROD database must exist.

Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?

• A. An error is returned because the retention period cannot be reduced.
• B. Data from the first and third years is purged from the flashback archive FDA1.
• C. Data older than two years, if any, is purged from the flashback archive FDA1.
• D. Data from the third year is purged from the flashback archive FDA1.
• E. Flashback archive FDA1 retains all data and the retention period is increased by 2 years.

View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'on PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?

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

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

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

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. 1, 3, 8, 11, 9
• B. 1, 3, 7, 10, 9
• C. 1, 2, 6, 3, 7, 10, 9
• D. 4, 8, 11, 5
• E. 1, 2, 6, 3, 8, 11, 9