Oracle Database 23ai Administration Associate - 1Z0-182 Free Exam Questions

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

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

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

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

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

A. Any data files added to the tablespace must have a size of 5 gigabytes.

B. Free space is managed using freelists.

C. It must be smaller than the smallest BIGFILE tablespace.

D. It is a locally managed tablespace.

E. It uses the database default block size.

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

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

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

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

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

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

A. Execute DDL statements in the HR schema.

B. Revoke the CREATE SESSION privilege from other users.

C. Execute DML statements in the HR schema.

D. Log in to the database instance.

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

F. Revoke the CREATE SESSION privilege from user HR.

A. Creating a database.

B. Renaming data files.

C. Full database recovery.

D. Re-creating control files.

E. Enabling online redo log archiving.

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

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. COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

A. Online segment shrink.

B. Oracle Managed Files (OMF).

C. Automatic data file extension (AUTOEXTEND).

D. Server-generated tablespace space alerts.

E. Free space management with bitmaps.

A. It must be bigger than the largest SMALLFILE tablespace.

B. It will be a dictionary-managed tablespace by default.

C. AUTOEXTEND is possible for the datafile.

D. Additional data files may not be added.

E. It will always have a 32K blocksize.

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

A. A dedicated server process may be reused by a new session after the session using that process terminates.

B. Each dedicated server process has its own dispatcher process.

C. A dedicated server process communicates directly with a client or middle-tier process once the session is established.

D. The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.

E. A dedicated server process can be spawned by the listener when using local clients.

F. A dedicated server process can be spawned without a listener when using local clients.