Unlock your Full 1z0-067 Oracle Stable Exam

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

Question 1

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 2

You are connected to a recovery catalog and target database. You execute the command:

RMAN> CATALOG START WITH ‘/disk1/backups’;

Which statement is true?

Options:

It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.

Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

Question 3

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

Which statement is true about the database that is created? (Choose the best answer.)

Options:

It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

It is created as a PDB that must be plugged into an existing CDB.

It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

Question 4

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours.

After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database.

Examine the possible steps involved in the recovery process:

Mount the database

Take the data file offline

Bring the tablespace online

Use the RMAN SWITCH command to switch to the image copy

Recover the tablespace

Open the database

Use the RMAN RESTORE command to switch to the image copy

Identify the correct sequence of the required steps:

Options:

2, 7, 5, 3

2, 4, 5, 3, 6

1, 2, 4, 6, 3

1, 2, 7, 5, 3, 6

2, 6, 4, 5, 3

Question 5

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

i.Long-running queries are not affected.

ii.No extra space is used.

iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.

iv.Unused space is reclaimed both above and below the high water mark.

Which alter TABLE option would you recommend?

Options:

DEALLOCATE UNUSED

SHRINK SPACE CASCADE

SHRINK SPACE COMPACT

ROW STORE COMPRESS BASIC

Question 6

Which three types of failures are detected by the Data Recovery Advisor (DRA)?

Options:

loss of a non-critical data file

loss of a control file

physical data block corruption

logical data block corruption

loss of an archived redo log file

Question 7

You want to create a database and you have the following:

Oracle Grid Infrastructure is installed and configured

Oracle Database Vault is installed in ORACLE_HOME to be used for this database

Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server

Examine the requirements:

Configuring the database instance to support shared server mode

Using Automatic Storage Management (ASM) for storing database files

Configuring a naming method to help a remote user connect to a database instance

Configuring the Fast Recovery Area

Configuring Database Vault

Configuring Enterprise Manager (EM) Database Express

Registering with EM Cloud Control

Configuring remote log archive destinations

Enabling daily incremental backups

Configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

Options:

1,2,3,4,5,6,8,9, and 10

1,2, 4,5,6,7, and 8

1, 2, 3, 8, 9, and 10

1, 2, 4, 5, 7, 8, 9, and 10

1, 2, 4, 5, 6, and 7

Question 8

You issue the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which three tasks are performed by the BACKUP DATABASE command?

Options:

switching the online redo log file

backing up all data files as image copies and archive log files, and deleting those archive log files

backing up only the used blocks in the data files

backing up all used and unused blocks in the data files

backing up all archived log files and marking them as obsolete

Question 9

Examine the RMAN command:

RMAN> BACKUP VALIDATE DATABASE;

Which statement is true about the execution of the command?

Options:

Block change tracking must be enabled before executing this command.

The database must be running in archivelog mode for the successful execution of this command.

A complete database backup must exist before executing this command.

The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Question 10

Which three statements are true about Oracle Secure Backup (OSB)?

Options:

It can encrypt client data written to tape.

It can be used to take image copy backups to tape.

It can be used to manage tape backup and restore operations for multiple databases.

It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.

It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Question 11

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

Options:

Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Question 12

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

Options:

A PDB opened in restricted mode allows only local users to connect.

When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

When a CDB is in mount state, PDBs are automatically placed in mount state.

All PDBs must be shut down before shutting down a CDB instance.

When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

Question 13

You have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

1.Create directory structures similar to the production database on all new machines.

2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

3.Create a database clone template for the database.

4.Run the Database Configuration Assistant (DBCA) to create the database.

5.Run OUI in graphical mode on each machine.

6.Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

Options:

2, 1, 6, and 4

2, 3, and 6

3, 1, 5, and 6

2, 3, 1, and 6

1, 5, and 4

Question 14

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

Examine the command:

RMAN> LIST FAILURE;

Which statement is true about this command?

Options:

It lists failures only if RMAN is connected to a PDB.

It lists failures for the CDB and all the PDBs in this CDB.

It lists failures for a PDB only when RMAN is connected to a recovery catalog.

It lists failures only for the CDB root database.

Question 15

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?

Options:

Create both jobs by using Scheduler raised events.

Create both jobs using application raised events.

Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Question 16

In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

You rename the undotbs undo tablespace:

ALTER TABLESPACE undotbs RENAME TO undotbs_old;

Which statement is true?

Options:

The tablespace will be renamed but the data file headers will not be updated.

The statement will fail because you cannot rename an undo tablespace.

The tablespace will be renamed and all the changes will be logged in the alert log.

The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Question 17

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?

Options:

The script is executed and both DC1 and CH1 channels are used for script execution.

The execution of the script fails because multiple channels cannot exist simultaneously.

The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

The new channel, CH1, is ignored because a channel has been configured already.

Question 18

