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 14, 2026

Question #11

Which four statements are true about the Oracle Server architecture?

A. Each server process or background process has their own Program Global Area (PGA).

B. A connection represents the state of a user's login to an instance.

C. The buffer cache and the redo log buffer are held in the large pool.

D. A session represents the state of a user's login to an instance.

E. A person or program can have more than one session with an instance by logging in with the same user.

F. A person or program can have more than one session with an instance by logging in with different users.

Discussion 0

Correct Answer: A,D,E,F Vote an answer

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

Question #12

Which two statements are true about the configuration and use of UNDO?

A. Active UNDO is always retained.

B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

C. Unexpired UNDO is always retained.

D. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

E. UNDO_RETENTION specifies how long all types of UNDO are retained.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #13

Which two statements are true about database instances and Real Application Clusters (RAC)?

A. A RAC database must have two or more instances.

B. A RAC database can have instances on separate servers.

C. Two RAC databases can share their instances.

D. A RAC database can have one instance.

E. A RAC database must have three or more instances.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #14

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

A. Load Balancing requires the use of a name server.

B. Connect Time Failover requires the connect string to have two or more listener addresses configured.

C. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

D. Source Routing requires the use of encrypted connections.

E. Connect Time Failover requires the use of Transparent Application Failover (TAF).

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #15

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

A. The role has the privileges to perform DDL operations on all local schema objects.

B. The role has the privileges to administer the PDB.

C. The role has the privileges to create and manage users within the PDB.

D. No privileges are provided with the PDB_DBA role.

Discussion 0

Correct Answer: B Vote an answer

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

Question #16

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No name server is used. Which statement is true about ORCL?

A. It must be the value of the SERVICE_NAMES parameter on the client side.

B. It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

C. It must be the name of the database to whose instance HR wishes to connect.

D. It must be the name of the server running the database to whose instance HR wishes to connect.

E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file.

Discussion 0

Correct Answer: E Vote an answer

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

Question #17

Which of the following statements is true about external tables?

A. They are read/write tables.

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

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

D. They describe data stored in the database.

Discussion 0

Correct Answer: C Vote an answer

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

Question #18

You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE. Are you sure you wish to stop the job ([yes]/no): yes. Which two statements are true about the job?

A. You cannot monitor it.

B. It continues to run in the background.

C. It terminates.

D. You can reattach to it and monitor it.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #19

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

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

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

C. Change the character set.

D. Create an additional listener.

E. Create nonstandard block size tablespaces.

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #20

Which statement is true about database links?

A. Private database link creation requires the same user to exist in both the local and the remote databases.

B. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

C. A public database link can be created only by SYS.

D. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.

E. A database link can be created only between two Oracle databases.

Discussion 0

Correct Answer: 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.