Note! Following 1z0-067 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:

Question # 25

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.

The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.

A database with dbid=1423241 is registered in the catdb11 catalog. Both the recovery catalog databases are open.

In the CATDB12c database, you execute the commands:

$rman

RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c

RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;

What is the outcome of the import?

It fails because the target database and recovery catalog database are of different versions.

It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

It succeeds but the database is not automatically registered in the RC12C catalog.

It fails because RMAN is not connected to the target database with DBID=1423241

Full Access

Question # 26

You execute the commands to configure settings in RMAN:

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DRVICE TYPE DISK TO 2;

Then you issue the following command to take a backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of these commands?

Choose the best answer.

It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

The backup terminates because the backup destination for disk is not specified in the BACKUP command.

It backs up the data files and archived logs, making one copy of each data file and archived log on disk and media.

Full Access

Question # 27

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

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.

Full Access

Question # 28

Which statement is true about unified auditing?

The unified audit trail contains audit records only from unified audit policies and AUDIT settings

Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS

Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE

The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace

Full Access

Question # 29

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.

A user issues a query on the orders table and receives the following error:

ERROR at line 1:

ORA-01565: error in identifying file

'/u01/app/oracle/oradata/TEST/temp01.tmp'

ORA-27037: unable to obtain file status

What would be the most efficient way to rectify this error?

Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Full Access

Question # 30

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

assigned to a class with rights to browse all directories and catalogs

assigned to a class with rights to back up or restore Oracle database

OSB encryption for data in transport and on tape

RMAN preauthorization on the host

matching the OS user identity of the Oracle instance associated with the database username

scheduling of the RMAN backup to occur automatically at user-defined intervals

Full Access

Question # 31

Examine the RMAN command:

RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which type of encryption is used for the backup performed by using this command?

password-mode encryption

dual-mode encryption

transparent encryption

default encryption

Full Access

Question # 32

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Setting the target tablespace to read-only after the segments are moved

The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used

Taking the target tablespace offline after the segments are moved

The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Full Access