Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 71:

  A redaction policy was added to the SAL column of the SCOTT.EMP table:

  BEGIN

  DBMS_REDACT.ADD_POLICY(

  OBJECT_SCHEMA => `SCOTT',

  OBJECT_NAME => `EMP',

  POLICY_NAME => `SCOTT_EMP',

  COLUMN_NAME => `SAL',

  EXPRESSION => `SYS_CONTEXT (``SYS_SESSION_ROLES'', ``MGR'') = ``FALSE''');

  END;

  /

  All users have their default set of system privileges.

  For which three situations will data not be redacted? (Choose three.)

  A. SCOTT sessions, because he is the owner of the table

  B. SCOTT sessions, only if the MGR role is granted to SCOTT

  C. SCOTT sessions, only if the MGR role is set in the session

  D. SYS sessions, regardless of the roles that are set in the session

  E. SYSTEM sessions, regardless of the roles that are set in the session

  Correct Answer: BCD

• Question 72:

  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.)

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

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

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

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

  Correct Answer: D

• Question 73:

  The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.

  The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.

  You execute the RMAN commands: RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11

  Which two tasks are performed as part of the import? (Choose two.)

  A. All databases registered in the RC11 catalog are registered in the RC12C catalog.

  B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

  C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

  D. Imported databases are unregistered from the RC11 catalog.

  E. Recovery catalog is resynchronized with the control files of the registered databases.

  Correct Answer: AD

• Question 74:

  Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Import metadata into the target database.

  4.

  Transfer the dump file and data files to the target machine.

  5.

  Convert data files by using Recovery Manager (RMAN).

  6.

  Make the tablespace read-write at the target database.

  Identify the required steps in the correct order. (Choose the best answer.)

  A. 1, 2, 4, 3, and 6

  B. 2, 4, 3, and 5

  C. 2, 4, and 3

  D. 1, 5, 2, 4, 3, and 6

  Correct Answer: A

• Question 75:

  Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The

  local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2

  connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.

  Examine the commands to change the value of the PDB modifiable initialization parameter:

  $> sqlplus sys/oracle_4U@pdb1 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH;

  SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

  SQL> CONN sys/oracle_4U@pdb1 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

  Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the

  best answer.)

  A. It gives an error because it cannot be set for the root database.

  B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.

  C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.

  D. It is set to TRUE for the root database and all the PDBs, but is effective only when CDB is restarted and the PDBs are reopened.

  Correct Answer: B

  Reference: https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1

• Question 76:

  Which four tablespace types can be renamed? (Choose four.)

  A. the default permanent tablespace

  B. the SYSTEM tablespace

  C. a temporary tablespace

  D. a read-only tablespace

  E. an offline tablespace

  F. an undo tablespace

  Correct Answer: ACDF

  Reference: http://www.dba-oracle.com/t_rename_tablespace_syntax.htm

• Question 77:

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

  A. Local roles can be granted to local and common users.

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

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

  D. A common role can be granted only system privileges.

  E. The root container can have both local and common roles.

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

  Correct Answer: DF

• Question 78:

  You issue the RMAN command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

  Which statement is true about the execution of the command? (Choose the best answer.)

  A. The backup succeeds only if the USERS tablespace is locally managed.

  B. RMAN uses multiplexing to perform the backup.

  C. The resulting backupset has backup pieces that cannot exceed 300 MB.

  D. RMAN always performs this type of backup in parallel.

  E. The backup set size is limited to 300 MB.

  Correct Answer: C

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#BRADV89541

• Question 79:

  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 mode.

  Correct Answer: BD

• Question 80:

  In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

  SQL> GRANT create tablespace to C##A_ADMIN;

  Which statement is true? (Choose the best answer.)

  A. The command fails because the CONTAINER clause is not used.

  B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

  C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).

  D. The command fails because system privileges cannot be granted to a common user.

  Correct Answer: B