[Apr-2026] Verified Oracle Exam Dumps with 1Z0-182 Exam Study Guide [Q38-Q58]

Rate this post

[Apr-2026] Verified Oracle Exam Dumps with 1Z0-182 Exam Study Guide

Best Quality Oracle 1Z0-182 Exam Questions PrepAwayExam Realistic Practice Exams [2026]

Oracle 1Z0-182 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe Managing Database Instances: This section tests the knowledge of Database Administrators in performing essential tasks for managing database instances. It includes starting and shutting down databases, utilizing dynamic performance views, managing initialization parameter files, and using the Automatic Diagnostic Repository (ADR) for troubleshooting.
Topic 2	Managing Undo: This domain measures the skills of Database Administrators in using undo data effectively. It compares undo data with redo data and explains temporary undo usage for efficient transaction management.
Topic 3	Describe Oracle Database Architecture: This section of the exam measures the skills of Database Administrators and System Architects in understanding the Oracle database architecture. It covers the configurations of Oracle database instances, memory structures like SGA and PGA, and process structures such as background processes. It also explains the logical and physical database structures, including datafiles, control files, and redo log files.
Topic 4	Managing Storage: This section tests the knowledge of Storage Engineers in managing storage features such as resumable space allocation, segment space-saving, and block space management. It also includes defining segment characteristics to optimize storage utilization.
Topic 5	Displaying Creating and Managing PDBs: This section assesses the knowledge of Cloud Database Architects in creating pluggable databases (PDBs) from seeds or other techniques. It also covers modifying PDB modes and attributes to meet specific application requirements.
Topic 6	Managing Users, Roles, and Privileges: This domain evaluates the expertise of Security Administrators in implementing user security measures. It focuses on creating and managing users, roles, and privileges to ensure secure access to Oracle databases.

NO.38 You start your database instance in NOMOUNT state. Which two actions are performed?

All required background processes are started.

The consistency of the database is checked.

The control files are opened.

Memory is allocated for the SGA.

SYS can access the database.

NO.39 You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE ‘/u02/oracle/data/nstbs_f01.dbf’ SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

The operating system must use a 32K block size.

DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

The /u02 file system must have at least 100G space for the datafile.

NO.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?

PDB1 must be taken offline before the cloning process begins.

Both CDBs need to be in local undo mode.

PDB1 must be in read-only mode.

TESTPDB must be in read-only mode after the cloning process is complete.

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

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

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

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

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

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

NO.42 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?

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

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

It appends data from EMP.DAT to EMP.

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

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

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

Automatic data file extension (AUTOEXTEND).

Free space management with bitmaps.

Oracle Managed Files (OMF).

Server-generated tablespace space alerts.

Online segment shrink.

NO.44 Which four statements are true about the Oracle Server architecture?

A person or program can have more than one session with an instance by logging in with different users.

The buffer cache and the redo log buffer are held in the large pool.

A session represents the state of a user’s login to an instance.

Each server process or background process has their own Program Global Area (PGA).

A connection represents the state of a user’s login to an instance.

A person or program can have more than one session with an instance by logging in with the same user.

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

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

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

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

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

NO.46 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?

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

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

The LREG process registers services dynamically with the LISTENER_1 listener.

Dynamic service registration cannot be used for this database instance.

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

Dynamic service registration allows a database to automatically register its services with a listener without manual configuration in LISTENER.ORA. Let’s analyze each option:
A . The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.
False. The CONNECT_DATA section is part of a client-side TNSNAMES.ORA entry for connecting to a service, not for listener registration. Dynamic registration is handled by the database’s LREG (Listener Registration) process, which uses the LOCAL_LISTENER parameter to locate the listener’s address (e.g., host1.abc.com:1521). No CONNECT_DATA is needed in the listener address definition itself. This option confuses client connection syntax with listener configuration.
Mechanics:The listener address in TNSNAMES.ORA (LISTENER_1) is sufficient for LREG to find and register with it, as long as the listener is running at that address.
B . LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.
False. Dynamic registration doesn’t require the listener to be explicitly defined in LISTENER.ORA. The LOCAL_LISTENER parameter pointing to LISTENER_1 (resolved via TNSNAMES.ORA) tells LREG where to register services. If the listener is running on host1.abc.com:1521, LREG will find it without a LISTENER.ORA entry. However, LISTENER.ORA is needed tostartthe listener process, but that’s separate from dynamic registration.
Practical Note:If LISTENER.ORA isn’t configured, a default listener might run on port 1521, but the question implies LISTENER_1 is operational.
C . The LREG process registers services dynamically with the LISTENER_1 listener.
True. In Oracle 23ai, the LREG background process (replacing PMON’s registration role in earlier versions) dynamically registers database services with listeners specified by LOCAL_LISTENER. Here, LOCAL_LISTENER=LISTENER_1 resolves to host1.abc.com:1521 via TNSNAMES.ORA. LREG periodically sends service information (e.g., service names, instance details) to the listener, enabling clients to connect without static configuration.
Mechanics:LREG uses the TNS alias (LISTENER_1) to locate the listener’s IP and port, registers services like orcl or orclpdb, and updates the listener’s service table. This happens automatically every 60 seconds or on significant events (e.g., instance startup).
D . Dynamic service registration cannot be used for this database instance.
False. The setup (LOCAL_LISTENER set and a valid TNSNAMES.ORA entry) explicitly supports dynamic registration. No blockers (e.g., REGISTRATION_EXCLUDED_LISTENERS) are mentioned, so LREG can function normally.
E . There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.
False. The question mentions only LISTENER_1 in the SPFILE and TNSNAMES.ORA. There’s no evidence of a second listener (LISTENER) or a LISTENERS configuration (possibly a typo). Two listeners can’t share the same port (1521) on the same host due to port conflicts unless explicitly configured with different IPs, which isn’t indicated here.

NO.47 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?

Free space is managed using freelists.

It uses the database default block size.

It must be smaller than the smallest BIGFILE tablespace.

It is a locally managed tablespace.

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

NO.48 Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

Undo segments can be stored in the SYSTEM tablespace.

A single transaction may use multiple undo segments simultaneously.

Undo segments can be stored in the SYSAUX tablespace.

Undo segments can extend when a transaction fills the last extent of the undo segment.

Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

NO.49 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?

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

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

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

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

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

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

NO.50 Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?

The Automatic SQL Access Advisor task, which is used to manage an application SQL load.

The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.

The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.

The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.

The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.

NO.51 Which three statements are true about roles?

Roles must be password protected.

Roles may be granted to other roles.

The SET ROLE statement can enable one or more roles for a session.

Object privileges may not be granted to roles.

All roles granted to a user are set on default when the user logs in.

The SET ROLE statement can disable one or more roles for a session.

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

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

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

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

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

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

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

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

The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

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

The Large Pool

The Java Pool

The Streams Pool

The Shared Pool

NO.55 Examine this command: ALTER DATABASE MOVE DATAFILE ‘u01/sales1.dbf’ TO ‘u01/sales01.dbf’ REUSE; Which two statements are true?

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

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

The file is renamed and stored in the same location.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

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

Instance recovery occurs automatically during the shutdown.

Uncommitted transactions are allowed to continue to the next ROLLBACK.

New connection requests made to the database instance are refused.

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

Uncommitted transactions are allowed to continue to the next COMMIT.

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

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

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

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

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

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

NO.58 You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?

READ WRITE

RESTRICTED READ ONLY

READ ONLY

RESTRICTED WRITE ONLY