Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 201:

  Which three statements are true about compression of backup sets?

  A. Compressed backups can only be written to media.
  B. Binary compression creates performance overhead during a backup operation.
  C. Unused blocks below the high-water mark are not backed up.
  D. Compressed backups cannot have section size defined during a backup operation
  E. It works only for locally managed tablespaces.
  B. Binary compression creates performance overhead during a backup operation.
  C. Unused blocks below the high-water mark are not backed up.
  E. It works only for locally managed tablespaces.

  ---

  "RMAN also skips other datafile blocks that do not currently contain data, if all of the following conditions apply: The COMPATIBLE initialization parameter is set to 10.2 There are currently no guaranteed restore points defined for the database The datafile is locally managed The datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backup The backup set is being created on disk. References: https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1015382

• Question 202:

  As part of a manual update process, you install Oracle Database 12c software, prepare a new ORACLE_HOME, you shut down an existing single-instance database that runs from that ORACLE_HOME.

  What should you do next to start the upgrade of this database?

  A. Start up the database instance by using the STARTUP UPGRADE command by using the server parameter file.
  B. Start up the database instance by using the new location of the server parameter file and run the catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.
  C. Start up the database instance by using the new location of the server parameter file and run the catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.
  D. Start up the database instance by using the new location of the server parameter file and run the catuppst.sql script to generate informational messages and log files during the upgrade.
  C. Start up the database instance by using the new location of the server parameter file and run the catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

• Question 203:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk

  RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

  RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';

  RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';

  RMAN> BACKUP DATABASE;

  Which statement is true about the backup set created by the BACKUP command?

  A. Two channels are allocated and two copies of the backup set are taken in parallel in both locations
  B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations
  C. The default channel is allocated and the backup set is created in only one destination
  D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2
  B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

• Question 204:

  While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.

  Which two actions would you take for tape streaming to happen during the backup?

  A. Configure backup optimization.
  B. Configure the channel to increase maxopenfiles.
  C. Configure a backup policy by using incremental backups.
  D. Configure the channel to increase capacity with the rate parameter.
  E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
  F. Configure large_pool, if not done already. Alternatively, you can increase the size of
  G. LARGE_POOL.
  B. Configure the channel to increase maxopenfiles.
  E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.

  ---

  Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform-dependent. You can change this value with the PARMS and BLKSIZE parameters of the ALLOCATE CHANNEL or CONFIGURE CHANNEL command. You can improve backup performance by adjusting the level of multiplexing, which is number of input files simultaneously read and then written into the same RMAN backup piece. The level of multiplexing is the minimum of the MAXOPENFILES setting on the channel and the number of input files placed in each backup set. The following table makes recommendations for adjusting the level of multiplexing. Reference: http://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV90072

• Question 205:

  Which three statements are true about Oracle Restart?

  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
  C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
  D. It can be used to only start Oracle components.
  E. It runs periodic check operations to monitor the health of Oracle components.
  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
  E. It runs periodic check operations to monitor the health of Oracle components.

  ---

  A is correct: Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software failure or whenever your database host computer restarts E is correct: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted. B is also true About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances. References: http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

• Question 206:

  You plan to migrate a production database to Real Application Clusters (RAC).

  You created a test RAC database by cloning the production database and plan to replay a workload, captured from the production database.

  Examine these steps:

  1) Preprocess the captured workload.

  2) Restart the database instance in RESTRICTED mode.

  3) Set up Replay Clients.

  4) Restore the test database to the point when the capture started on the production database.

  5) Remap connections.

  Which is the correct sequence of required steps?

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

• Question 207:

  Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.

  You create a common role c##role1 with the create table and select any table privileges.

  You then execute the commands:

  SQL> GRANTc##role1 TO##Madmin CONTAINER=ALL;

  SQL>CONNsys/oracle@HR_PDB as sysdba

  SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;

  Which two statements are true?

  A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
  B. B_admin can create and select any table in both the root container and Hr_pdb.
  C. c##admin can create and select any table in the root container and all the PDBs.
  D. B_admin can create and select any table only in hr_pdb.
  E. The grant c##role1 to b_admin command returns an error because container should be set to ALL.
  C. c##admin can create and select any table in the root container and all the PDBs.
  D. B_admin can create and select any table only in hr_pdb.

• Question 208:

  As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?

  A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
  B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
  C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
  D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
  D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

  ---

  Reference: http://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE

• Question 209:

  You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

  RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE sales FROM ACTIVE DATABASE PASSWORD FILE SPFILE NOFILENAMECHECK;

  Which two statements are true? (Choose two.)

  A. RMAN must be connected to a recovery catalog for the execution of the command.
  B. A backup of the SALES PDB must exist before the execution of the command.
  C. The root and seed databases are included in the duplication.
  D. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
  E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
  C. The root and seed databases are included in the duplication.
  E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

• Question 210:

  Examine the statements that use flashback technologies:

  1.

  FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM-DD HH:MI:SS');

  2.

  SELECT * FROM customers AS OF SCN 123456;

  3.

  FLASHBACK TABLE customers TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM-DD HH:MI:SS');

  5.

  SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

  6.

  ALTER TABLE customers FLASHBACK ARCHIVE;

  Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

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