Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 61:

  Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

  A. data files while the database is in NOMOUNT state

  B. data blocks in data files that have changed since the previous backup

  C. PFILE and password file in MOUNT state

  D. data files while the database is open

  E. online redo log files while the database is open

  Correct Answer: BD

• Question 62:

  In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:

  SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;

  What are three prerequisites for this command to succeed? (Choose three.)

  A. The recycle bin should be enabled.

  B. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.

  C. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.

  D. SCOTT should have the FLASHBACK ANY TABLE privilege.

  E. No other table with the same name should exist in the HR schema.

  F. Undo retention guarantee must be enabled.

  Correct Answer: ACD

• Question 63:

  During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.

  What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

  A. Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.

  B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.

  C. Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.

  D. Enable AMM and set the PGA_TARGET initialization parameter to a nonzero value.

  Correct Answer: B

• Question 64:

  You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

  RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE sales FROM ACTIVE DATABASE PASSWORD FILE SPFILE NOFILENAMECHECK;

  Which two statements are true? (Choose two.)

  A. RMAN must be connected to a recovery catalog for the execution of the command.

  B. A backup of the SALES PDB must exist before the execution of the command.

  C. The root and seed databases are included in the duplication.

  D. Only the SALES PDB is duplicated as the non-CDB CDBDUP.

  E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

  Correct Answer: CE

• Question 65:

  Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

  A. An unplugged PDB can be plugged into the same or another container database (CDB).

  B. PDB data files are automatically removed from disk.

  C. A PDB must have been opened at least once after creation.

  D. A PDB must be in closed state before it can be unplugged.

  E. A PDB must be in MOUNT state before it can be unplugged.

  Correct Answer: ADE

• Question 66:

  You install Oracle Grid Infrastructure for a standalone server and issue this command:

  crsctl start has

  Which two components get automatically added to the Oracle Restart configuration the first time this command is issued? (Choose two.)

  A. A database that already exists prior to the Grid Infrastructure installation

  B. Oracle Notification services

  C. Oracle Healthcheck services

  D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation

  E. Oracle CSSD services

  Correct Answer: CE

• Question 67:

  In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.

  Which statement is true about undo retention?

  A. Undo becomes expired obsolete after 1000 seconds.

  B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

  C. Inactive undo is retained for at least 1000 seconds if free undo space is available.

  D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.

  Correct Answer: B

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm

• Question 68:

  Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

  A. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.

  B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

  C. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.

  D. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.

  E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

  Correct Answer: AE

• Question 69:

  Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? (Choose the best answer.)

  A. from the most recent incremental checkpoint

  B. from the beginning of the current redo log file to the checkpoint position

  C. from the last committed transaction

  D. from the beginning of the current redo log file until the instance failure

  E. from the last complete checkpoint position

  Correct Answer: E

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT005

• Question 70:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

  A. Encrypted backups can only be written to disk.

  B. Image copy backups can be created by using password encryption.

  C. A database uses the same encryption key for every encrypted backup.

  D. Transparent encryption of backups uses an encryption wallet.

  E. A password encryption of backups uses the password while creating and restoring backups.

  Correct Answer: DE

  Reference: https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/rcmbackp006.htm