Free 1z0-067: Upgrade Oracle9i10g11g OCA OR OCP to Oracle Database 12c OCP Exam Questions and Answers

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

Select 3 answers.

• AA. Set the backup_tape_io_slaves parameter to true.
• BB. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• CC. Configure large pool if not already done.
• DD. Remove the rate parameter, if specified, in the allocate channel command.
• EE. Always use RMAN compression for tape backups rather than the compression provided by media manager.
• FF. Always use synchronous I/O for the databas

For which three pieces of information can you use the RMAN list command?

Select 3 answers.

• AA. stored scripts in the recovery catalog
• BB. available archived redo log files
• CC. backup sets and image copies that are obsolete
• DD. backups of tablespaces
• EE. backups that are marked obsolete according to the current retention policy

Which three statements are true about a job chain?

Select 3 answers.

• AA. It can contain a nested chain of jobs.
• BB. It can be used to implement dependency-based scheduling.
• CC. It cannot invoke the same program or nested chain in multiple steps in the chain.
• DD. It cannot have more than one dependency.
• EE. It can be executed using event-based or time-based schedule

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. Examine the steps to recover this table from an RMAN backup: 1. Determine which backup contains the table that needs to be recovered. 2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified. 3. Import the Data Pump export dump file into the auxiliary instance. 4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

• AA. 1, 4, 3
• BB. 1, 2
• CC. 1, 4, 3, 2
• DD. 1, 2, 4

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database. NAME TYPE VALUE -------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring What is the location of the ADR base?

• AA. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
• BB. It is set to /u01/app/oracle/admin/en12.1.0/adump.
• CC. It is set to /u01/app/oracle.
• DD. It is set to /u01/app/oracle/flash_recovery_are

You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

• AA. Create both jobs by using Scheduler raised events.
• BB. Create both jobs using application raised events.
• CC. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• DD. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

• AA. MAXSETSIZE TO 2;
• BB. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• CC. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• DD. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Which two statements are true when row-archival management is enabled?

Select 2 answers.

• AA. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• BB. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• CC. The row archival visibility session parameter defaults to all rows.
• DD. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• EE. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1.Create media families for data files and archived redo log files. 2.Configure database backup storage selectors or RMAN media management parameters. 3.Create an OSB user preauthorized for RMAN operations. 4. Configure RMAN Access to the OSB SBT. 5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

• AA. 1, 4, 3, 2, 5
• BB. 1, 3, 4, 5, 2
• CC. 4, 3, 1, 2, 5
• DD. 4, 3, 5, 1, 2

The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

• AA. 2, 4, 5
• BB. 2, 1, 4, 3, 5
• CC. 1, 2, 3, 4, 5
• DD. 1, 2, 4, 5