Which two statements are true about Flashback Version Query?

Options:

The result of a query can be used as part of a DML statement.

It can be used to create views.

It can be used only if Flashback Data Archive is enabled for a table.

It retrieves all versions of rows that exist in a time interval, including the start time and end time.

It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Question 19

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.

How would you achieve this?

Options:

Implement a Database Resource Manager plan

Implement a profile for these users

Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

Specify the maximum amount of quota a user can be allocated in the undo tablespace

Question 20

Examine this command:

SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE’;

Which statement is true?

Options:

It forces SecureFiles to be created even if the BASICFILE option is specified

It forces SecureFiles to be created using default values and ignores any SECUREFILE parameters

It forces BasicFiles to be created even if the SECUREFILE option is specified

It ignores the SECUREFILE option only if storing the LOB segment in a Free List managed tablespace

Question 21

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 22

Which three statements are true about Consolidated Database Replay?

Options:

The workload capture and replay systems must have the same operating system (OS).

Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

A subset of the captured workload can be replayed.

The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Question 23

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods are performed the truncated table data? (Choose two.)

Options:

Table Point-in-Time Recovery.

Database Point-in-Time Recovery

Tablespace Point-in-Time Recovery

Flashback Database

Flashback Transaction Backout

Question 24

Which two statements are true about making RMAN image copies of a database?

Choose two.

Options:

They can be made only when the database is running in ARCHIVELOG mode.

They consist of all used and unused blocks in the data files.

They can be made only when the database is in MOUNT state.

They can only be written to disk.

They can be made only when the database is running in NOARCHIVELOG mode.

Question 25

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Options:

Reduced logical I/O

Reduced virtual memory utilization

Improved Serial Execution performance

Reduced physical I/O

Reduced CPU utilization

Question 26

Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.

Examine the steps to restore the SPFILE and the control file to mount the database:

1. Set DBID of the target database in RMAN.

2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.

3. Restore the control files from the backup.

4. Mount the database.

5. Restore the SPFILE from the autobackup.

6. Create a PFILE from the recovered SPFILE.

7. Restart the instance in NOMOUNT state.

Identify the required steps in the correct order.

Options:

1, 2, 5, 3, 6, 4

1, 2, 3, 5, 6, 4

2, 1, 5, 7, 3, 4

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

Question 27

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 28

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?

Options:

ALTER TA3LESPACE adtbs RESI2E 20G;

ALTER TA3LESPACE adtbs ADD DATAFILE;

ALTER TABLESPACE adtbs AUTOEXTEND ON;

ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Question 29

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 30

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 31

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

-------------------------

SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

PL/SQL procedure successfully completed.

SQL> select number_value from redaction_values_for_type_full;

NUMBER VALUE

------------------------

-1

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

Options:

Re-enable redaction policies that use FULL data redaction.

Re-create redaction policies that use FULL data redaction.

Re-connect the sessions that access objects with redaction policies defined on them.

Flush the shared pool.

Restart the database instance.

Question 32

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 33

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?

Options:

The valid time columns employee_time_start and employee_time_end are automatically created.

The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

The valid time columns are not populated by the Oracle Server automatically.

The valid time columns are visible by default when the table is described.

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 queries performed by the session.

Question 34

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

Options:

Default permanent tablespaces can be shared across pluggable databases (PDBs).

The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

Each PDB can have its own default temporary tablespace.

The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Question 35

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

Options:

It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

It executes successfully and continues to store metadata related to the EMPLOYEES table.

It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Question 36

Examine the commands executed to monitor database operations:

$> conn sys/oracle@prod as sysdba

SQL> VAR eid NUMBER

SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');

Which two statements are true?

Options:

Database operations will be monitored only when they consume a significant amount of resource.

Database operations for all sessions will be monitored.

Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

Only DML and DDL statements will be monitored for the session.

All subsequent statements in the session will be treated as one database operation and will be monitored.

Question 37

Which three statements are true about Flashback Data Archieve? (Choose three.)

Options:

A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first

While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve

To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace

Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database

Question 38

Which four actions are possible during an Online Datafile Move operation?

Options:

Creating and dropping tables in the datafile being moved

Performing file shrink of the data file being moved

Querying tables in the datafile being moved

Performing Block Media Recovery for a data block in the datafile being moved

Flashing back the database

Executing DML statements on objects stored in the datafile being moved

Question 39

Which three statements are true about Oracle Restart?

Options:

It can be configured to automatically attempt to restart various components after a hardware or software failure.

While starting any components, it automatically attempts to start all dependencies first and in proper order.

It can be configured to automatically restart a database in case of normal shutdown of the database instance.

It can be used to only start Oracle components.

It runs periodic check operations to monitor the health of Oracle components.

Load More 1z0-067 Questions

Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo

Activedumpsnet Navigation

Activedumpsnet Slider

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

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

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation: