Latest Oracle 1z0-067 Dumps PDF Questions Answers 2024

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 1

You execute the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk

RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT “/disk/%U’;

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT “/disk/%U’;

RMAN> BACKUP DATABASE;

Which statement is true about the backup set created by the BACKUP command?

Options:

Two channels are allocated and two copies of the backup set are taken in parallel in both locations

Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

The default channel is allocated and the backup set is created in only one destination

Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

Buy Now

Question 2

Examine the RMAN command:

RMAN> RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

BACKUP

INCREMENTAL LEVEL = 0

(DATAFILE 1, 4, 5 CHANNEL c1)

(DATAFILE 2, 3, 9 CHANNEL c2)

(DATAFILE 6, 7, 8 CHANNEL c3)

SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;

}

Which statement is true about the command?

Choose the best answer.

Options:

It uses multisection backup.

It uses parallelization for the backup set.

It uses asynchronous I/O for the backup.

It creates compressed backup sets.

Question 3

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?

Options:

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.

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.

Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Question 4

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which statement is true about the execution of this command to back up the database?

Options:

All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

All data files belonging to pdb2_1 are backed up along with the archive log files.

Only the data files belonging to pdb2_ are backed up.

This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Question 5

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;

SQL> CREATE ROLE C##CONNECT;

SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which statement is true about the c##connect role?

Options:

It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

It is granted to the c##admin user only in the CDB.

It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Question 6

ENCRYPT_TS is an encrypted tablespace that contains tables with data.

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

Options:

The data is decrypted during SORT and JOIN operations.

The data remains encrypted when it is read into memory.

The data remains encrypted when it is stored in the redo logs

The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Question 7

Which two are prerequisites for setting up Flashback Data Archive?

Options:

Fast Recovery Area should be defined.

Undo retention guarantee should be enabled.

Supplemental logging should be enabled.

Automatic Undo Management should be enabled.

All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.

The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Question 8

Which three statements are true about Scheduler Windows? (Choose three.)

Options:

Only one window can be open at one time.

Consumer groups are associated with windows.

Windows work with job classes to control resource allocation.

A database service name must be provided during window creation.

The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.

Question 9

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.

Options:

1, 4, 3

1, 2

1, 4, 3, 2

1, 2, 4

Question 10

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

Options:

A window specifies a Resource Manager plan that is automatically activated when the windows opens.

A window specifies a job class that will be activated when that window opens.

A job class specifies a window that will be open when that job class becomes active.

A window and the job class associated with a job controls resource allocation for that job.

A window and the Resource Manager plan that is active when a job runs determine the job class for the job.

Question 11

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

Options:

Compare Period ADDM report

AWR Compare Period report

Active Session History (ASH) report

taking a new snapshot and comparing it with a preserved snapshot

Question 12

Identify three benefits of unified auditing.

Options:

Decreased use of storage to store audit trail rows in the database.

It guarantees zero-loss auditing.

The audit trail cannot be easily modified because it is read-only

It improves overall auditing performance.

It automatically audits Recovery Manager (RMAN) events.

Question 13

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=>'onlinegrp'CPU_Pl=>60);

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?

Options:

The pending area is automatically submitted when creating plan directives.

The procedure must be executed before creating any plan directive.

The sys_group group is not included in the resource plan.

The other_groups group is not included in the resource plan.

Pending areas can not be validated until submitted.

Question 14

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

What could be the reason for this?

Options:

The event parameter was not set.

The sql_trace parameter is set to false.

Enterprise Manager was not used.

The statistics_level parameter is set to basic.

The t:kid_statistics parameter is set to false.

Question 15

Examine the output:

SQL > ARCHIVE LOGLIST

Database log mode Archive Mode

Automatic archival Enabled

Archive Destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 376

Next log sequence to archive 378

Current log sequence 378

Which three types of files are automatically placed in the fast recovery area?

Options:

Flashback data archives (FDA)

Archived redo log files

Control file autobackups

Server parameter file (SPFILE)

Recovery Manager (RMAN) backup pieces

Question 16

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

How would you achieve this?

Options:

by using the RMAN switch command to set the new location for the data files

by using the RMAN duplicate command with no filename check to recover the database to the new host

by using the RMAN duplicate command with dbid and set newname for tablespace to recover the database to the new host

by creating a new database in the new host, and then using the RMAN recover command

Question 17

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Options:

By default, EM express is available for a database after database creation.

You can use EM express to manage multiple databases running on the same server.

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

You can create and configure pluggable databases by using EM express.

Question 18

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

The following are the possible steps to accomplish this task:

1. Place all the user-defined tablespace in read-only mode on the source database.

2. Upgrade the source database to a 12c version.

3. Create a new PDB in the target container database.

4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

5. Copy the associated data files and export the dump file to the desired location in the target database.

6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify the correct order of the required steps.

Options:

2, 1, 3, 4, 5, 6

1, 3, 4, 5, 6, 7

1, 4, 3, 5, 6, 7

2, 1, 3, 4, 5, 6, 7

1, 5, 6, 4, 3, 2

Question 19

Which two statements are true about roles in multitenant container databases (CDBs)?

Options:

Local roles can be granted to local and common users.

A common role can be granted only to a common user.

A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

A common role can be granted only system privileges.

The root container can have both local and common roles.

A local role can be assigned to a common role in a PDB.

