1z0-182

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

Question 21

Which resource plan is used to manage the resources for the predefined maintenance window?

  1. The SYS_GROUP consumer resource group policies define the resources assigned to the predefined maintenance window and tasks.
  2. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLAN resource plan, and automated maintenance tasks run under its subplan called ORA$AUTOTASK.
  3. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager and then set it as the resource plan for the predefined maintenance window using the DBMS_AUTO_TASK_ADMIN PL/SQL package.
  4. The predefined maintenance window starts automatically with 20% of the system resources, and if more system resources become available, it could automatically increase up to 90% of the total system resources.

Question 22

What are the two main components of Oracle Database Proactive Maintenance?

  1. A set of PL/SQL packages that are used by the DBAs to communicate database errors with Oracle support
  2. A set of alerts that are used to monitor database operations and errors
  3. The notification system configured by the DBAs to receive database alerts
  4. A set of automated tasks the database performs for routine maintenance operations, which could include regular backups, refreshing optimizer statistics, and database health checks
  5. A repository to store the results of the snapshots of the database vital statistics that can be accessed and reviewed for database management.

Question 23

Which two listed schema object advisors are part of Automatic Maintenance Tasks? (Choose two.)

  1. Automatic Object Failure Analyzer, which collects detail logs on any object that generates database errors.
  2. Automatic Index Advisor, which is used to create and maintain table indexes based on the DML load and operations.
  3. Automatic Segment Advisor, which identifies segments that have space available for reclamation, and makes recommendations on how to defragment those segments.
  4. Automatic Storage Advisor, which identifies objects that require additional space that are not configured as Auto Extend.
  5. Optimizer Statistics Advisor, which analyzes how statistics are being gathered on schema objects and suggests changes that can be made to fine-tune the statistics collected.

Question 24

Which three statements are true about Private Temporary Tables (PTTs) in an Oracle Database? (Choose three.)

  1. Creating a PTT is DDL and commits any active transaction for the session.
  2. Concurrent sessions may have PTTs with the same name and the same column definitions.
  3. It is possible to preserve the private table definition but remove the rows when a session with a PTT issues a COMMIT.
  4. Concurrent sessions may have PTTs with different names but same column definitions.
  5. Concurrent sessions may have PTTs with the same name but different column definitions.

Question 25

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, if any, are created as a result of executing the command?

  1. no segments are created
  2. T1 and an index segment created for the primary key only
  3. T1 only
  4. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
  5. T1, an index segment for the primary key, and a LOB segment only