Oracle Database 23ai Administration Associate - 1Z1-182 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. A dedicated server process can be spawned without a listener when using local clients. B. A dedicated server process can be spawned by the listener when using local clients. C. The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process. D. Each dedicated server process has its own dispatcher process. E. A dedicated server process may be reused by a new session after the session using that process terminates. F. A dedicated server process communicates directly with a client or middle-tier process once the session is established.

A. To protect against data corruption. B. To alert DBAs about system issues. C. To monitor proper usage of the system and data by privileged users. D. To monitor suspicious activity. E. To protect against data theft by a non-authorized user.

A. The DBA can revoke only ADMIN OPTION from USR1. B. USR1 can revoke the CREATE VIEW privilege from USR3. C. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3. D. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3. E. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

A. Roles must be password protected. B. The SET ROLE statement can enable one or more roles for a session. C. All roles granted to a user are set on default when the user logs in. D. Roles may be granted to other roles. E. Object privileges may not be granted to roles. F. The SET ROLE statement can disable one or more roles for a session.

A. Simplifies the process of migrating Non-CDB databases to the cloud. B. Enables the creation of a Non-CDB from a CDB. C. Creates a new PDB with the original SID of the Non-CDB. D. Creates a new PDB by plugging in a previously unplugged Non-CDB.

A. Optimizer Statistics are statistics about data distribution within Oracle Datafiles. B. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans. C. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans. D. 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.

A. A segment might have only one extent. B. All tablespaces may have one or more data files. C. A segment can span multiple data files in some tablespaces. D. A segment's blocks can be of different sizes. E. A segment's blocks can be of different sizes. F. Segments can span multiple tablespaces.

A. It is unnecessary if the PDB is in the process of being upgraded. B. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart. C. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart. D. It should be used whenever PDB1 open mode needs to be changed.

A. A user's session may be suspended and resumed multiple times. B. All sessions must have the same timeout value when waiting for resumable space allocations. C. Resumable space allocation is only possible with locally managed tablespaces. D. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege. E. Resumable space allocation may be enabled for some sessions and not others. F. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

A. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job. B. Only viewed audit records can be purged from Unified Audits. C. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy. D. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy. E. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records. F. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.