Oracle 1Z0-182 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-182
Exam Name/Title: Oracle Database 23ai Administration Associate
Certification Provider: Oracle
Corresponding Certification: Oracle Database 23ai

Exam Questions: 96
Updated On: Jul 08, 2026

Question #1

What are the three components of Oracle Database Automatic Maintenance Tasks?

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. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.

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

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

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

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

Which two statements are true about the tools used to configure Oracle Net Services?

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

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

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

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

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

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #3

Which two methods can be used to purge audit records of the Unified Audits?

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

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

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

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

Discussion 0

Correct Answer: E,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #4

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

A. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

B. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

C. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

D. The /u02 file system must have at least 100G space for the datafile.

E. The operating system must use a 32K block size.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #5

Which two statements are true about the DUAL table?

A. It can display multiple rows and columns.

B. It consists of a single row and single column of VARCHAR2 data type.

C. It can be accessed by any user who has the SELECT privilege in any schema.

D. It can be accessed only by the SYS user.

E. It can be used to display only constants or pseudo columns.

F. It can display multiple rows but only a single column.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #6

Which three statements are true about Automatic Diagnostic Repository (ADR)?

A. It is only used for Oracle database diagnostic information.

B. It is held inside an Oracle database schema.

C. It can be used for the problem diagnosis of a database when that database's instance is down.

D. The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

E. It is a file-based repository held outside any database.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #7

Which data dictionary view describes the data sources of external tables?

A. DBA_ALL_USER_EXTERNAL_TABLES

B. DBA_ALL_USER_EXTERNAL_LOCATIONS

C. DBA_ALL_USER_TABLES

D. DBA_ALL_USER_TAB_COLUMNS

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #8

Which three tasks are part of the predefined Automated Maintenance Tasks?

A. Automatic SQL Plan Management advisor tasks.

B. Automatic error and failure log collection tasks.

C. Automatic segment and segment statistics advisor tasks.

D. Automatic Backups of the database system files.

E. Automatic Optimizer Statistics Collection.

F. Automatic notification tasks.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #9

What are Optimizer Statistics?

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.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #10

Which two statements are true about views used for viewing tablespace and datafile information?

A. V$TABLESPACE displays information about tablespaces contained in the data dictionary.

B. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.

C. Tablespace free space can be viewed in DBA_TABLESPACES.

D. V$TABLESPACE displays information that is contained in the control file about tablespaces.

E. Tablespace free space can be viewed in V$TABLESPACE.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1Z0-182 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-182 exam.