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

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

Question #12

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

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

A. The Shared Pool

B. The Large Pool

C. The Java Pool

D. The Streams Pool

Discussion 0

Correct Answer: A 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 the tools used to configure Oracle Net Services?

A. Oracle Net Manager can be used to locally configure naming methods on a database server.

B. Oracle Net Manager can be used to centrally configure listeners on any database server target.

C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D. The lsnrctl utility requires a listener.ora file to exist before it is started.

E. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #15

Examine these commands:
[oracle@host01 ~]$ sqlplus u1/oracle
SQL> SELECT * FROM emp;
ENO ENAME DN
-------------------------
1 Alan 2
2 Ben 2
SQL> exit
[oracle@host01 ~]$ cat emp.dat
1, Alan, 2
3, Curl, 4
4, Bob, 4
[oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp
Which two statements are true?

A. It generates a SQL script that it uses to load data from EMP.DAT to EMP.

B. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.

C. It appends data from EMP.DAT to EMP.

D. It overwrites all data in EMP with data from EMP.DAT.

E. It overwrites the data for Alan and adds data for Curl and Bob.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #16

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

A. Tables with one or more extents in this data file may be queried during the execution of this command.

B. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

C. DML may be performed on tables with one or more extents in this data file during the execution of this command.

D. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

E. It overwrites any existing file with the name sales02.dbf in /u02 by default.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #17

Which three statements are true about dynamic performance views?

A. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

B. They are owned by the SYSTEM user.

C. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

D. Read consistency is not guaranteed.

E. They can be queried only when the database is open.

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question #18

Which two statements are true about the PMON background process?

A. It records checkpoint information in the control file.

B. It rolls back transactions when a process fails.

C. It frees unused temporary segments.

D. It registers database services with all local and remote listeners known to the database instance.

E. It frees resources held by abnormally terminated processes.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #19

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

You execute the SHUTDOWN ABORT command. Which two statements are true?

A. Subsequent instance startup performs instance recovery.

B. Data files are closed normally.

C. Uncommitted transactions are not rolled back by the shutdown.

D. A checkpoint is written.

E. Subsequent instance startup performs media recovery.

Discussion 0

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