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

A. Trace file names are based on the database name concatenated with a sequential number.

B. All trace files contain error information that requires contacting Oracle Support.

C. They can be written by server processes to a file system.

D. They can be written by background processes to a file system.

E. They can be written by server processes to the Fast Recovery Area (FRA).

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. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

B. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.

C. Only viewed audit records can be purged from Unified Audits.

D. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.

E. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

F. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.

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.

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. You cannot drop a source PDB of a refreshable PDB.

B. You can drop an application root along with the associated PDBs.

C. When the relocation of a PDB is finished, the source PDB must be dropped.

D. You can drop a PDB as long as it is not the PDB seed.

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. It provides management for Oracle-engineered systems.

B. It is integrated with My Oracle Support.

C. It provides management for Oracle middleware.

D. It is available to manage a database only when that database is open.

E. It uses a web-based console built into the Oracle database using XML DB.

A. In the SPFILE and memory

B. In the SPFILE, PFILE, and memory

C. Only in memory

D. Only in the SPFILE

E. In the SPFILE and PFILE

A. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

B. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

C. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

D. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.