Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 21:

  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
  B. data blocks in data files that have changed since the previous backup
  D. data files while the database is open

• Question 22:

  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.
  D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

• Question 23:

  Examine the RMAN command:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1, 4, 5 CHANNEL c1)

  (DATAFILE 2, 3, 9 CHANNEL c2)

  (DATAFILE 6, 7, 8 CHANNEL c3)

  SQL `ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

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

  A. It uses multisection backup.
  B. It uses parallelization for the backup set.
  C. It uses asynchronous I/O for the backup.
  D. It creates compressed backup sets.
  B. It uses parallelization for the backup set.

• Question 24:

  Your database is running in archive log mode and Automatic Undo Management is enabled.

  Which two tasks should you perform before enabling Flashback Database?

  A. Enable minimal supplemental logging.
  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
  C. Enable the recyclebin.
  D. Enable undo retention guarantee.
  E. Enable Fast Recovery Area.
  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
  E. Enable Fast Recovery Area.

  ---

  Section: About Flashback Database Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. To take advantage of this feature, you must set up your database in advance to create flashback logs. References:https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582

• Question 25:

  You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

  Examine the table definition:

  create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

  Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.
  D. The valid time columns are visible by default when the table is described.
  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.

  ---

  Reference: https://docs.oracle.com/database/121/ARPLS/d_flashb_archive.htm#ARPLS74552

• Question 26:

  RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:

  RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE;

  Which two statements are true about the execution of the DUPLICATE command?

  A. All archive redo log files are automatically copied to the duplicate database.
  B. The duplicate database has the same directory structure as the source database.
  C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
  D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
  E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.
  A. All archive redo log files are automatically copied to the duplicate database.
  E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

• Question 27:

  Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

  A. Reduced logical I/O
  B. Reduced virtual memory utilization
  C. Improved Serial Execution performance
  D. Reduced physical I/O
  E. Reduced CPU utilization
  B. Reduced virtual memory utilization
  E. Reduced CPU utilization

• Question 28:

  Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.

  Examine the steps to recover the online redo log group and move it to a new location.

  1.Restore the corrupted redo log group.

  2.Restore the database from the most recent database backup.

  3.Perform an incomplete recovery.

  4.Relocate the member of the damaged online redo log group to a new location.

  5.Open the database with the resetlogs option.

  6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

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

  ---

  If the group is Current Then it is the log that the database is currently writing to And you should Attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log. Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/recoscen.htm#i1006437

• Question 29:

  You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation

  language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.

  How would you achieve this?

  A. Implement a Database Resource Manager plan
  B. Implement a profile for these users
  C. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions
  D. Specify the maximum amount of quota a user can be allocated in the undo tablespace
  A. Implement a Database Resource Manager plan

• Question 30:

  Which two statements are true about Flashback Version Query?

  A. The result of a query can be used as part of a DML statement.
  B. It can be used to create views.
  C. It can be used only if Flashback Data Archive is enabled for a table.
  D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
  E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
  D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
  E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

  ---

  Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004