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

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

Exam Questions: 96
Updated On: Sep 12, 2026

Question #1

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

A. DBA_ALL_USER_EXTERNAL_TABLES

B. DBA_ALL_USER_TABLES

C. DBA_ALL_USER_EXTERNAL_LOCATIONS

D. DBA_ALL_USER_TAB_COLUMNS

Discussion 0

Correct Answer: C Vote an answer

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

Question #2

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of the following is a necessary prerequisite for the hot remote clone?

A. PDB1 must be in read-only mode.

B. PDB1 must be taken offline before the cloning process begins.

C. Both CDBs need to be in local undo mode.

D. TESTPDB must be in read-only mode after the cloning process is complete.

Discussion 0

Correct Answer: A Vote an answer

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

Question #3

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?

A. The PDB archive file must be copied to the target CDB.

B. The PDB manifest and all the datafiles must be copied to the target CDB.

C. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

D. PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

Discussion 0

Correct Answer: C Vote an answer

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

Question #4

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 #5

Which two are true about shrinking a segment online?

A. To shrink a table it must have a PRIMARY KEY constraint.

B. To shrink a table it must have a UNIQUE KEY constraint.

C. To shrink a table it must have row movement enabled.

D. It is not possible to shrink either indexes or Index Organized Tables (IOTs).

E. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #6

Which three statements are true about Oracle Managed Files (OMF)?

A. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

B. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

C. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

D. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

E. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

F. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

Discussion 0

Correct Answer: B,D,E Vote an answer

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

Question #7

Which two are benefits of external tables?

A. They support UPDATEs, which transparently updates records in the file system as if they were table rows.

B. They can be queried while the database is in the MOUNT state like dynamic performance views.

C. They support DELETEs, which transparently deletes records in the file system as if they were table rows.

D. They can be queried, transformed, and joined with other tables without having to load the data first.

E. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #8

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?

A. Control files are read.

B. Online data files are opened.

C. Oracle shared memory structures are allocated.

D. The alert log has instance startup details written to it.

E. Online redo logs are opened.

F. The initialization parameter file is read.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #9

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?

A. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

B. ALTER SYSTEM FLUSH BUFFER_CACHE

C. ALTER SYSTEM CHECKPOINT

D. ALTER SYSTEM SWITCH LOGFILE

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #10

Which three statements are true about resumable space allocation in Oracle databases?

A. All sessions must have the same timeout value when waiting for resumable space allocations.

B. Resumable space allocation is only possible with locally managed tablespaces.

C. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

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. A user's session may be suspended and resumed multiple times.

Discussion 0

Correct Answer: D,E,F Vote an answer

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

Download Free Oracle 1Z1-182 Demo

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