oracle 1Z0-182 Exam Questions

Questions for the 1Z0-182 were updated on : Dec 01 ,2025

Page 1 out of 7. Viewing questions 1-15 out of 94

Question 1

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

  • A. Connect Time Failover requires the use of Transparent Application Failover (TAF).
  • B. Source Routing requires the use of encrypted connections.
  • C. Connect Time Failover requires the connect string to have two or more listener addresses configured.
  • D. Load Balancing requires the use of a name server.
  • E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.
Answer:

C,E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
A .False. Connect Time Failover doesn’t need TAF; TAF is for runtime failover.
B .False. Source Routing doesn’t mandate encryption.
C .True. Needs multiple addresses (e.g., (ADDRESS_LIST=...)) for failover.
D .False. Load balancing works with tnsnames.ora, no name server required.
E .True. Balances connections across shared server dispatchers.
Reference:Oracle Database Net Services Administrator’s Guide 23ai, "Advanced Connection
Options."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2

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 privileges that a user has on their own schema objects that they did not use.
  • B. Analysis of all privileges used by all users including administrative users in the database.
  • C. Analysis of all privileges used by all users but excluding administrative users in the database.
  • D. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
  • E. Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.
  • F. Analysis of privileges that a user has on their own schema objects that they did use.
Answer:

A,E,F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
A .True. Captures unused self-owned object privileges.
B .False. SYS is excluded from capture.
C .False. No exclusion option for admin users.
D .False. Direct role grants aren’t separately analyzed.
E .True. Tracks indirect role privileges used.
F .True. Identifies used self-owned privileges.
Reference:Oracle Database Security Guide 23ai, "DBMS_PRIVILEGE_CAPTURE."

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 3

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

  • A. Automatic data file extension (AUTOEXTEND).
  • B. Free space management with bitmaps.
  • C. Oracle Managed Files (OMF).
  • D. Server-generated tablespace space alerts.
  • E. Online segment shrink.
Answer:

B,E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
A .False. Works with DMTs too.
B .True. LMTs use bitmaps, unlike DMT freelists.
C .False. OMF is independent of management type.
D .False. Alerts work with both.
E .True. Shrink requires LMTs with ASSM.
Reference:Oracle Database Administrator’s Guide 23ai, "Locally Managed Tablespaces."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

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. Simplifies the process of migrating Non-CDB databases to the cloud.
  • C. Enables the creation of a Non-CDB from a CDB.
  • D. Creates a new PDB with the original SID of the Non-CDB.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
A .False. AWR doesn’t create PDBs.
B .True. AWR stats aid migration planning (e.g., performance baselines).
C .False. AWR doesn’t convert CDB to Non-CDB.
D .False. SID management isn’t AWR’s role.
Reference:Oracle Database Performance Tuning Guide 23ai, "AWR Services."

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

In one of your databases, the user HR has the password HRMGR. You want to connect to a database
instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No
name server is used. Which statement is true about ORCL?

  • A. It must be the name of the database to whose instance HR wishes to connect.
  • B. It must resolve to a valid connect descriptor in the client's tnsnames.ora file.
  • C. It must be the name of the server running the database to whose instance HR wishes to connect.
  • D. It must resolve to a valid connect descriptor in the server's tnsnames.ora file.
  • E. It must be the value of the SERVICE_NAMES parameter on the client side.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
A .False. ORCL is a TNS alias, not necessarily the DB name.
B .True. Must map to a connect descriptor (e.g., HOST=... PORT=1531) in tnsnames.ora.
C .False. It’s not the server name but a network alias.
D .False. Client-side tnsnames.ora is used, not server-side.
E .False. SERVICE_NAMES is server-side, not client-side.
Reference:Oracle Database Net Services Administrator’s Guide 23ai, "TNSNAMES.ORA."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

What are Optimizer Statistics?

  • A. 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.
  • B. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
  • C. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.
  • D. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
A .False. Not real-time; collected periodically.
B .False. Not about datafile distribution.
C .True. Includes table, column, index stats for plan generation.
D .False. Stored in data dictionary, not AWR.
Reference:Oracle Database SQL Tuning Guide 23ai, "Optimizer Statistics."

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

Which of the following statements is true about external tables?

  • A. They are read/write tables.
  • B. They describe how the external table layer presents data to the server.
  • C. They describe data stored in the database.
  • D. They describe how data is stored in the external source.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
