1z0-062

1z0-062 practice questions, page 3 of 16, with answer review and explanations.

Question 11

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

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

Question 12

The HR user receives the following error while inserting data into the sales table: On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it. Which two methods would you use to resolve this error? (Choose two.)

  1. Altering the data file associated with the USERS tablespace to extend automatically
  2. Adding a data file to the USERS tablespace
  3. Changing segment space management for the USERS tablespace to manual
  4. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
  5. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

Question 13

Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

  1. the optimizer_mode initialization parameter
  2. operating system (OS) statistics
  3. cardinality estimates
  4. object statistics in the data dictionary
  5. fixed baselines

Question 14

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true? (Choose two.)

  1. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
  2. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
  3. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
  4. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
  5. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Question 15

Which action takes place when a file checkpoint occurs?

  1. The checkpoint position is advanced in the checkpoint queue.
  2. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
  3. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
  4. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.