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

Which two are true about shrinking a segment online?

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

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

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

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

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

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #32

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

A. Automatic data file extension (AUTOEXTEND).

B. Server-generated tablespace space alerts.

C. Free space management with bitmaps.

D. Online segment shrink.

E. Oracle Managed Files (OMF).

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #33

Which two statements are true about User Authentication in an Oracle Database?

A. Password File authentication must be used for system-privileged administrative users.

B. Password File authentication is supported for any type of database user.

C. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

D. Operating System authentication may be used for system-privileged administrative users.

E. Password authentication must be used for system-privileged administrative users.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #34

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

A. Analysis of all privileges used by all users but excluding administrative users in the database.

B. Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.

C. Analysis of privileges that a user has on their own schema objects that they did not use.

D. Analysis of privileges that a user has on their own schema objects that they did use.

E. Analysis of all privileges used by all users including administrative users in the database.

F. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

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

What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;

A. It should be used whenever PDB1 open mode needs to be changed.

B. It is unnecessary if the PDB is in the process of being upgraded.

C. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

D. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.

Discussion 0

Correct Answer: D Vote an answer

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

Question #36

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

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

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

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

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

Discussion 0

Correct Answer: C Vote an answer

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

Question #37

Which two statements describe why Database Auditing is a security requirement?

A. To protect against data corruption.

B. To monitor suspicious activity.

C. To protect against data theft by a non-authorized user.

D. To monitor proper usage of the system and data by privileged users.

E. To alert DBAs about system issues.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #38

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

A. Insert statements can result in a migrated row.

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

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

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

E. 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.

Discussion 0

Correct Answer: B,D,E Vote an answer

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

Question #39

Which advisor is used to detect missing or stale object statistics?

A. SQL Performance Analyzer

B. SQL Tuning Advisor

C. SQL Statistics Advisor

D. SQL Access Advisor

Discussion 0

Correct Answer: C Vote an answer

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

Question #40

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. TESTPDB must be in read-only mode after the cloning process is complete.

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

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

Discussion 0

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