1z0-062 practice test

1. Question 1 · 1

   Examine the parameters for your database instance: You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?

   Choose one answer.

   

   • Undo data is written to flashback logs after 1200 seconds.
   • Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
   • You can perform a Flashback Database operation only within the duration of 1200 seconds.
   • An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

2. Question 2 · 1

   Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

   Choose all answers that apply.

   • Thread creation must be routed through a dispatcher process
   • The local listener may spawn a now process and have that new process create a thread
   • Each Oracle process runs an SCMN thread.
   • Each multithreaded Oracle process has an SCMN thread.
   • The local listener may pass the request to an existing process which in turn will create a thread.

3. Question 3 · 1

   You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so?

   Choose one answer.

   

   • It succeeds because the PDB_ADMIN user has the required privileges.
   • It fails because common users are unable to use the SET CONTAINER statement.
   • It fails because local users are unable to use the SET CONTAINER statement.
   • If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

4. Question 4 · 1

   Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report: What are three possible causes for the latch-related wait events?

   Choose all answers that apply.

   

   • The size of the shared pool is too small.
   • Cursors are not being shared.
   • A large number COMMITS are being performed.
   • There are frequent logons and logoffs.
   • The buffers are being read into the buffer cache, but some other session is changing the buffers.

5. Question 5 · 1

   You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? Select two.

   Choose all answers that apply.

   • SYS, SYSTEM
   • SCOTT
   • Only for successful executions
   • Only for failed executions
   • Both successful and failed executions

   Read explanation

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

6. Question 6 · 1

   A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted? (Choose three.)

   Choose all answers that apply.

   

   • SYS sessions, regardless of the roles that are set in the session
   • SYSTEM sessions, regardless of the roles that are set in the session
   • SCOTT sessions, only if the MGR role is set in the session
   • SCOTT sessions, only if the MGR role is granted to SCOTT
   • SCOTT sessions, because he is the owner of the table
   • SYSTEM session, only if the MGR role is set in the session

7. Question 7 · 1

   What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

   Choose one answer.

   • It fails with the ORA-665610 Invalid DDL statement on history-tracked message
   • The rows in the table are truncated without being archived.
   • The rows in the table are archived, and then truncated.
   • The rows in both the table and the archive are truncated.

8. Question 8 · 1

   Which three statements are true about a job chain? (Choose three.)

   Choose all answers that apply.

   • It can contain a nested chain of jobs.
   • It can be used to implement dependency-based scheduling.
   • It cannot invoke the same program or nested chain in multiple steps in the chain.
   • It cannot have more than one dependency.
   • It can be executed using event-based or time-based schedules.

   Read explanation

   References:

9. Question 9 · 1

   You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

   Choose all answers that apply.

   

   • The valid time columns employee_time_start and employee_time_end are automatically created.
   • The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
   • The valid time columns are not populated by the Oracle Server automatically.
   • The valid time columns are visible by default when the table is described.
   • Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data

10. Question 10 · 1

    Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true? (Choose two.)

    Choose all answers that apply.

    

    • Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
    • The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
    • The command will, create a common user whose description is contained in the root and each PDB.
    • The schema for the common user C # # A_ADMIN can be different in each container.
    • The command will create a user in the root container only because the container clause is not used.

11. Question 11 · 1

    You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE /mydir/rman_change_track.f; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true? (Choose three.)

    Choose all answers that apply.

    • Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
    • The change tracking file must always be backed up when you perform a full database backup.
    • Block change tracking will always reduce I/O performed during cumulative incremental backups.
    • More than one database block may be read by an incremental backup for a change made to a single block.
    • The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed

12. Question 12 · 1

    You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?

    Choose one answer.

    

    • A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
    • All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
    • A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
    • A TOP-N query is created to limit the rows to 20 percent of the total rows

13. Question 13 · 1

    Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

    Choose all answers that apply.

    • Maximum Undo per consumer group
    • Maximum Idle time
    • Parallel server limit
    • CPU
    • Exadata I/O
    • Local file system I/O

14. Question 14 · 1

    You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?

    Choose one answer.

    

    • It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
    • It generates an error when creating the table because the wallet is closed.
    • It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
    • It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

15. Question 15 · 1

    On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)

    Choose all answers that apply.

    • Only the ORD_CUSTOMER_IX1 index created.
    • Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
    • Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
    • The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
    • Both the indexes are created and used by the optimizer for queries on the ORDERS table.
    • Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

    Read explanation

    Not A: Both indexes are created fine. B: The invisible index ORD_CUSTOMERS_IX1 and the bitmap index are both updated by DML operations on the Orders table. F: Since ORD_CUSTOMERS_IX1 is invisible only ORD_CUSTOMERS_IX2 is used by the query optimizer. Not C,Not D,Not E: * ord_customer_ix1 is an invisible index and is therefore not used by the optimizer. * VISIBLE | INVISIBLE Use this clause to specify whether the index is visible or invisible to the optimizer. An invisible index is maintained by DML operations, but it is not be used by the optimizer during queries unless you explicitly set the parameter OPTIMIZER_USE_INVISIBLE_INDEXES to TRUE at the session or system level. Note: Specify BITMAP to indicate that index is to be created with a bitmap for each distinct key, rather than indexing each row separately. Bitmap indexes store the rowids associated with a key value as a bitmap. Each bit in the bitmap corresponds to a possible rowid. If the bit is set, then it means that the row with the corresponding rowid contains the key value. The internal representation of bitmaps is best suited for applications with low levels of concurrent transactions, such as data warehousing.

Paid access to all 200 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.