[Jan 28, 2026] 1Z0-182 Exam Dumps PDF Guaranteed Success with Accurate & Updated Questions
Pass 1Z0-182 Exam - Real Test Engine PDF with 96 Questions
NEW QUESTION # 36
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. You can reattach to it and monitor it.
- C. It continues to run in the background.
- D. It terminates.
Answer: B,D
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 # 37
What memory structure caches the data dictionary providing access to all database user processes?
- A. The Streams Pool
- B. The Large Pool
- C. The Shared Pool
- D. The Java Pool
Answer: C
Explanation:
D .True. The Shared Pool caches data dictionary metadata (e.g., table definitions) in the Library Cache and Dictionary Cache, accessible to all processes. Others serve different purposes (e.g., Large Pool for backups).
NEW QUESTION # 38
Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?
- A. Only in memory
- B. Only in the SPFILE
- C. In the SPFILE and memory
- D. In the SPFILE and PFILE
- E. In the SPFILE, PFILE, and memory
Answer: C
Explanation:
B .True. Without SCOPE, ALTER SYSTEM defaults to BOTH (memory and SPFILE); PFILE isn't updated unless manually recreated.
NEW QUESTION # 39
Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?
- A. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
- B. The high-water mark (HWM) of ORDERS is adjusted.
- C. Dependent indexes become UNUSABLE.
- D. Only queries are allowed on ORDERS while SHRINK is executing.
- E. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
- F. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
Answer: A,E
Explanation:
A . Dependent indexes become UNUSABLE.False. SHRINK SPACE COMPACT does not affect index usability; only SHRINK SPACE without COMPACT may require index maintenance if CASCADE is omitted.
B . ... starting toward the end of the ORDERS segment.False. Rows are compacted toward the beginning of the segment, not the end.
C . Only queries are allowed ...False. Both queries and DML are allowed during SHRINK SPACE COMPACT as it's an online operation.
D . The high-water mark (HWM) of ORDERS is adjusted.False. COMPACT moves rows but doesn't adjust the HWM; the full SHRINK SPACE command is needed for HWM adjustment.
E . Queries and DML statements are allowed ...True. This is an online operation in 23ai, allowing concurrent access.
F . ... starting from the beginning of the ORDERS segment.True. Rows are moved to fill free space from the segment's start.
NEW QUESTION # 40
Which two statements are true about Fine-Grained Auditing (FGA)?
- A. FGA policies can be created by a user having the AUDIT_ADMIN privilege.
- B. FGA policies can only be created by a user with SYSDBA privilege.
- C. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.
- 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: A,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 # 41
Which three statements are true about the tools used to configure Oracle Net Services?
- A. The lsnrctl utility requires a listener.ora file to exist before it is started.
- 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 centrally configure listeners on any database server target.
- D. Oracle Net Manager can be used to locally configure naming methods on a database server.
- 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,D,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 # 42
Which two statements are true about the configuration and use of UNDO?
- A. Unexpired UNDO is always retained.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
- C. UNDO_RETENTION specifies how long all types of UNDO are retained.
- D. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- E. Active UNDO is always retained.
Answer: D,E
Explanation:
A .True. Active (in-use) UNDO is never overwritten.
B .False. Unexpired UNDO can be reused if space is needed.
C .False. Applies to unexpired, not expired UNDO.
D .False. Only unexpired UNDO is targeted.
E .True. UNDO_RETENTION sets the retention goal for unexpired UNDO.
NEW QUESTION # 43
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 table, column, index, and system statistics used for generating efficient SQL execution plans.
- C. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
- D. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
Answer: B
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 # 44
Which two actions can you perform using DBCA for an existing database?
- A. Create a template that can be used to clone the database.
- B. Change the server mode from dedicated to shared, and vice versa.
- C. Change the character set.
- D. Create an additional listener.
- E. Create nonstandard block size tablespaces.
Answer: A,B
Explanation:
A .False. DBCA can't change character sets post-creation.
B .False. Listeners are managed via NetCA or lsnrctl.
C .True. DBCA can switch server modes for existing DBs.
D .False. Tablespaces are created via SQL, not DBCA for existing DBs.
E .True. DBCA can generate clone templates from existing DBs.
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. Both CDBs need to be in local undo mode.
- B. TESTPDB must be in read-only mode after the cloning process is complete.
- C. PDB1 must be in read-only mode.
- D. PDB1 must be taken offline before the cloning process begins.
Answer: C
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 which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?
- A. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).
- B. By setting the STATISTICS_LEVEL parameter to BASIC.
- C. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.
- D. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).
- E. By setting the TIMED_STATISTICS system parameter to FALSE.
Answer: B,E
Explanation:
A .True. TIMED_STATISTICS = FALSE disables timing data collection.
B .False. No such procedure exists.
C .False. No TIMED_STATISTICS_LEVEL parameter exists.
D .True. STATISTICS_LEVEL = BASIC disables most performance monitoring.
E .False. No such procedure exists.
NEW QUESTION # 47
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. USR1 can revoke the CREATE VIEW privilege from USR3.
- B. The DBA can revoke only ADMIN OPTION from USR1.
- C. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.
- D. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.
- E. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
Answer: C,D
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 # 48
Which three tasks are performed by background processes in an Oracle database instance?
- A. Registering services with Oracle Net listeners.
- B. Writing dirty database block images from the buffer cache.
- C. Reading database blocks into the buffer cache.
- D. Reading database blocks into the buffer cache.
- E. Creating dedicated server connections.
- F. Writing redo to log files.
Answer: A,B,F
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 # 49
Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?
- A. Undo segments can be stored in the SYSTEM tablespace.
- B. A single transaction may use multiple undo segments simultaneously.
- C. Undo segments can extend when a transaction fills the last extent of the undo segment.
- D. Undo segments can be stored in the SYSAUX tablespace.
- E. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.
Answer: B,C
Explanation:
A .False. Undo is stored in a dedicated undo tablespace, not SYSTEM.
B .True. Large transactions can span multiple undo segments.
C .False. Undo isn't stored in SYSAUX.
D .True. Undo segments extend as needed, space permitting.
E .False. Undo doesn't "wrap"; new extents are allocated.
NEW QUESTION # 50
Which two Oracle database space management features require the use of locally managed tablespaces?
- A. Free space management with bitmaps.
- B. Online segment shrink.
- C. Oracle Managed Files (OMF).
- D. Automatic data file extension (AUTOEXTEND).
- E. Server-generated tablespace space alerts.
Answer: A,B
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.
NEW QUESTION # 51
Which three tasks are part of the predefined Automated Maintenance Tasks?
- A. Automatic Optimizer Statistics Collection.
- B. Automatic notification tasks.
- C. Automatic segment and segment statistics advisor tasks.
- D. Automatic error and failure log collection tasks.
- E. Automatic SQL Plan Management advisor tasks.
- F. Automatic Backups of the database system files.
Answer: A,C,E
Explanation:
A .False. Backups are via RMAN, not AMTs.
B .True. Stats collection is an AMT.
C .False. Error logging isn't an AMT.
D .True. SPM tasks are included.
E .False. Notifications aren't AMTs.
F .True. Segment Advisor is an AMT.
NEW QUESTION # 52
Which three statements are true about row chaining and row migration done by Oracle database block space management?
- A. Row pieces of a chained row must always reside in different blocks.
- B. Update statements can result in one or more chained rows.
- C. A migrated row results in an update to any index on the table to point the row ID in the index to the row's new location.
- D. Update statements can result in one or more migrated rows.
- E. Insert statements can result in a migrated row.
Answer: B,C,D
Explanation:
A .True. Migration updates index ROWIDs.
B .True. Updates can migrate rows if space is insufficient.
C .True. Large updates can chain rows across blocks.
D .False. Chained rows may span blocks but aren't required to.
E .False. Inserts don't migrate; they chain if too large initially.
NEW QUESTION # 53
In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?
- A. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
- B. Revoke the CREATE SESSION privilege from user HR.
- C. Log in to the database instance.
- D. Execute DDL statements in the HR schema.
- E. Execute DML statements in the HR schema.
- F. Revoke the CREATE SESSION privilege from other users.
Answer: A,C,F
Explanation:
A .False. CREATE SESSION doesn't grant DML rights.
B .True. CREATE SESSION allows login.
C .True. WITH ADMIN OPTION allows revoking from others HR granted it to.
D .True. WITH ADMIN OPTION permits granting with the same option.
E .False. Users can't revoke their own privileges.
F .False. DDL requires additional privileges (e.g., CREATE TABLE).
NEW QUESTION # 54
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 WRITE ONLY
- B. RESTRICTED READ ONLY
- C. READ WRITE
- D. READ ONLY
Answer: C
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 # 55
Which two methods can be used to purge audit records of the Unified Audits?
- A. Only viewed audit records can be purged from Unified Audits.
- B. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.
- C. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.
- D. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.
- E. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.
- F. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.
Answer: C,D
Explanation:
False. No such procedure exists in DBMS_AUDIT_MGMT. The package offers CLEAN_AUDIT_TRAIL and CREATE_PURGE_JOB, but nothing targets a specific policy's records by name in this format. You can filter records in UNIFIED_AUDIT_TRAIL by policy (e.g., SELECT * WHERE UNIFIED_AUDIT_POLICIES = 'POLICY_NAME'), but purging is all-or-nothing or time-based, not policy-specific via a single command.
Why Incorrect:This appears to be a fabricated or misinterpreted option, possibly confusing audit policy management with trail purging.
Explanation:
Unified Auditing in Oracle 23ai consolidates audit records into a single trail, managed via the DBMS_AUDIT_MGMT package. Let's evaluate each option with extensive detail:
A : Only viewed audit records can be purged from Unified Audits.
False. There's no concept of "viewed" audit records restricting purging. Unified Audit records (stored in UNIFIED_AUDIT_TRAIL) can be purged based on time, policy, or manual intervention, regardless of whether they've been viewed. This option misrepresents audit management capabilities.
Mechanics:Purging is controlled by retention policies or explicit commands, not view status. For example, records older than a set retention period (e.g., 90 days via DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY) are eligible for purging.
Why Incorrect:No Oracle documentation ties purging to viewing, making this a fabricated limitation.
B : Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user toschedule an automatic purge job.
True. This procedure creates a scheduled job to automatically purge audit records based on a retention policy or custom criteria. It's a standard method for ongoing audit trail maintenance, requiring privileges like AUDIT_ADMIN.
Mechanics:Example: BEGIN DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, JOB_FREQUENCY => 'DAILY', JOB_STATUS => DBMS_AUDIT_MGMT.JOB_ENABLED); END;. This schedules daily purges of old records, using the retention period set by SET_AUDIT_TRAIL_PROPERTY.
Practical Use:Ideal for production environments to prevent the audit trail from growing indefinitely (e.g., avoiding tablespace exhaustion in SYSAUX).
Edge Case:If no retention period is set, the job purges nothing until configured, highlighting the need for prior setup.
C : Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.
False. Audit policies don't have "owners" in the traditional sense; they're created by users with AUDIT_ADMIN and managed globally. Resetting or disabling a policy (e.g., NOAUDIT POLICY my_policy) stops auditing but doesn't purge existing records. Purging is a separate operation via DBMS_AUDIT_MGMT.
Why Incorrect:This conflates policy management with audit trail cleanup, which are distinct in Oracle.
D : Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.
True. This procedure manually purges all Unified Audit records up to the current timestamp (or a specified time), requiring AUDIT_ADMIN privileges. It's a one-time cleanup tool.
Mechanics:Example: BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, USE_LAST_ARCH_TIMESTAMP => FALSE); END;. This clears the entire trail unless restricted by a timestamp.
Practical Use:Useful for immediate space reclamation or post-incident cleanup, unlike scheduled jobs.
Edge Case:If the audit trail is large, this may require significant undo space and time, potentially impacting performance.
NEW QUESTION # 56
Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?
- A. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.
- C. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
- D. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.
- E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
Answer: C,D
Explanation:
With OMF enabled, Oracle automatically manages file creation. The command ALTER TABLESPACE sales_q1 ADD DATAFILE without a file specification relies on initialization parameters:
A . Specify a path in the DATAFILE clause ... with at least 100 MB of available space.False. With OMF, explicitly specifying a path overrides OMF behavior, but it's not required for success if OMF parameters are set correctly.
B . Add the AUTOEXTEND ON clause with NEXT set to 100M.False. AUTOEXTEND is optional and affects file growth, not the initial creation success, which depends on available space in the OMF location.
C . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.True. If both parameters are set,Oracle may use either for data files (depending on context), and sufficient space (e.g., 50 MB minimum for a smallfile) ensures success.
D . Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.True. This is the primary OMF parameter for data files; sufficient space (typically 100 MB minimum for a new file) guarantees the command succeeds.
E . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.False. This is redundant with C; only one needs sufficient space, though C's phrasing makes it a valid independent action.
NEW QUESTION # 57
Which three statements are true about dynamic performance views?
- A. Read consistency is not guaranteed.
- B. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.
- C. They are owned by the SYSTEM user.
- D. They can be queried only when the database is open.
- E. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
Answer: A,B,E
Explanation:
A .True. V$ views reflect real-time memory data, not consistent snapshots.
B .True. V$FIXED_TABLE lists all V$ views.
C .True. Data comes from memory structures and data dictionary metadata.
D .False. Owned by SYS, not SYSTEM.
E .False. Some V$ views are accessible in MOUNT state.
NEW QUESTION # 58
......
Oracle 1Z0-182 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Get New 1Z0-182 Certification Practice Test Questions Exam Dumps: https://passleader.dumpexams.com/1Z0-182-vce-torrent.html