Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 131:

  You want to create a database and you have the following: Oracle Grid Infrastructure is installed and configured Oracle Database Vault is installed in ORACLE_HOME to be used for this database Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server

  Examine the requirements:

  1.

  Configuring the database instance to support shared server mode

  2.

  Using Automatic Storage Management (ASM) for storing database files

  3.

  Configuring a naming method to help a remote user connect to a database instance

  4.

  Configuring the Fast Recovery Area

  5.

  Configuring Database Vault

  6.

  Configuring Enterprise Manager (EM) Database Express

  7.

  Registering with EM Cloud Control

  8.

  Configuring remote log archive destinations

  9.

  Enabling daily incremental backups 10.Configuring a nondefault block size for nondefault block size tablespaces

  Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

  A. 1,2,3,4,5,6,8,9, and 10
  B. 1,2, 4,5,6,7, and 8
  C. 1, 2, 3, 8, 9, and 10
  D. 1, 2, 4, 5, 7, 8, 9, and 10
  E. 1, 2, 4, 5, 6, and 7
  E. 1, 2, 4, 5, 6, and 7

• Question 132:

  When is the UNDO_RETENTION parameter value ignored by a transaction?

  A. when the data file of the undo tablespace is autoextensible
  B. when there are multiple undotablespaces available in a database
  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
  D. when Flashback Database is enabled
  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  ---

  References:

  http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention, see the bullets)

• Question 133:

  Examine these parameter values:

  

  There are currently no user defined tablespaces with an 8K or 16K blocksize. Which statement would return an error?

  A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
  B. ALTER SYSTEM SET DB_16K_CACHE_SIZE=0;
  C. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
  D. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
  E. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
  D. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

• Question 134:

  Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

  A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
  B. The PDB is closed and requires media recovery at the PDB level.
  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
  D. The PDB does not close and starts by using the default temporary tablespace defined for the CD
  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

  ---

  If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs. ... The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.

• Question 135:

  Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.

  Identify two events that can occur at the time of a log switch. (Choose two.)

  A. All active transactions are rolled back and the database instance shuts down.
  B. The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.
  C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.
  D. An entry is written in the alert log and the database instance is automatically placed in MOUNT state.
  E. The log switch hangs until free space is available in the fast recovery area.
  C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.
  E. The log switch hangs until free space is available in the fast recovery area.

• Question 136:

  You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

  What is the outcome?

  A. The PDB is closed and left in the mount state.
  B. The PDB is closed and left in the unmount state.
  C. The command executes only if the common user is granted the set container privilege for the PDB.
  D. The command results in an error because the PDB can be shut down only by a local user.
  A. The PDB is closed and left in the mount state.

• Question 137:

  Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

  A. A job is specified as part of a program definition.
  B. A program can be used in the definition of multiple jobs.
  C. A program and job can be specified as part of a schedule definition.
  D. A program and schedule can be specified as part of a job definition.
  E. A program and window can be specified as part of a job definition.
  B. A program can be used in the definition of multiple jobs.
  D. A program and schedule can be specified as part of a job definition.
  E. A program and window can be specified as part of a job definition.

  ---

  References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

• Question 138:

  View the Exhibit showing steps to create a database resource manager plan.

  SQL>executedbms_resource_manager.create_pendingarea();

  PL/SQLproceduresuccessfully completed.

  3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>'OLTP,,comment=>,onlineuser')

  PL/SQLproceduresuccessfullycompleted.

  SQL>execdbras_resource_raanager.create_plan(plan=>'PRIU3ER3',comment=>'dssprio');

  SQL>exec

  Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comraent=>'onlinegrp'CPU_Pl=>60);

  PL/3QLproceduresuccessfullycompleted.

  After execting the steps in the exhibit you execute this procedure, which results in an error:

  SQL> EXECUTEdbms_resource_manager. validate_pending_area ();

  What is the reason for the error?

  A. The pending area is automatically submitted when creating plan directives.
  B. The procedure must be executed before creating any plan directive.
  C. The sys_group group is not included in the resource plan.
  D. The other_groups group is not included in the resource plan.
  E. Pending areas can not be validated until submitted.
  D. The other_groups group is not included in the resource plan.

  ---

  Reference: http://apunhiran.blogspot.com/2011/01/how-to-setup-resource-manager-to_14.html

• Question 139:

  Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):

  1.

  RMAN initiates backup and passes the database backup storage selector to OSB.

  2.

  RMAN creates the backup job.

  3.

  OSB creates the backup job with an OSB user.

  4.

  RMAN updates its repository.

  5.

  RMAN executes the job and transfers data from a client to media.

  6.

  OSB executes the job and transfers data from a client to media.

  7.

  OSB updates its repository.

  Identify the required steps in the correct order.

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

• Question 140:

  ENCRYPT_TS an encrypted tablespace that contains tables with data.

  Which statement is true about queries and data manipulation language statements on these tables?

  A. Queries may be performed on columns that have the NO SALT option.
  B. Data remains encrypted when read into the buffer cache.
  C. Redo generated by DML remains encrypted.
  D. UNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.
  E. Data remains encrypted when read into the PGA for direct path reads.
  C. Redo generated by DML remains encrypted.