Free Oracle 1Z0-182 Practice Test & Real Exam Questions

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: Sep 08, 2026

Question #1

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

A. In the SPFILE and memory

B. Only in the SPFILE

C. In the SPFILE, PFILE, and memory

D. Only in memory

E. In the SPFILE and PFILE

Discussion 0

Correct Answer: A Vote an answer

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

Question #2

Which two Oracle database space management features require the use of locally managed tablespaces?

A. Automatic data file extension (AUTOEXTEND).

B. Online segment shrink.

C. Free space management with bitmaps.

D. Server-generated tablespace space alerts.

E. Oracle Managed Files (OMF).

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #3

Which of the following statements is true about external tables?

A. They are read/write tables.

B. They describe data stored in the database.

C. They describe how the external table layer presents data to the server.

D. They describe how data is stored in the external source.

Discussion 0

Correct Answer: C Vote an answer

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

Question #4

Which three statements are true about row chaining and row migration done by Oracle database block space management?

A. Row pieces of a chained row must always reside in different blocks.

B. Insert statements can result in a migrated row.

C. Update statements can result in one or more migrated rows.

D. A migrated row results in an update to any index on the table to point the row ID in the index to the row's new location.

E. Update statements can result in one or more chained rows.

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question #5

Which two statements are true about trace files produced by the Oracle Database server?

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

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

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

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

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

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #6

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 should be set to a value greater than DB_CACHE_SIZE.

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

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

E. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #7

Which two actions can you perform using DBCA for an existing database?

A. Create a template that can be used to clone the database.

B. Change the character set.

C. Create nonstandard block size tablespaces.

D. Create an additional listener.

E. Change the server mode from dedicated to shared, and vice versa.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #8

What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?

A. Creates a new PDB by plugging in a previously unplugged Non-CDB.

B. Simplifies the process of migrating Non-CDB databases to the cloud.

C. Creates a new PDB with the original SID of the Non-CDB.

D. Enables the creation of a Non-CDB from a CDB.

Discussion 0

Correct Answer: B Vote an answer

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

Question #9

Which two statements describe how Optimizer Statistics are collected?

A. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

B. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

C. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

D. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

E. Optimizer Statistics are collected by the Statistics Advisor.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #10

Which two statements are true about the DUAL table?

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

B. It can display multiple rows and columns.

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

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

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: C,D Vote an answer

Explanation: Only visible for Pass4Leader 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.