1Z0-067 Exam - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

NEW QUESTION 1
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Answer: D

NEW QUESTION 2
Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
-The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

• A. The RMAN backup fails because the tools tablespace is read-only.
• B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Answer: D

NEW QUESTION 3
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?

• A. All redo log files are opened.
• B. The root, the seed, and all the PDBs are opened in read-write mode.
• C. All the PDBs are opened in read-write mode.
• D. All the PDBs are in closed state.
• E. Only the root database is opened in read-write mod

Answer: AE

Explanation: The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn’t be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

NEW QUESTION 4
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

• A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Answer: A

Explanation: Multilevel Incremental Backups RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing dat
A. You can create a level 0 database backup as
backup sets or image copies. The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0. A level 1 incremental backup can be either of the following types: A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0. A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0. Incremental backups are differential by default.

NEW QUESTION 5
Which three statements are true about Oracle Restart?

• A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
• B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
• C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• D. It can be used to only start Oracle components.
• E. It runs periodic check operations to monitor the health of Oracle component

Answer: ABE

Explanation: A is correct: Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software
failure or whenever your database host computer restarts E is correct: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted. B is also true About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a
database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.
References: http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 6
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?

• A. ALTER TA3LESPACE adtbs RESI2E 20G;
• B. ALTER TA3LESPACE adtbs ADD DATAFILE;
• C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
• D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
• E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

NEW QUESTION 7
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MMDD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

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

Answer: A

NEW QUESTION 8
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E. Run ADDM in diagnostic mod

Answer: B

NEW QUESTION 9
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: create table employees
(empno number, salary number, deptid number, name varchar2(100), period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically created.
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queriesperformed by the sessio

Answer: ABC

NEW QUESTION 10
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

• A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
• B. In a PDB plan, subplans may be used with up to eight consumer groups.
• C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groupsacross all PDBs in the CDB.
• D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

Explanation: A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences:
Non-CDB Database Multi-level resource plans
Up to 32 consumer groups Subplans
PDB Database
Single-level resource plans only Up to 8 consumer groups
(Not B) No subplans

NEW QUESTION 11
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

• A. The script is executed and both DC1 and CH1 channels are used for script execution.
• B. The execution of the script fails because multiple channels cannot exist simultaneously.
• C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
• D. The new channel, CH1, is ignored because a channel has been configured alread

Answer: C

NEW QUESTION 12
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?

• A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
• B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
• D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
• E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE

Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 13
Which two statements describe the relationship between a window, a resource plan, and a job class?

• A. A window specifies a resource plan that will be activated when that window becomes active.
• B. A window specifies a job class that will be activated when that window becomes active.
• C. A job class specifies a window that will be open when that job class becomes active.
• D. A window in association with a resource plan controls a job class allocation.
• E. A window in association with a job class controls a resource allocatio

Answer: AE

Explanation: Windows work with job classes to control resource allocation. Each window specifies the resource plan to activate when the window opens (becomes active), and each job class specifies a resource
consumer group or specifies a database service, which can map to a consumer group. A job that runs within a window, therefore, has resources allocated to it according to the consumer group of its job class and the resource plan of the window.

NEW QUESTION 14
Which two statements are true about making RMAN image copies of a database? Choose two.

• A. They can be made only when the database is running in ARCHIVELOG mode.
• B. They consist of all used and unused blocks in the data files.
• C. They can be made only when the database is in MOUNT state.
• D. They can only be written to disk.
• E. They can be made only when the database is running in NOARCHIVELOG mod

Answer: BD

NEW QUESTION 15
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A. TYPE
• B. LOCATION
• C. PARALLEL
• D. DEFAULT DIRECTORY
• E. ORGANIZATION EXTERNAL

Answer: C

Explanation: Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

NEW QUESTION 16
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true? (Choose two.)

• A. You must ensure that the SALES database is mounted or open.
• B. You must restore a backup control file to perform a block media recovery.
• C. You must take the tools01.dbf data file offline before you start a block media recovery.
• D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

Answer: AE

NEW QUESTION 17
Examine the command used to perform an incremental level-0 backup: RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?

• A. The block change tracking data is used only from the next incremental backup.
• B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
• C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
• D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
• E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: CE