1z0-182

1z0-182 practice questions, page 2 of 6, with answer review and explanations.

Question 6

Which three statements are true about resumable space allocation in Oracle databases? (Choose three.)

  1. All sessions must have the same timeout value when waiting for resumable space allocations.
  2. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
  3. Resumable space allocation is only possible with locally managed tablespaces.
  4. A user’s session may be suspended and resumed multiple times.
  5. A user’s session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
  6. Resumable space allocation may be enabled for some sessions and not others.

Question 7

Which two of these are part of the DBA’s database performance management activities? (Choose two.)

  1. Adjusting Oracle Database parameters and operating system (OS) parameters for efficient use of available resources
  2. Using Data Modeling to design efficient application schemas
  3. Application SQL development and testing
  4. Monitoring database activities to help locate bottlenecks
  5. Managing database software errors and instance failures

Question 8

Which three statements are true about dynamic performance views? (Choose three.)

  1. They are owned by the SYSTEM user.
  2. V$FIXED_TABLE can be queried to display the name of all dynamic performance views.
  3. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
  4. They can be queried only when the database is open.
  5. Read consistency is not guaranteed.
  6. Data displayed by querying dynamic performance views is derived from memory structures.

Question 9

Which three are benefits of using temp UNDO when performing DML on global temporary tables? (Choose three.)

  1. It reduces the amount of UNDO stored in the UNDO tablespace.
  2. It reduces the amount of redo generated.
  3. It permits DML on global temporary tables even if the database is opened read only.
  4. It reduces I/Os to the SYSTEM tablespace.
  5. It reduces I/Os to the SYSAUX tablespace.

Question 10

Which three activities are recorded in the database alert log? (Choose three.)

  1. Deadlock errors
  2. Block corruption errors
  3. Nondefault database parameters
  4. Session logins and logouts
  5. Data Definition Language (DDL) statements