A .False. External tables are read-only.
B .True. Defines how external data (e.g., CSV) is mapped to SQL.
C .False. Data is external, not in the DB.
D .False. Storage is external; Oracle doesn’t define it.
Reference:Oracle Database Administrator’s Guide 23ai, "External Tables."

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which four statements are true about the Oracle Server architecture?

  • A. A person or program can have more than one session with an instance by logging in with different users.
  • B. The buffer cache and the redo log buffer are held in the large pool.
  • C. A session represents the state of a user's login to an instance.
  • D. Each server process or background process has their own Program Global Area (PGA).
  • E. A connection represents the state of a user's login to an instance.
  • F. A person or program can have more than one session with an instance by logging in with the same user.
Answer:

A,C,D,F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
A .True. Multiple sessions with different users are possible.
B .False. Buffer cache and redo log buffer are in SGA, not large pool.
C .True. Session tracks login state.
D .True. Each process has its own PGA.
E .False. Connection is the network link; session is the state.
F .True. Same user can have multiple sessions (e.g., via different terminals).
Reference:Oracle Database Concepts 23ai, "Server Architecture."

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 9

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

  • A. It is held inside an Oracle database schema.
  • B. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.
  • C. It supports diagnostics for Automatic Storage Management (ASM).
  • D. It supports diagnostics for Oracle Clusterware.
  • E. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.
Answer:

C,D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
A .False. ADR is file-based, not in a schema.
B .False. No such default exists.
C .True. ADR logs ASM diagnostics.
D .True. Supports Clusterware diagnostics.
E .False. Defaults to $ORACLE_BASE or /u01/app/oracle if unset.
Reference:Oracle Database Administrator’s Guide 23ai, "ADR Overview."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 10

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

  • A. Sending shared server session responses back to requesters on the appropriate connection.
  • B. Writing inbound requests to the common request queue from all shared server connections.
  • C. Broadcasting shared server session responses back to requesters on all connections.
  • D. Receiving inbound requests from processes using shared server connections.
  • E. Sending each connection input request to the appropriate shared server input queue.
  • F. Checking for outbound shared server responses on the common outbound response queue.
Answer:

A,D,F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
A .True. Dispatchers return responses to clients.
B .False. Dispatchers manage queues, not write directly.
C .False. Responses are connection-specific, not broadcast.
D .True. Dispatchers receive client requests.
E .False. Queues are common, not per-connection.
F.True. Dispatchers monitor the response queue.
Reference:Oracle Database Concepts 23ai, "Shared Server Architecture."

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11

Which three statements are true about the tools used to configure Oracle Net Services?

  • A. Oracle Net Manager can be used to centrally configure listeners on any database server target.
  • B. The Oracle Net Configuration Assistant is only used when running the Oracle installer.
  • C. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
  • D. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
  • E. The lsnrctl utility requires a listener.ora file to exist before it is started.
  • F. Oracle Net Manager can be used to locally configure naming methods on a database server.
Answer:

C,D,F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
A .False. Net Manager is local, not centralized.
B .False. NetCA can run standalone.
C .True. EMCC manages service names centrally.
D .True. EMCC configures listeners on managed targets.
E .False. lsnrctl starts a default listener if no listener.ora exists.
F .True. Net Manager configures local tnsnames.ora.
Reference:Oracle Database Net Services Administrator’s Guide 23ai, "Net Services Tools."

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 12

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

  • A. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
  • B. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
  • C. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
  • D. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
A .True. After ALTER PLUGGABLE DATABASE ... UNPLUG, CDB_PDBS.STATUS shows UNPLUGGED.
B .False. UNAVAILABLE isn’t a valid status here.
C .False. REMOVED isn’t used; UNPLUGGED persists until dropped.
D .False. DISABLED isn’t a PDB state in this context.
Reference:Oracle Multitenant Administrator’s Guide 23ai, "Unplugging a PDB."

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

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

  • A. It is unnecessary if the PDB is in the process of being upgraded.
  • B. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
  • C. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.
  • D. It should be used whenever PDB1 open mode needs to be changed.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
A .False. DISCARD STATE isn’t tied to upgrades; it resets PDB startup behavior.
B .True. Discards saved state, reverting PDB1 to manual open mode (not auto-open) after CDB
restart.
C .False. Default is not auto-open; it’s manual unless explicitly saved as OPEN.
D .False. Used for state management, not general mode changes (e.g., OPEN READ WRITE).
Reference:Oracle Multitenant Administrator’s Guide 23ai, "Managing PDB State."

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

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

  • A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
  • B. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
  • C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
  • D. The file is renamed and stored in the same location.
  • E. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
Answer:

