Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 251:

  Which two statements are true about making RMAN image copies of a database? (Choose two.)

  A. They can be made only when the database is running in ARCHIVELOG mode.
  B. They consist of all used and unused blocks in the data files.
  C. They can be made only when the database is in MOUNT state.
  D. They can only be written to disk.
  E. They can be made only when the database is running in NOARCHIVELOG mode.
  B. They consist of all used and unused blocks in the data files.
  D. They can only be written to disk.

• Question 252:

  You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.

  One of the data files is corrupted and the current online redo log file is lost because of a media failure.

  Which action must you take for recovery?

  A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
  B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
  C. Restore all the data files, recover them by using the recover database command, and open the database.
  D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
  B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

  ---

  See Example 3-6 Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATAB ASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS; Reference: https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140

• Question 253:

  Your database supports an OLTP workload. Examine the output of the query:

  SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttr estimated_mttr

  0 76

  To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.

  What is the effect of this setting on the database?

  A. Automatic checkpoint tuning is disabled.
  B. The frequency of log switches is increased.
  C. The overhead on database performance is increased because of frequent writes to disk.
  D. The MTTR advisor is disabled.
  C. The overhead on database performance is increased because of frequent writes to disk.

  ---

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

• Question 254:

  Which three statements are true about Oracle Secure Backup (OSB)?

  A. It can encrypt client data written to tape.
  B. It can be used to take image copy backups to tape.
  C. It can be used to manage tape backup and restore operations for multiple databases.
  D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
  E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.
  A. It can encrypt client data written to tape.
  C. It can be used to manage tape backup and restore operations for multiple databases.
  E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

  ---

  File system backups may be performed at the file, directory, file system or raw partition level with full, incremental and offsite backup scheduling. As backup needs grow requiring more tape drives and centralized backup management of

  multiple servers, Oracle Secure Backup XE can be easily upgraded to the Oracle Secure Backup edition.

  Reference:

  http://www.oracle.com/technetwork/products/secure-backup/learnmore/osb-xe-10-130649.pdf

• Question 255:

  Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which statement is true about the execution of this command to back up the database?

  A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
  B. All data files belonging to pdb2_1 are backed up along with the archive log files.
  C. Only the data files belonging to pdb2_ are backed up.
  D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.
  C. Only the data files belonging to pdb2_ are backed up.

  ---

  Reference: http://docs.oracle.com/database/121/BRADV/rcmcnctg.htm#BRADV005

• Question 256:

  Which two statements are true about Enterprise Manager (EM) Express in Oracle Database 12c? (Choose two.)

  A. You can perform basic administrative tasks for all pluggable databases hosted by the same container database using a single instance of EM Express
  B. You can create and configure pluggable databases by using EM Express
  C. You can use a single instance of EM Express to manage multiple databases running on the same server
  D. You cannot start up or shut down a database instance by using EM Express
  E. By default, EM Express is available for a database after database creation using DBCA
  C. You can use a single instance of EM Express to manage multiple databases running on the same server
  D. You cannot start up or shut down a database instance by using EM Express

• Question 257:

  Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.

  Which two actions would you take to solve this problem?

  A. Enable temporary undo for the database.
  B. Enable undo retention guarantee.
  C. Increase the size of the redo log buffer.
  D. Enable Automatic Memory Management (AMM).
  E. Increase the size of the temporary tablespace.
  A. Enable temporary undo for the database.
  E. Increase the size of the temporary tablespace.

  ---

  Reference:http://docs.oracle.com/database/121/ADMIN/undo.htm#CEGJGIAE

• Question 258:

  You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

  $ . oraenv ORACLE_SID = [oracle] ? cdb1 The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle $ rman target /

  Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013

  Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.

  Connected to target database:CDB1 (DBID=782249327)

  RMAN>SELECT name FROMv$tablespace;

  Which statement is true about the execution of the last command?

  A. It succeeds and displays all the tablespaces that belong to the root database.
  B. It fails and returns an error because a connection is not made by using the sysdba privilege.
  C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
  D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
  C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

• Question 259:

  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.
  A. An unplugged PDB can be plugged into the same or another container database (CDB).
  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.

• Question 260:

  Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file?

  A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
  B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
  C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
  D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
  C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

  ---

  Reference: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841