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

Which two are benefits of external tables?

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

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

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

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

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

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #22

Which two account management capabilities can be configured using Oracle profiles?

A. The ability to prevent a password from ever being reused.

B. The number of days for which an account may be logged in to one or more sessions before it is locked.

C. The maximum number of sessions permitted for a user before the password must be changed.

D. The number of days for which an account may be inactive before it is locked.

E. The maximum amount of CPU time allowed for a user's sessions before their account is locked.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #23

Which three statements are true about using SQL*Plus?

A. It can run scripts entered at the SQL prompt.

B. It can run scripts passed to it by a shell script.

C. It has its own commands that are separate from any SQL statements.

D. It has both command-line and graphical user interfaces (GUI).

E. It must be downloaded from the Oracle Technology Network (OTN).

F. It can run Recovery Manager (RMAN) commands.

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #24

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

A. Enabling Unified Auditing.

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

C. Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

D. Setting the REMOTE_OS_AUTHENT parameter to TRUE.

E. Using Access Control Lists (ACLs).

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #25

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

A. It creates a new local user ADMIN with restricted privileges.

B. After the PDB is created, it is automatically opened Read/Write.

C. It creates new default schemas for the PDB.

D. The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

E. It creates a new local user ADMIN with SYSDBA privileges.

F. It creates tablespaces to store metadata.

Discussion 0

Correct Answer: A,C,F Vote an answer

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

Question #26

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

A. It reduces the amount of redo generated.

B. It permits DML on global temporary tables even if the database is opened read-only.

C. It reduces the amount of UNDO stored in the UNDO tablespace.

D. It reduces I/Os to the SYSAUX tablespace.

E. It reduces I/Os to the SYSTEM tablespace.

Discussion 0

Correct Answer: A,C,E Vote an answer

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

Question #27

Which two tasks can be performed in the NOMOUNT state?

A. Renaming data files.

B. Re-creating control files.

C. Full database recovery.

D. Enabling online redo log archiving.

E. Creating a database.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #28

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

A. It allows a user to have unlimited space only in their default permanent tablespace.

B. It allows a role to have unlimited space in any tablespace in the database.

C. By default, users have no quota on their default permanent tablespace.

D. It allows a user to have unlimited space in any tablespace in the database.

E. It is overridden by a space quota specified for the user.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #29

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace?

A. It will always have a 32K blocksize.

B. It will be a dictionary-managed tablespace by default.

C. Additional data files may not be added.

D. AUTOEXTEND is possible for the datafile.

E. It must be bigger than the largest SMALLFILE tablespace.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #30

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

A. Dependent indexes become UNUSABLE.

B. The high-water mark (HWM) of ORDERS is adjusted.

C. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

D. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

E. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

F. Only queries are allowed on ORDERS while SHRINK is executing.

Discussion 0

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