Oracle Database 23ai Administration Associate - 1Z1-182무료 덤프문제 풀어보기

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

B. One instance on one server mounting multiple databases.

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

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

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

A. SQL Access Advisor

B. SQL Statistics Advisor

C. SQL Tuning Advisor

D. SQL Performance Analyzer

A. At any level by using the COMMON option in the policy.

B. At the PDB level if the policy is created by a COMMON user.

C. At the Application Root level of an Application Container.

D. COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

E. At the CDB level.

A. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

B. The lsnrctl utility requires a listener.ora file to exist before it is started.

C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

E. Oracle Net Manager can be used to locally configure naming methods on a database server.

F. Oracle Net Manager can be used to centrally configure listeners on any database server target.

A. It is supported for SYS-owned tables contained in locally managed tablespaces.

B. It is the default behavior for tables and indexes.

C. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

D. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

E. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

A. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

B. Oracle Database Metrics monitor performance using thresholds to generate alerts.

C. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

D. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

E. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

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

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

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

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

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

A. A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

B. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

C. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

D. A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

E. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.

F. A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

A. Revoke the CREATE SESSION privilege from other users.

B. Execute DDL statements in the HR schema.

C. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

D. Log in to the database instance.

E. Execute DML statements in the HR schema.

F. Revoke the CREATE SESSION privilege from user HR.

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

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

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

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