1z0-067 sample questions

Question 1

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##rolel 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?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 2

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?

Accepted Answer

|t is granted to the c##admin useri n all PDBs and can be granted object and system privileges for a PDB.

Answer

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

Answer

|t is granted to the c##admin useri n all PDBs and can be granted only to a local user in a PDB.

Answer

|t is granted to the c##admin usero nly in the CDB.

Question 3

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command: $sqlplusscott/tiger@DBOI As sysdba where DB01 is the net service name.

Which authentication method will be attempted first?

Accepted Answer

authentication by password file

Answer

authentication by using certificates over SSL

Answer

authentication by using the local OS of the database server

Answer

authentication by using the Oracle Internet Directory

Question 4

Which statement is true about unified auditing?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 5

RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two statements are true about the backup performed by the command? (Choose two.)

Accepted Answer

It backs up all the archived log files and deletes the ones that were just backed up

Accepted Answer

Only the used blocks in the data files are backed up

Answer

|t backs up all the data files and deletes obsolete backups after the backup is complete

Answer

|t backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete

Answer

It backs up only those archived log files that are not backed up at least once

Question 6

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Accepted Answer

The DBA role should be granted to the virtual catalog owner.

Accepted Answer

A base recovery catalog should exist.

Accepted Answer

The register database privilege should be granted to the virtual catalog owner.

Answer

At least one target database should be registered in the recovery catalog.

Answer

The owner of VPC cannot own recovery catalog.

Question 7

Identify three benefits of unified auditing.

Accepted Answer

It automatically audits Recovery Manager (RMAN) events.

Accepted Answer

An audit trail cannot be modified because it is read-only.

Accepted Answer

It reduces overhead on a database caused by auditing, by having a single audit trail.

Answer

|t guarantees zero-loss auditing.

Answer

|t helps to reduce disk space used to store an audit trail in a database.

Question 8

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees

Which two statements are true about the command?

Accepted Answer

It fails if the hr user does not have the create any directory privilege.

Accepted Answer

|t succeeds with default settings if the employees table exists in the hr schema.

Answer

|t fails because no SQL*Loader data file location is specified.

Answer

|t fails because no SQL*Loader control file location is specified.

Answer

|t succeeds and creates the employees table in the HR schema.

Question 9

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 ‘7disk/%U’; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘7disk/%U’; RMAN> BACKUP DATABASE;

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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

1z0-067 Upgrade Oracle 9i/10g/11g to Oracle Database 12c OCP Practice Questions

Create an account to continue.

Create an account to continue.

Related exams