Oracle 1Z1-182 Actual Free Exam Questions & Community Discussion

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: Jul 06, 2026

Question #1

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. The DBA can revoke only ADMIN OPTION from USR1.

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

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

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

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

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #2

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

A. Free space is managed using freelists.

B. It must be smaller than the smallest BIGFILE tablespace.

C. Any data files added to the tablespace must have a size of 5 gigabytes.

D. It uses the database default block size.

E. It is a locally managed tablespace.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #3

Which three functions are performed by dispatchers in a shared server configuration?

A. Receiving inbound requests from processes using shared server connections.

B. Checking for outbound shared server responses on the common outbound response queue.

C. True. Dispatchers monitor the response queue.

D. Sending shared server session responses back to requesters on the appropriate connection.

E. Broadcasting shared server session responses back to requesters on all connections.

F. Sending each connection input request to the appropriate shared server input queue.

G. Writing inbound requests to the common request queue from all shared server connections.

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question #4

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

What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?

A. Creates a new PDB by plugging in a previously unplugged Non-CDB.

B. Creates a new PDB with the original SID of the Non-CDB.

C. Enables the creation of a Non-CDB from a CDB.

D. Simplifies the process of migrating Non-CDB databases to the cloud.

Discussion 0

Correct Answer: D Vote an answer

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

Question #6

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

A. Instance recovery occurs automatically during the shutdown.

B. Uncommitted transactions are allowed to continue to the next ROLLBACK.

C. New connection requests made to the database instance are refused.

D. Uncommitted transactions are allowed to continue to the next COMMIT.

E. Sessions remain connected even if they are not running a transaction.

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question #7

In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.abc.com)(PORT = 1521)). Which statement is true?

A. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.

B. Dynamic service registration cannot be used for this database instance.

C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.

D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.

E. The LREG process registers services dynamically with the LISTENER_1 listener.

Discussion 0

Correct Answer: E Vote an answer

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

Question #8

Which two statements are true about trace files produced by the Oracle Database server?

A. They can be written by server processes to a file system.

B. All trace files contain error information that requires contacting Oracle Support.

C. Trace file names are based on the database name concatenated with a sequential number.

D. They can be written by background processes to a file system.

E. They can be written by server processes to the Fast Recovery Area (FRA).

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #9

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

Which two statements describe how Optimizer Statistics are collected?

A. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

B. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

C. Optimizer Statistics are collected by the Statistics Advisor.

D. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

E. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump 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.