최신 1Z1-182 무료덤프 - Oracle Database 23ai Administration Associate

A. Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans.

B. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.

C. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.

D. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.

A. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

B. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

C. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

D. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

E. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

F. Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

A. The maximum number of sessions permitted for a user before the password must be changed.

B. The number of days for which an account may be logged in to one or more sessions before it is locked.

C. The maximum amount of CPU time allowed for a user's sessions before their account is locked.

D. The number of days for which an account may be inactive before it is locked.

E. The ability to prevent a password from ever being reused.

A. It reduces I/Os to the SYSTEM tablespace.

B. It reduces the amount of redo generated.

C. It reduces I/Os to the SYSAUX tablespace.

D. It reduces the amount of UNDO stored in the UNDO tablespace.

E. It permits DML on global temporary tables even if the database is opened read-only.

A. It must exist for a database instance to start.

B. It can be used to create a PFILE.

C. It contains only static initialization parameters.

D. It can be created by SYS from an idle instance.

E. It contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.

A. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

B. The SYS_GROUP consumer resource group policies define the resources assigned ...

C. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

D. The predefined maintenance window starts automatically with 20% of the system resources ...

A. Object privileges may not be granted to roles.

B. All roles granted to a user are set on default when the user logs in.

C. Roles may be granted to other roles.

D. The SET ROLE statement can enable one or more roles for a session.

E. Roles must be password protected.

F. The SET ROLE statement can disable one or more roles for a session.

A. Automatic data file extension (AUTOEXTEND).

B. Online segment shrink.

C. Free space management with bitmaps.

D. Oracle Managed Files (OMF).

E. Server-generated tablespace space alerts.

A. One instance on one server mounting and opening one database.

B. One instance on one server mounting multiple databases.

C. One instance on one server mounting and opening multiple databases.

D. One instance on one server that has no database mounted.

E. Two or more instances on separate servers all mounting and opening the same database.

A. Password File authentication must be used for system-privileged administrative users.

B. Password authentication must be used for system-privileged administrative users.

C. Operating System authentication may be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.