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

What memory structure caches the data dictionary providing access to all database user processes?

A. The Large Pool

B. The Java Pool

C. The Streams Pool

D. The Shared Pool

Discussion 0

Correct Answer: D Vote an answer

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

Question #12

Which two statements are true about Fine-Grained Auditing (FGA)?

A. FGA policies by default can be created by a schema owner on an object in their schema.

B. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

C. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

D. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

E. FGA policies can only be created by a user with SYSDBA privilege.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #13

Which statement is true about database links?

A. A public database link can be used by any user allowing remote database instance connection for selecting schema data.

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

C. A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.

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

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

Discussion 0

Correct Answer: C Vote an answer

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

Question #14

Which three statements are true about UNDO and REDO?

A. UNDO is used for some flashback operations.

B. Both REDO and UNDO can be multiplexed.

C. UNDO is used for read consistency.

D. REDO is used for ROLLBACK.

E. REDO is used for instance recovery.

F. REDO is used for read consistency.

Discussion 0

Correct Answer: A,C,E Vote an answer

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

Question #15

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

A. Source Routing requires the use of encrypted connections.

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

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

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

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

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #16

As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?

A. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

B. USR1 can revoke the CREATE VIEW privilege from USR3.

C. The DBA can revoke only ADMIN OPTION from USR1.

D. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.

E. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #17

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?

A. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

B. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

C. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

D. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

Discussion 0

Correct Answer: D Vote an answer

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

Question #18

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

What are Optimizer Statistics?

A. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.

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 statistics about data distribution within Oracle Datafiles.

Discussion 0

Correct Answer: B Vote an answer

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

Question #20

Which three actions are ways to apply the principle of least privilege?

A. Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).

B. Using Access Control Lists (ACLs).

C. Setting the REMOTE_OS_AUTHENT parameter to TRUE.

D. Enabling Unified Auditing.

E. Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

Discussion 0

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