1Z1-182 Dumps Updated Dec 19, 2025 Practice Test and 96 unique questions
2025 Latest 100% Exam Passing Ratio - 1Z1-182 Dumps PDF
Oracle 1Z1-182 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 32
Which two statements are true about the configuration and use of UNDO?
- A. UNDO_RETENTION specifies how long all types of UNDO are retained.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- C. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
- D. Unexpired UNDO is always retained.
- E. Active UNDO is always retained.
Answer: B,E
NEW QUESTION # 33
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 resolve to a valid connect descriptor in the client's tnsnames.ora file.
- B. It must be the name of the database to whose instance HR wishes to connect.
- 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: A
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.
NEW QUESTION # 34
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?
- A. ALTER SYSTEM SWITCH LOGFILE
- B. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
- C. ALTER SYSTEM CHECKPOINT
- D. ALTER SYSTEM FLUSH BUFFER_CACHE
Answer: B,C
Explanation:
A .True. Local checkpoints are allowed in PDBs.
B .False. Buffer cache is CDB-level.
C .False. Log switching is CDB-level.
D .True. Restricted session can be toggled per PDB.
NEW QUESTION # 35
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 UNAVAILABLE.
- B. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
- C. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
- D. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
Answer: C
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.
NEW QUESTION # 36
What are Optimizer Statistics?
- A. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
- B. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
- C. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.
- D. 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.
Answer: C
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.
NEW QUESTION # 37
Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?
- A. By default, users have no quota on their default permanent tablespace.
- B. It is overridden by a space quota specified for the user.
- C. It allows a user to have unlimited space in any tablespace in the database.
- D. It allows a role to have unlimited space in any tablespace in the database.
- E. It allows a user to have unlimited space only in their default permanent tablespace.
Answer: B,C
Explanation:
A .True. Grants unlimited space across all tablespaces.
B .True. Explicit quotas override the privilege.
C .False. Not limited to default tablespace.
D .False. Roles can't have this privilege directly.
E .False. Default is zero quota unless specified.
NEW QUESTION # 38
Which statement is true about database links?
- A. A public database link can be used by any user allowing remote database instance connection for selecting schema data.
- 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 for selecting schema data.
- D. Private database link creation requires the same user to exist in both the local and the remote databases.
- E. A public database link can be created only by SYS.
Answer: C
Explanation:
A .False. Links can connect to non-Oracle DBs via gateways.
B .False. No such user requirement; authentication is separate.
C .False. Any user with CREATE PUBLIC DATABASE LINK can create one.
D .True. Links enable remote schema access (e.g., SELECT * FROM emp@remote).
E .False. Public links allow access, but privileges on remote objects are needed.
NEW QUESTION # 39
Which two statements are true about Fine-Grained Auditing (FGA)?
- A. FGA policies can only be created by a user with SYSDBA privilege.
- B. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.
- C. FGA policies can be created by a user having the AUDIT_ADMIN privilege.
- D. FGA policies by default can be created by a schema owner on an object in their schema.
- E. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.
Answer: B,C
Explanation:
A .False. Schema owners need EXECUTE on DBMS_FGA.
B .False. Not limited to SYSDBA.
C .True. AUDIT_ADMIN includes FGA creation rights.
D .False. No such role exists.
E .True. DBMS_FGA.ADD_POLICY requires this privilege.
NEW QUESTION # 40
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?
- A. RESTRICTED READ ONLY
- B. READ WRITE
- C. READ ONLY
- D. RESTRICTED WRITE ONLY
Answer: B
Explanation:
To change a PDB_MODIFIABLE parameter, the PDB must be in READ WRITE mode, allowing ALTER SYSTEM commands to modify parameters stored in the PDB's SPFILE or memory. READONLY modes prevent modifications, and no RESTRICTED WRITE ONLY mode exists.
NEW QUESTION # 41
Which two statements are true about trace files produced by the Oracle Database server?
- A. All trace files contain error information that requires contacting Oracle Support.
- B. They can be written by background processes to a file system.
- C. They can be written by server processes to a file system.
- D. They can be written by server processes to the Fast Recovery Area (FRA).
- E. Trace file names are based on the database name concatenated with a sequential number.
Answer: B,C
Explanation:
A .False. Not all trace files indicate errors; some log normal activity.
B .True. Server processes write traces (e.g., ora_s000_123.trc) to the file system.
C .True. Background processes (e.g., ora_lgwr_123.trc) also write traces.
D .False. Names include process type and PID, not just DB name and sequence.
E .False. Traces go to DIAGNOSTIC_DEST, not necessarily FRA unless configured there.
NEW QUESTION # 42
Which three tasks are performed by background processes in an Oracle database instance?
- A. Creating dedicated server connections.
- B. Writing redo to log files.
- C. Reading database blocks into the buffer cache.
- D. Writing dirty database block images from the buffer cache.
- E. Registering services with Oracle Net listeners.
- F. Reading database blocks into the buffer cache.
Answer: B,D,E
Explanation:
False. Server processes (foreground) read blocks into the buffer cache during user queries, not background processes.
Explanation:
Background processes manage core database operations. Let's break it down:
A : Creating dedicated server connections.
False. Dedicated server connections are created by the listener, not background processes. The listener hands off the connection to a server process (e.g., ora_s000), which isn't a background process.
B : Registering services with Oracle Net listeners.
True. The LREG process (Listener Registration, formerly PMON's role) registers services with listeners, using parameters like LOCAL_LISTENER.
Mechanics:LREG sends service details (e.g., orcl) to the listener every 60 seconds or on startup.
C : Writing redo to log files.
True. The LGWR (Log Writer) process writes redo entries from the redo log buffer to online redo log files, ensuring transaction durability.
Mechanics:Triggered by commits, log buffer fills, or checkpoints.
D : Writing dirty database block images from the buffer cache.
True. The DBWn (Database Writer) processes write modified (dirty) blocks from the buffer cache to data files, maintaining consistency.
Mechanics:Occurs at checkpoints or when free buffers are needed.
NEW QUESTION # 43
You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?
- A. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;
- B. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
- C. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;
- D. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
Answer: D
Explanation:
A .Incorrect syntax and view (pdb_spfile$ is not a valid view; PDB_SPFILE$ exists but lacks value$).
B .From CDB root, V$PARAMETER shows all parameters, not PDB-specific ones.
C .pdb_spfiles is not a valid view; PDB_SPFILE$ exists but requires scoping to a PDB.
D .True. From the PDB, V$PARAMETER shows parameters specific to that PDB, including inherited and PDB-modified values, with ISPDB_MODIFIABLE indicating alterability.
NEW QUESTION # 44
Which two are true about shrinking a segment online?
- A. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).
- B. To shrink a table it must have a PRIMARY KEY constraint.
- C. To shrink a table it must have a UNIQUE KEY constraint.
- D. To shrink a table it must have row movement enabled.
- E. It is not possible to shrink either indexes or Index Organized Tables (IOTs).
Answer: A,D
Explanation:
A .True. ROW MOVEMENT must be enabled for SHRINK SPACE.
B .False. Indexes and IOTs can be shrunk with CASCADE.
C .False. No such constraint requirement.
D .True. ASSM is required for online shrinking.
E .False. No primary key requirement.
NEW QUESTION # 45
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?
- A. TESTPDB must be in read-only mode after the cloning process is complete.
- B. PDB1 must be in read-only mode.
- C. Both CDBs need to be in local undo mode.
- D. PDB1 must be taken offline before the cloning process begins.
Answer: B
Explanation:
C .True. Hot cloning requires the source PDB (PDB1) to be read-only to ensure consistency during the clone. Others are not prerequisites.
NEW QUESTION # 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?
- A. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.
- B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.
- C. Dynamic service registration cannot be used for this database instance.
- D. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.
- E. The LREG process registers services dynamically with the LISTENER_1 listener.
Answer: E
Explanation:
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.
NEW QUESTION # 47
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
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.
NEW QUESTION # 48
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. It terminates.
- B. You can reattach to it and monitor it.
- C. You cannot monitor it.
- D. It continues to run in the background.
Answer: A,B
Explanation:
A .False. STOP_JOB=IMMEDIATE halts the job, not backgrounds it.
B .False. You can monitor before stopping or after restarting.
C .True. Before stopping, you can reattach with expdp attach=exp_db_full.
D .True. STOP_JOB=IMMEDIATE terminates the job instantly.
NEW QUESTION # 49
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. It overwrites any existing file with the name sales02.dbf in /u02 by default.
- C. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
- D. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
- E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
Answer: A,E
Explanation:
The ALTER DATABASE MOVE DATAFILE command relocates a data file to a new location while the database remains online, introduced in Oracle 12c and enhanced in subsequent releases like 23ai. Let's evaluate each option:
A . DML may be performed on tables with one or more extents in this data file during the execution of this command.True. The move operation is online by default in Oracle 23ai, allowing DML (INSERT, UPDATE, DELETE) operations on tables within the data file being moved. The database ensures consistency using redo and undo mechanisms.
B . It overwrites any existing file with the name sales02.dbf in /u02 by default.False. By default, the command does not overwrite an existing file unless the REUSE clause is specified (e.g., ALTER DATABASE MOVE DATAFILE ... REUSE). Without it, the command fails if the target file exists.
C . The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.False. When OMF is enabled (via DB_CREATE_FILE_DEST), the TO clause is optional. If omitted, Oracle automatically generates a file name and places it in the OMF destination.
D . Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.False. The move operation is a physical relocation of the data file; it does not alter the logical structure or compression state of objects within it. Compressed data remains compressed.
E . Tables with one or more extents in this data file may be queried during the execution of this command.True. The online nature of the move allows queries (SELECT statements) to proceed without interruption, leveraging Oracle's multi-version consistency model.
NEW QUESTION # 50
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. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
- C. Oracle Net Manager can be used to locally configure naming methods on a database server.
- D. The lsnrctl utility requires a listener.ora file to exist before it is started.
- E. The Oracle Net Configuration Assistant is only used when running the Oracle installer.
- F. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
Answer: B,C,F
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.
NEW QUESTION # 51
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 USR2, it is revoked from USR3.
- C. USR1 can revoke the CREATE VIEW privilege from USR3.
- D. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
- E. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.
Answer: B,E
Explanation:
A .False. Revoking from USR1 doesn't cascade due to WITH ADMIN OPTION.
B .True. Revoking from USR2 cascades to USR3 because USR2 granted it.
C .False. DBA can revoke the full privilege, not just ADMIN OPTION.
D .False. USR1 can't revoke from USR3 directly; only the grantor (USR2) can.
E .True. WITH ADMIN OPTION breaks the revoke chain from USR1 onward.
NEW QUESTION # 52
Which data dictionary view describes the data sources of external tables?
- A. DBA_ALL_USER_EXTERNAL_LOCATIONS
- B. DBA_ALL_USER_EXTERNAL_TABLES
- C. DBA_ALL_USER_TAB_COLUMNS
- D. DBA_ALL_USER_TABLES
Answer: A
Explanation:
A .True. DBA_EXTERNAL_LOCATIONS (or prefixed variants) shows external table data sources (e.g., file paths).
B-D .False. These views cover columns or tables but not external sources specifically.
NEW QUESTION # 53
Which three statements are true about Enterprise Manager Cloud Control?
- A. It is integrated with My Oracle Support.
- B. It provides management for Oracle middleware.
- C. It is available to manage a database only when that database is open.
- D. It uses a web-based console built into the Oracle database using XML DB.
- E. It provides management for Oracle-engineered systems.
Answer: A,B,E
Explanation:
A .True. Integrates with MOS for patches and support.
B .True. Manages Exadata, etc.
C .True. Covers WebLogic and other middleware.
D .False. Web-based, but not built into the DB.
E .False. Can manage stopped instances via agents.
NEW QUESTION # 54
Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?
- A. The role has the privileges to perform DDL operations on all local schema objects.
- B. No privileges are provided with the PDB_DBA role.
- C. The role has the privileges to create and manage users within the PDB.
- D. The role has the privileges to administer the PDB.
Answer: D
Explanation:
A .True. PDB_DBA grants admin rights (e.g., CREATE SESSION, ALTER SYSTEM) within the PDB.
B .False. DDL on objects requires ownership or explicit grants.
C .False. User management needs CREATE USER privilege, not inherent.
D .False. It includes multiple privileges, not none.
NEW QUESTION # 55
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 tablespaces to store metadata.
- B. It creates a new local user ADMIN with restricted privileges.
- C. It creates a new local user ADMIN with SYSDBA privileges.
- D. After the PDB is created, it is automatically opened Read/Write.
- E. It creates new default schemas for the PDB.
- F. The PDB must be opened Read Only to complete the integration of the PDB into the CDB.
Answer: A,B,E
Explanation:
A .True. PDBs inherit default schemas from the seed.
B .True. Metadata tablespaces (e.g., SYSTEM, SYSAUX) are created.
C .False. ADMIN1 (not ADMIN) isn't granted SYSDBA.
D .False. No read-only requirement post-creation.
E .False. PDBs start in MOUNTED state, not open.
F .True. ADMIN1 is a local user with CONNECT role only.
NEW QUESTION # 56
One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?
- A. Oracle shared memory structures are allocated.
- B. Online data files are opened.
- C. The initialization parameter file is read.
- D. The alert log has instance startup details written to it.
- E. Online redo logs are opened.
- F. Control files are read.
Answer: D,F
Explanation:
A .False. Data files open in OPEN.
B .False. Redo logs open in OPEN.
C .False. PFILE/SPFILE is read at NOMOUNT.
D .False. SGA is allocated at NOMOUNT.
E .True. Alert log records mount event.
F .True. Control files are read in MOUNT.
NEW QUESTION # 57
......
Verified 1Z1-182 dumps Q&As - 100% Pass from Free4Torrent: https://realtest.free4torrent.com/1Z1-182-valid-dumps-torrent.html