A,D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
This command moves/renames a data file online. Let’s evaluate:
A . DML may be performed on tables with one or more extents in this data file during the execution
of this command.
True. Introduced in 12c and refined in 23ai, MOVE DATAFILE is an online operation, allowing DML
(e.g., INSERT, UPDATE) on tables within the file. Oracle ensures consistency via redo and undo.
Mechanics:The file is copied to the new location/name while tracking changes, then switched
atomically.
Practical Use:Minimizes downtime in production systems.
B . If Oracle Managed Files (OMF) is used, then the file is renamed but moved to
DB_CREATE_FILE_DEST.
False. With OMF, omitting the TO clause would place the file in DB_CREATE_FILE_DEST, but here, TO
'\u01/sales01.dbf' explicitly specifies the target, overriding OMF defaults.
Mechanics:OMF only applies if the destination is unspecified (e.g., MOVE DATAFILE ... without TO).
Why Incorrect:Explicit path trumps OMF behavior.
C . The tablespace containing SALES1.DBF must be altered READ ONLY before executing the
command.
False. READ ONLY isn’t required; the operation is online and supports active use.
Why Incorrect:Conflicts with Oracle’s online move feature.
D . The file is renamed and stored in the same location.
True. The command renames /u01/sales1.dbf to /u01/sales01.dbf (correcting \u01 to /u01 as a
Windows/Unix typo), keeping it in /u01/. REUSE allows overwriting if sales01.dbf exists.
Mechanics:File is copied and renamed in-place within the same filesystem directory.
E . The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
False. Offline mode isn’t needed; the online move handles activetablespaces.
Reference:Oracle Database Administrator’s Guide 23ai, "Moving Data Files Online"; Oracle Database
SQL Language Reference 23ai, "ALTER DATABASE."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 15

Which statement is true about database links?

  • A. A public database link can be created only by SYS.
  • B. A database link can be created only between two Oracle databases.
  • C. 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.
  • D. 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.
  • E. Private database link creation requires the same user to exist in both the local and the remote databases.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
Database links enable cross-database queries in Oracle. Let’s analyze each option with extensive
detail:
A . A public database link can be created only by SYS.
False. Any user with the CREATE PUBLIC DATABASE LINK privilege (not just SYS) can create a public
link (e.g., CREATE PUBLIC DATABASE LINK remote_db CONNECT TO scott IDENTIFIED BY tiger USING
'orcl'). While SYS typically has this privilege, it’s not exclusive to SYS.
Mechanics:Privilege is granted via GRANT CREATE PUBLIC DATABASE LINK TO user;. Public links are
accessible to all users in the local DB.
Why Incorrect:Overly restrictive; Oracle’s security model allows delegation.
B . A database link can be created only between two Oracle databases.
False. Database links can connect to non-Oracle databases using Oracle Heterogeneous Services or
gateways (e.g., ODBC or JDBC drivers), such as linking to SQL Server. Example: CREATE DATABASE
LINK mssql_link USING 'hsodbc';.
Mechanics:Requires configuration of hs_ parameters in init.ora and a gateway listener.
Historical Note:Heterogeneous links were introduced in 8i, expanded in 23ai for cloud integration.
C . 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.
True. A database link is unidirectional; it enables queries from the local instance to the remote
instance (e.g., SELECT * FROM emp@remote_db), but the remote instance can’t use it to query back
unless a separate link is created there.
Mechanics:Stored in DBA_DB_LINKS, the link defines a one-way connection via a TNS alias or connect
string.
Practical Use:Ensures controlled access; bidirectional access requires explicit configuration.
Edge Case:Loops are prevented unless explicitly designed with mutual links.
D . 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.
False. Public links allow all local users to use them, but access to remote schemas depends on the
link’s credentials (e.g., CONNECT TO scott) and the user’s remote privileges. “Any schema”
overstates it; access is limited to what the link’s user can see.
Why Incorrect:Misrepresents privilege scope; remote schema access isn’t universal.
E . Private database link creation requires the same user to exist in both the local and the remote
databases.
False. A private link (e.g., CREATE DATABASE LINK my_linkCONNECT TO scott IDENTIFIED BY tiger
USING 'orcl') requires the remote user (scott) to exist, but the local creator (e.g., HR) need not match.
The link is owned locally and authenticated remotely.
Mechanics:Only the CREATE DATABASE LINK privilege is needed locally.
Reference:Oracle Database Administrator’s Guide 23ai, "Managing Database Links"; Oracle Database
SQL Language Reference 23ai, "CREATE DATABASE LINK."

Discussions
vote your answer:
A
B
C
D
E
0 / 1000
To page 2