Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 81:

  In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

  

  Which two statements are true? (Choose two.)

  A. The C # # ROLE1 role is created in the root database and all the PDBs.
  B. The C # # ROLE1 role is created only in the root database because the container clause is not used.
  C. Privileges are granted to the C##A_ADMIN user only in the root database.
  D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
  E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
  A. The C # # ROLE1 role is created in the root database and all the PDBs.
  C. Privileges are granted to the C##A_ADMIN user only in the root database.

  ---

  * You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.

  * * CREATE ROLE with CONTAINER (optional) clause

  / CONTAINER = ALL

  Creates a common role.

  / CONTAINER = CURRENT

  Creates a local role in the current PDB.

• Question 82:

  Which Oracle Database component is audited by default if the unified Auditing option is enabled?

  A. Oracle Data Pump
  B. Oracle Recovery Manager (RMAN)
  C. Oracle Label Security
  D. Oracle Database Vault
  E. Oracle Real Application Security
  B. Oracle Recovery Manager (RMAN)

• Question 83:

  You notice that the elapsed time for an important database scheduler Job is unacceptably long.

  The job belongs to a scheduler job class and window.

  Which two actions would reduce the job's elapsed time? (Choose two.)

  A. Increasing the priority of the job class to which the job belongs
  B. Increasing the job's relative priority within the Job class to which it belongs
  C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
  D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
  E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
  F. Increasing the priority of the scheduler window to which the job belongs
  B. Increasing the job's relative priority within the Job class to which it belongs
  C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

  ---

  B: Job priorities are used only to prioritize among jobs in the same class.

  Note: Group jobs for prioritization Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.

  C: Set resource allocation for member jobs Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.

• Question 84:

  Which three are true about the Oracle Job Scheduler and its components? (Choose three.)

  A. A newly created job is disabled by default.
  B. A schedule can only be used in the definition of a single job.
  C. A job can run without being part of a window or schedule.
  D. A program can be invoked by multiple jobs.
  E. The CREATE ANY JOB privilege permits a user to create a job in any schema including SYS.
  F. A job can run only when a scheduler window is open.
  A. A newly created job is disabled by default.
  D. A program can be invoked by multiple jobs.
  E. The CREATE ANY JOB privilege permits a user to create a job in any schema including SYS.

  ---

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12470

• Question 85:

  What should you do for a Scheduler to start a job when a file arrives on a remote system?

  A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.
  B. Install the Scheduler agent on the remote system and register the agent with the database on the local system.
  C. Ensure dedicated server is enabled on both the local and remote databases.
  D. Shutdown the file watcher on the local system.
  A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.

  ---

  Reference https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN034

• Question 86:

  Which two statements are true about resumable space allocation? (Choose two.)

  A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.
  B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.
  C. A resumable statement can be suspended and resumed only once during a session.
  D. Resumable space allocation does not apply when a database instance uses asynchronous commit.
  E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
  F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.
  A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.
  B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

• Question 87:

  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.)

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

  ---

  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.

• Question 88:

  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? (Choose two.)

  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
  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. Setting the target tablespace offline
  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
  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 value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

• Question 89:

  Which three statements are true about Oracle Restart? (Choose three.)

  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.
  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
  D. It can be used to only start Oracle components.
  E. It runs periodic check operations to monitor the health of Oracle components.

• Question 90:

  Which three statements are true about SQL plan directives? (Choose three.)

  A. They are tied to a specific statement or SQL ID.
  B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
  C. They are used to gather only missing statistics.
  D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
  E. They instruct the optimizer to create only column group statistics.
  F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
  B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
  D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
  F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.