Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 151:

  Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

  You execute this command:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

  Which statement is true?

  A. The minimum size for the standard buffer cache is 100 MB.
  B. The maximum size for the standard buffer cache is 100 MB.
  C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
  D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
  E. The minimum size for all buffer caches is 100 MB.
  A. The minimum size for the standard buffer cache is 100 MB.

  ---

  If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

• Question 152:

  In which three scenarios is media recovery required?

  A. when a tablespace is accidentally dropped from a database
  B. when archived redo log files are lost
  C. when data files are lost
  D. when one of the online redo log members is corrupted
  E. when all control files are lost
  A. when a tablespace is accidentally dropped from a database
  B. when archived redo log files are lost
  E. when all control files are lost

  ---

  References: https://docs.oracle.com/cd/A81042_01/DOC/server.816/a76993/recoscen.htm

• Question 153:

  Examine the output:

  SQL > ARCHIVE LOGLIST

  Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378

  Which three types of files are automatically placed in the fast recovery area?

  A. Flashback data archives (FDA)
  B. Archived redo log files
  C. Control file autobackups
  D. Server parameter file (SPFILE)
  E. Recovery Manager (RMAN) backup pieces
  B. Archived redo log files
  C. Control file autobackups
  E. Recovery Manager (RMAN) backup pieces

  ---

  References: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

• Question 154:

  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.
  B. It lists failures for the CDB and all the PDBs in this CDB.

• Question 155:

  You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

  A. Temporary undo reduces the amount of undo stored in undo tablespaces
  B. Performance improves because less redo is written to the redo log
  C. Performance improves because no redo and undo are generated for the temporary tables
  D. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache
  A. Temporary undo reduces the amount of undo stored in undo tablespaces
  B. Performance improves because less redo is written to the redo log

• Question 156:

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

• Question 157:

  Examine the RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which prerequisite must be met before accomplishing the backup?

  A. The password for the encryption must be set up.
  B. Oracle wallet for the encryption must be set up.
  C. All the tablespaces in the database must be encrypted.
  D. Oracle Database Vault must be enabled.
  B. Oracle wallet for the encryption must be set up.

  ---

  Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command. CONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level. Reference:http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH

• Question 158:

  You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

  Examine the steps required to recover the database:

  1.Restore an autobackup of the server parameter file.

  2.Restore the control file.

  3. Start up the database instance in nomount state.

  4.Mount the database.

  5.Restore the data files.

  6.Open the database with the resetlogs option.

  7.Recover the data files.

  8.Set DBID for the database.

  Identify the required steps in the correct order.

  A. 1, 8, 3, 2, 4, 5, 7, 6
  B. 8, 1, 3, 2, 4, 5, 7, 6
  C. 1, 3, 2, 4, 8, 5, 6, 7
  D. 8, 3, 2, 4, 5, 7, 6
  E. 8, 1, 3, 2, 4, 5, 6
  D. 8, 3, 2, 4, 5, 7, 6

• Question 159:

  You create two Resource Manager plans, one for night time workloads, the other for day time.

  How would you make the plans switch automatically?

  A. Use job classes.
  B. Use scheduler windows.
  C. Use the mapping rule for the consumer groups.
  D. Set the switch_time plan directive for both plans.
  E. Use scheduler schedules.
  B. Use scheduler windows.

  ---

  The resource manager is only activated when a default resource plan is assigned. Only one resource plan can be active at any given time. Resource plan switches can be automated using scheduler windows or performed manually by setting the resource_manager_plan parameter using the alter system command as shown below. References: http://www.dba-oracle.com/job_scheduling/resource_manager_plan.htm

• Question 160:

  Identify two scenarios in which the RMAN crosscheck command can be used.

  A. when checking for backups that are not required as per the retention policy
  B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
  C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
  D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
  E. when listing backups that are required for recovery operations
  B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
  C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible