Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 401:

  Examine the parameters for a database instance:

  

  Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.

  What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

  A. Transactions write their undo in the SYSTEM undo segment.
  B. Transactions fail.
  C. Transactions wait until space becomes available in UNDOTBS1.
  D. Transactions write their undo in a temporary tablespace.
  B. Transactions fail.

  ---

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

• Question 402:

  Which three statements are true about the purpose of checkpoints? (Choose three.)

  A. They ensure that uncommitted transactions are rolled back in case of an instance failure.
  B. They ensure that all the dirty buffers are written to disk during a normal shutdown.
  C. They ensure that instance recovery starts in the event of an instance failure.
  D. They ensure that dirty buffers in the buffer cache are written to disk regularly.
  E. They reduce the time required for recovery in case of an instance failure.
  B. They ensure that all the dirty buffers are written to disk during a normal shutdown.
  D. They ensure that dirty buffers in the buffer cache are written to disk regularly.
  E. They reduce the time required for recovery in case of an instance failure.

  ---

  References: http://docs.oracle.com/cd/E36909_01/server.1111/e25789/startup.htm#BABGDACG

• Question 403:

  Examine this command:

  

  Now examine these steps:

  1.

  Oracle instance is started.

  2.

  The control file is read.

  3.

  Instance recovery is started.

  4.

  Datafiles and redo log files are opened.

  5.

  The spfile or pfile is read.

  6.

  The database is available for use.

  7.

  The database is mounted.

  8.

  Instance recovery is completed.

  Identify the steps that were executed in the correct order to open the database:

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

• Question 404:

  An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.

  What do you recommend to minimize this?

  A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.
  B. Increase the size of the shared pool
  C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.
  D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.
  C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.

• Question 405:

  In one of your databases, unified auditing is enabled and an SH.SALES table exists. You can successfully execute these commands:

  

  Which statement is true about SALES_POL?

  A. Audit records are always stored in an external audit file.
  B. It is enabled for all users having SELECT privilege on SH.SALES.
  C. It is only enabled for SH.
  D. Only successful queries of SH.SALES are written to the audit trail.
  D. Only successful queries of SH.SALES are written to the audit trail.

• Question 406:

  You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

  You issue the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

  For which database users is the audit policy now active?

  A. All users except SYS
  B. All users except SCOTT
  C. All users except sys and SCOTT
  D. All users except sys, system, and SCOTT
  B. All users except SCOTT

  ---

  If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement.

  Note:

  *

  The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

  *

  You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan.

  Example Auditing All Actions on a Table

  CREATE AUDIT POLICY all_actions_on_hr_emp_pol

  ACTIONS ALL ON HR.EMPLOYEES;

  AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan;

• Question 407:

  Examine the command:

  

  Which statement is true?

  A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
  B. The tablespace, TEST1, can contain a maximum of one data file.
  C. Allocated and free extents are tracked using bitmaps.
  D. Segment free space is tracked in the data dictionary.
  C. Allocated and free extents are tracked using bitmaps.

• Question 408:

  Examine this parameter setting:

  

  Now examine these statements:

  

  Which three are true about the processing of these statements? (Choose three.)

  A. LGWR will only write redo generated by the INSERT statement to the redo log during execution of the COMMIT statement.
  B. Undo generated for the transaction will be in an unexpired state immediately after the commit.
  C. Only the 900 most recently generated undo statements will be in an unexpired state after the commit.
  D. DBWR might write the content of the modified EMP table block image to a data file before the COMMIT is executed.
  E. Only the 900 most recently generated undo statements are guaranteed to be retained.
  F. LGWR might write redo generated by the INSERT statement to the redo log before the COMMIT is executed.
  G. DBWR must write the content of the modified EMP table block image to a data file before the COMMIT executed.
  D. DBWR might write the content of the modified EMP table block image to a data file before the COMMIT is executed.
  E. Only the 900 most recently generated undo statements are guaranteed to be retained.
  G. DBWR must write the content of the modified EMP table block image to a data file before the COMMIT executed.

• Question 409:

  Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:

  SQL > CREATE UNDO TABLESPACE undotb01

  DATAFILE `u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;

  What is the result?

  A. It executes successfully and creates an UNDO tablespace in HR_PDB.
  B. It falls and reports an error because there can be only one undo tablespace in a CDB.
  C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
  D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
  E. It executes successfully but neither tablespace nor the data file is created.
  E. It executes successfully but neither tablespace nor the data file is created.

  ---

  Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace. When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

• Question 410:

  You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).

  The following are the possible steps to accomplish this task:

  1.

  Place all the user-defined tablespace in read-only mode on the source database.

  2.

  Upgrade the source database to a 12c version.

  3.

  Create a new PDB in the target container database.

  4.

  Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

  5.

  Copy the associated data files and export the dump file to the desired location in the target database.

  6.

  Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

  7.

  Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

  Identify the correct order of the required steps.

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

  ---

  1.

  Set user tablespaces in the source database to READ ONLY.

  2.

  From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:

  3.

  Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.

  4.

  Create a COB on the destination system, including a PDB into which you will import the source database.

  5.

  In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB Oracle White Paper - Upgrading to Oracle Database 12c -August 2013