Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 171:

  Examine the following set of RMAN commands:

  RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN { ALLOCATE CHANNEL ch1 DEVICE TYPE DISK; EXECUTE SCRIPT arc_backup; }

  Which statement is true about the RMAN RUN block execution?

  A. The script is executed and both DC1 and CH1 channels are used for script execution.
  B. The execution of the script fails because multiple channels cannot exist simultaneously.
  C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
  D. The new channel, CH1, is ignored because a channel has been configured already.
  C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

  ---

  Reference: https://docs.oracle.com/cd/B12037_01/server.101/b10770/rcmsynta4.htm

• Question 172:

  Examine the query and its output executed in an RDBMS instance:

  

  Which three statements are true about the users (other than SYS) in the output? (Choose three.)

  A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)
  B. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker
  C. The C##A_ADMIN user can perform wallet operations
  D. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus
  E. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only
  A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)
  B. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker
  D. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus

• Question 173:

  Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

  A. assigned to a class with rights to browse all directories and catalogs
  B. assigned to a class with rights to back up or restore Oracle database
  C. OSB encryption for data in transport and on tape
  D. RMAN preauthorization on the host
  E. matching the OS user identity of the Oracle instance associated with the database username
  F. scheduling of the RMAN backup to occur automatically at user-defined intervals
  B. assigned to a class with rights to back up or restore Oracle database
  D. RMAN preauthorization on the host
  E. matching the OS user identity of the Oracle instance associated with the database username

• Question 174:

  Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT

  state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database.

  Examine the possible steps involved in the recovery process:

  1.

  Mount the database

  2.

  Take the data file offline

  3.

  Bring the tablespace online

  4.

  Use the RMAN SWITCH command to switch to the image copy

  5.

  Recover the tablespace

  6.

  Open the database

  7.

  Use the RMAN RESTORE command to switch to the image copy

  Identify the correct sequence of the required steps:

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

• Question 175:

  Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;

  Which two statements are true about the statistics level parameter?

  A. It is immediately set to all in the SPFILE and the CDB instance.
  B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
  C. It is immediately set to all only for cd3Sroot.
  D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
  E. It is set to all for all PDBs only in the SPFILE.
  A. It is immediately set to all in the SPFILE and the CDB instance.
  D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.

  ---

  When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only. Their system-wide state is not changed.

• Question 176:

  Examine the command:

  $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull

  Which statement is true about the execution of the command?

  A. It fails because the log file parameter is not specified.
  B. It fails because no absolute path is specified for the log file and dump file.
  C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
  D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.
  D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

  ---

  It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.

• Question 177:

  Which four tablespace types can be renamed? (Choose four.)

  A. the default permanent tablespace
  B. the SYSTEM tablespace
  C. a temporary tablespace
  D. a read-only tablespace
  E. an offline tablespace
  F. an undo tablespace
  A. the default permanent tablespace
  C. a temporary tablespace
  D. a read-only tablespace
  F. an undo tablespace

  ---

  Reference: http://www.dba-oracle.com/t_rename_tablespace_syntax.htm

• Question 178:

  You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

  CREATE TABLE orders_ext (order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION (`ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi WHERE o.orderjd = i.order_id and i.product_id = p.product_id;

  You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

  A. TYPE
  B. LOCATION
  C. PARALLEL
  D. DEFAULT DIRECTORY
  E. ORGANIZATION EXTERNAL
  C. PARALLEL

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

• Question 179:

  Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

  A. A window specifies a Resource Manager plan that is automatically activated when the windows opens.
  B. A window specifies a job class that will be activated when that window opens.
  C. A job class specifies a window that will be open when that job class becomes active.
  D. A window and the job class associated with a job controls resource allocation for that job.
  E. A window and the Resource Manager plan that is active when a job runs determine the job class for the job.
  A. A window specifies a Resource Manager plan that is automatically activated when the windows opens.
  D. A window and the job class associated with a job controls resource allocation for that job.

• Question 180:

  In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.

  Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

  A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
  B. Setting the target tablespace to read-only after the segments are moved
  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used
  D. Taking the target tablespace offline after the segments are moved
  E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
  B. Setting the target tablespace to read-only after the segments are moved
  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used

  ---

  The threshold for activating tiering policies is based on two parameters:

  TBS PERCENT USED

  TBS PERCENT FREE

  Both values can be controlled by the DBMS_ILM_ADMIN package.

  TBS PERCENT USED and TBS PERCENT FREE default to 85 and 25, respectively. Hence, whenever the source tablespace's usage percentage goes beyond 85 percent, any tiering policy specified on its objects will be executed and objects

  will be moved to the target tablespace until the source tablespace becomes at least 25 percent free. Note that it is possible to add a custom condition to tiering policies to enable movement of data based on conditions other than how full the

  tablespace is.

  In addition, the READ ONLY option must be explicitly specified for the target tablespace.