Question 20

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Options:

SQL Performance Analyzer

SQL Access Advisor

SQL Tuning Advisor

Automatic Workload Repository (AWR) report

Automatic Database Diagnostic Monitor (ADDM)

Question 21

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

What is the outcome?

Options:

The PDB is closed.

The PDB is placed in mount state.

The command executes only if the common user is granted the set container privilege for the PDB.

The command results in an error because the PDB can be shut down only by a local user.

Question 22

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

Options:

Oracle Data Pump

Oracle Recovery Manager (RMAN)

Oracle Label Security

Oracle Database Vault

Oracle Real Application Security

Question 23

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB:

SQL>STARTUP

Which statement is true?

Options:

CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode

CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode

CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode

CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode

Question 24

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.

Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid workload?

Options:

heap table with a primary key index

external table

hash clustered table

global temporary table

index clustered table

Question 25

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Options:

A DBA can check specific tables with the DMU

The database to be migrated must be opened read-only.

The release of the database to be converted can be any release since 9.2.0.8.

The DMU can report columns that are too long in the converted characterset

The DMU can report columns that are not represented in the converted characterset

Question 26

Which three statements are true about common roles? (Choose three.)

Options:

A common role can be granted only to a common user

Only system privileges can be granted to a common role to a container database (CDB)

Object privileges can be granted to a common role in a pluggable database (PDB)

A common rule cannot be created by a local user

A common user that is granted a common role can grant the role to other common and local users in a PDB

Question 27

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.

Options:

1, 4, 3, 2, 5

1, 3, 4, 5, 2

4, 3, 1, 2, 5

4, 3, 5, 1, 2

Question 28

Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.

Identify two events that can occur at the time of a log switch. (Choose two.)

Options:

All active transactions are rolled back and the database instance shuts down.

The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.

The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.

An entry is written in the alert log and the database instance is automatically placed in MOUNT state.

The log switch hangs until free space is available in the fast recovery area.

Question 29

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

Examine the command executed to back up pdb2_1:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

Options:

It fails because archive log files cannot be backed up using a connection to a PDB.

It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.

It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.

It fails because the pluggable clause is missing.

Question 30

Evaluate these statements:

CREATE TABLE purchase_orders

(po_idNUMBER(4),

po_dateTIMESTAMP,

supplier_idNUM8ER(6),

po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITIONBYRANGE(po_date)

(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));

CREATETABLEpurchase_order_items

(po_idNUM3ER(4)NOTNULL,

product_idNUMBER(6)NOTNULL,

unit_prlceNUMBER(8,2),

quantity NUMBER(8),

CONSTRAINTpo_items_f k

FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )

PARTITIONBYREFERENCE(po_items_fk);

Which two statements are true?

Options:

Partitions of purchase_order_items are assigned unique names based on a sequence.

The purchase_orders and purchase_order_items tables are created with four partitioneach.

purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Question 31

Which three RMAN persistent settings can be set for a database?

Options:

backup retention policy

default backup device type

default section size for backups

default destinations for backups

multiple backup device types for a single backup

Question 32

Which two are prerequisites for creating a backup-based duplicate database?

Options:

connecting to the target database and a recovery catalog to execute the duplicate command

creating a password file for an auxiliary instance

connecting to an auxiliary instance

matching the database identifier (DBID) of the source database and the duplicate database

creating an SPFILE for the target database

Question 33

Examine the command to duplicate a database:

RMAN> DUPLICATE TARGET DATABASE TO cdb

PLUGGABLE DATABASE pdb1, pdb5;

Which two statements are true about the DUPLICATE command?

Options:

The SPFILE is copied along with the data files of the pluggable databases (PDBs).

The root and the seed database in the container database (CDB) are also duplicated.

A backup of pdb1 and pd5 must exist before executing the command.

The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Question 34

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

Options:

It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.

It fails and reports an error because the container=all clause is not used.

It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.

It fails and reports an error because the comtainer=current clause is not used.

Question 35

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?

Options:

MAXSETSIZE TO 2;

DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';

DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Question 36

Which three statements are true about the database instance startup after an instance failure?

Options:

The RECO process recovers the uncommitted transactions at the next instance startup.

Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

Uncommitted changes are rolled back to ensure transactional consistency.

The SMON process automatically performs the database recovery.

Media recovery is required to complete the database recovery.

Changes committed before the failure, which were not written to the data files, are re-applied.

Question 37

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host. What must you do to make the database operational in OUSERVER1?

Options:

Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location

Restore the control file from the backup by using the CATALOG options, restore the data files by using the SET NEWNAME command, and recover the data files

Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files

Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files

Question 38

You set the following parameters in the parameter file and restart the database instance:

MEMORY_MAX_TARGET=0

MEMORY__TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true?

Options:

The memory_max_target parameter is automatically set to 500 MB.

The pga_aggregate_target and sga_target parameters are automatically set to zero.

The value of the memory_max_target parameter remains zero for the database instance.

The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Question 39

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

(Choose two.)

Options:

An ASM instance mounts an ASM control file

An ASM instance uses the ASMB process for rebalancing of disks within a disk group

Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Exam Detail

Vendor: Oracle

Certification: Oracle Other Certification

Exam Code: 1z0-067

Exam Name: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Last Update: Dec 22, 2024

1z0-067 Question Answers

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-067 Dumps Questions Answers

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer: