Skip to content Oracle
1Z0-182
120 Minutes
94
Oracle Database 23ai Administration Associate
A: By querying V$OPTION for parameter Unified Auditing.
B: By using the LSINVENTORY Command to query the Oracle Database Software Library.
C: By querying the DBA_UNIFIED_AUDIT_OPTION view.
D: By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
A: COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.
B: At the CDB level.
C: At the Application Root level of an Application Container.
D: At any level by using the COMMON option in the policy.
E: At the PDB level if the policy is created by a COMMON user.
A: Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.
B: Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.
C: Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.
D: Optimizer Statistics are collected by the Statistics Advisor.
E: Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.
A: Operating System authentication may be used for system-privileged administrative users.
B: Password authentication must be used for system-privileged administrative users.
C: Password File authentication is supported for any type of database user.
D: REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.
E: Password File authentication must be used for system-privileged administrative users.
A: The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
B: The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
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 DISABLED.
