Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 81:

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

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

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

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

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

  Correct Answer: B

• Question 82:

  You are administering a multitenant container database (CDB) CDB1 with two pluggable databases

  (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:

  SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;

  SQL> GRANT CREATE SESSION TO c##scott;

  Which statement is true about the C##SCOTT user? (Choose the best answer.)

  A. It is created in all the PDBs with CREATE SESSION privilege.

  B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.

  C. It is created and has the CREATE SESSION privilege only in a PDB that is open.

  D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

  Correct Answer: D

• Question 83:

  You use RMAN to take regular backups for your database. Examine the RMAN commands:

  RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP;

  Which statement is true?

  A. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

  B. All backups that have exceeded the age set by the RMAN retention policy are deleted.

  C. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

  D. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

  Correct Answer: C

• Question 84:

  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?

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

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

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

  D. It lists failures only for the CDB root database.

  Correct Answer: B

• Question 85:

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

  Examine the steps required to perform the migration:

  1.

  Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.

  2.

  Place all tablespaces in read-only mode on the source database.

  3.

  Upgrade the source database to Oracle Database 12c.

  4.

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

  5.

  Create a new PDB in the target CDB.

  6.

  Synchronize the PDB on the target CDB.

  7.

  Use Data Pump import on the new PDB by using the full transportable import options.

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

  A. 1, 5, 4, 7, and 6

  B. 3, 2, 5, 1, 4, and 7

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

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

  Correct Answer: C

• Question 86:

  You issue the command:

  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  Which statement is true about the command?

  A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

  B. It creates a file that contains the SQL statement, which is required to re-create the control file.

  C. It updates the alert log file with the location and contents of the control file.

  D. It creates a binary backup of the control file.

  Correct Answer: B

  Explanation: "TO TRACE" creates a file with the SQL, not a copy of the control file.

• Question 87:

  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?

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

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

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

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

  Correct Answer: C

  Flashback data archives retain historical data across data definition language (DDL) changes to the database as long as the DDL change does not affect the structure of the table. The one exception to this rule is that flashback data archives do retain historical data when a column is added to the table. References: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm

• Question 88:

  Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has

  multiple pluggable databases (PDB):

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

  SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;

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

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

  SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER*ALL;

  Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

  A. The command fails and gives an error because object privileges cannot be granted to a common user.

  B. The command fails because container is not set to current.

  C. The command succeeds and the common user c##admin can create a session and query the DBA_users view in CDB$ROOT and all the PDBs.

  D. The command succeeds and the common user c##admin can create a session in CDB$ROOT and all the PDBs, but can only query the dba_users view in CDB$ROOT

  E. The command succeeds and the common user c##admin can create a session and query the DBA users view only in CDB$ROOT

  Correct Answer: C

• Question 89:

  Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

  A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.

  B. The MTTR advisor is enabled only if the value is greater than the default value.

  C. Automatic checkpoint tuning is enabled.

  D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

  Correct Answer: AB

  Reference: https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

• Question 90:

  You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).

  Which two are prerequisites for performing this operation? (Choose two.)

  A. You must take the tools01.dbf data file offline.

  B. You must ensure that the database is mounted or open.

  C. You must use an incremental level-1 backup to restore blocks.

  D. You must configure a block change tracking file.

  E. You must have full or level-0 backups to restore blocks.

  Correct Answer: BE

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmblock.htm#BRADV89785