Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 11:

  What two are the prerequisites for enabling Flashback Database?

  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode
  C. The database must be opened in RESTRICTED mode
  D. The database instance must be started in the NOMOUNT state
  E. The database instance must have the keep buffer pool defined
  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode

• Question 12:

  In which three situations must you use a recovery catalog? (Choose three.)

  A. when you want to store RMAN global scripts that can be used across multiple databases
  B. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command
  C. when you want to restrict the amount of space used by backups
  D. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter
  E. when you want to perform incremental backups by using a block change tracking file
  A. when you want to store RMAN global scripts that can be used across multiple databases
  B. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command
  D. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

• Question 13:

  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?

  A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
  B. It is granted to the c##admin user only in the CDB.
  C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
  D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
  D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

  ---

  "CONTAINER Clause The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you

  must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER =

  CURRENT, which is the default when you are connected to a PDB."

  References:https://docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311

• Question 14:

  Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

  A. An ASM instance mounts an ASM control file
  B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

• Question 15:

  Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:

  1.Create media families for data files and archived redo log files.

  2.Configure database backup storage selectors or RMAN media management parameters.

  3.Create an OSB user preauthorized for RMAN operations.

  4.Configure RMAN Access to the OSB SBT.

  5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.

  Identify the steps in the correct order.

  A. 1, 4, 3, 2, 5
  B. 1, 3, 4, 5, 2
  C. 4, 3, 1, 2, 5
  D. 4, 3, 5, 1, 2
  C. 4, 3, 1, 2, 5

  ---

  Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14234/obadm_odb.htm#BDCBGJBF

• Question 16:

  You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.

  You execute the following command to change the requirement:

  SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;

  What is the outcome?

  A. An error is returned because the retention period cannot be reduced
  B. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time
  C. All historical data older than two years, if any, is purged from the flashback archive FDA1.
  D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
  C. All historical data older than two years, if any, is purged from the flashback archive FDA1.

• Question 17:

  The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.

  You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

  NAME TYPE VALUE

  audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring

  What is the location of the ADR base?

  A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
  B. It is set to /u01/app/oracle/admin/en12.1.0/adump.
  C. It is set to /u01/app/oracle.
  D. It is set to /u01/app/oracle/flash_recovery_area.
  C. It is set to /u01/app/oracle.

  ---

  The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. The ADR root directory is known as ADR base. Its location is

  set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:

  If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.

  If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

  Reference:

  http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008

• Question 18:

  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.
  B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

  ---

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

• Question 19:

  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
  C. 2, 5, 1, 4, 7, and 6

• Question 20:

  A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.

  What type of backup do you recommend to improve the performance of the backup?

  A. image copy backup by using RMAN
  B. multisection image copy backup by using RMAN
  C. multisection parallel backup by using RMAN
  D. cold backup after taking the tablespace offline
  E. cold backup after placing the tablespace in backup mode
  C. multisection parallel backup by using RMAN