Oracle 1Z0-182 Test Engine Dumps Training With 96 Questions
1Z0-182 Questions Pass on Your First Attempt Dumps for Oracle Database 23ai Certified
NEW QUESTION # 15
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?
- A. ALTER SYSTEM FLUSH BUFFER_CACHE
- B. ALTER SYSTEM CHECKPOINT
- C. ALTER SYSTEM SWITCH LOGFILE
- D. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
Answer: B,D
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 # 16
You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?
- A. PDB archive file and only the user-defined tablespaces must be copied to the target CDB.
- B. The PDB archive file must be copied to the target CDB.
- C. The PDB manifest and all the datafiles must be copied to the target CDB.
- D. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.
Answer: D
Explanation:
D .True. The .pdb file (archive) contains the manifest and data files; all must be copied to the target CDB for plugging.
A-C .False. The archive alone isn't enough; all components are needed.
NEW QUESTION # 17
Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?
- A. The Automatic SQL Access Advisor task, which is used to manage an application SQL load.
- B. The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.
- C. The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.
- D. The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.
- E. The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.
Answer: C,E
Explanation:
Automatic Maintenance Tasks (AMTs) in 23ai optimize database performance. Let's explore:
A .False. SQL Access Advisor exists but isn't an AMT; it's manual or invoked separately.
B .False. SQL Performance Analyzer assesses change impacts but isn't part of AMTs.
C .False. No "Automatic Index Advisor" exists as an AMT; Auto Index is a separate feature.
D .True. The SPM Evolve Advisor task (part of ORA$AUTOTASK) automatically evolves SQL plan baselines, testing and accepting new plans.
Mechanics:Runs in maintenance windows, managed by DBMS_SPM.
E .True. SQL Tuning Advisor (STA) runs automatically via AMTs, tuning high-load SQL.
Mechanics:Identifies candidates from AWR and suggests indexes, profiles, etc.
NEW QUESTION # 18
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 continues to run in the background.
- B. It terminates.
- C. You cannot monitor it.
- D. You can reattach to it and monitor it.
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 # 19
How do you validate that the database was migrated to Unified Auditing?
- A. By querying V$OPTION for parameter Unified Auditing.
- B. By using the LSINVENTORY Command to query the Oracle Database Software Library.
- C. By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
- D. By querying the DBA_UNIFIED_AUDIT_OPTION view.
Answer: A
Explanation:
Unified Auditing is enabled at database creation or migration in 23ai. Let's analyze:
A . By querying V$OPTION for parameter Unified Auditing.
True. SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; returns TRUE if enabled. It's the definitive way to confirm Unified Auditing is active at the database level.
Mechanics:V$OPTION reflects compiled-in features; TRUE indicates the binary was linked with Unified Auditing (uniauflt=on during relink).
Practical Use:Quick, reliable check post-migration or upgrade.
B . By using the LSINVENTORY Command to query the Oracle Database Software Library.
False. LSINVENTORY (from OPatch) lists installed software components, not runtime features like auditing mode.
C . By querying the DBA_UNIFIED_AUDIT_OPTION view.
False. This view doesn't exist; DBA_AUDIT_POLICIES or UNIFIED_AUDIT_TRAIL show policies and records but not migration status.
D . By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
False. No "Verify mode" exists in DBMS_AUDIT_MGMT; it manages audit trails, not migration validation.
NEW QUESTION # 20
Which two statements are true about the PMON background process?
- A. It frees resources held by abnormally terminated processes.
- B. It records checkpoint information in the control file.
- C. It frees unused temporary segments.
- D. It registers database services with all local and remote listeners known to the database instance.
- E. It rolls back transactions when a process fails.
Answer: A,E
Explanation:
A .False. LREG handles registration in 23ai, not PMON.
B .False. CKPT (Checkpoint) process updates the control file.
C .True. PMON cleans up after failed processes (e.g., releases locks).
D .True. PMON rolls back uncommitted transactions of failed processes.
E .False. SMON (System Monitor) manages temporary segment cleanup.
NEW QUESTION # 21
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
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 # 22
Which two actions can you perform using DBCA for an existing database?
- A. Create an additional listener.
- B. Change the character set.
- C. Change the server mode from dedicated to shared, and vice versa.
- D. Create a template that can be used to clone the database.
- E. Create nonstandard block size tablespaces.
Answer: C,D
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 # 23
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. 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.
- C. Update statements can result in one or more chained rows.
- 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 # 24
What are the three components of Oracle Database Automatic Maintenance Tasks?
- A. A packaging system that allows you to combine all error and failure logs to share with Oracle Support.
- B. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.
- C. A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.
- D. A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.
- E. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.
- F. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.
Answer: B,E,F
Explanation:
A .False. Diagnostic collection is ADR, not AMT.
B .True. Resource Manager allocates resources to AMTs.
C .True. Scheduler defines maintenance windows.
D .False. Packaging is IPS/ADR, not AMT.
E .False. Alert log is separate from AMTs.
F .True. Tasks like stats collection are AMTs.
NEW QUESTION # 25
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. It should be used whenever PDB1 open mode needs to be changed.
- C. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
- D. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.
Answer: C
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).
NEW QUESTION # 26
Which three actions are ways to apply the principle of least privilege?
- A. Using Access Control Lists (ACLs).
- B. Setting the REMOTE_OS_AUTHENT parameter to TRUE.
- C. Enabling Unified Auditing.
- D. Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).
- E. Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.
Answer: A,C,D
Explanation:
A .True. Auditing tracks privilege use, enforcing least privilege.
B .True. Revoking unnecessary PL/SQL access limits capabilities.
C .True. ACLs restrict network access precisely.
D .False. TRUE relaxes dictionary access, violating least privilege.
E .False. TRUE allows risky OS auth, weakening security.
NEW QUESTION # 27
Which two Oracle database space management features require the use of locally managed tablespaces?
- A. Oracle Managed Files (OMF).
- B. Automatic data file extension (AUTOEXTEND).
- C. Server-generated tablespace space alerts.
- D. Free space management with bitmaps.
- E. Online segment shrink.
Answer: D,E
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 # 28
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 setting the TIMED_STATISTICS system parameter to FALSE.
- B. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).
- C. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.
- D. By setting the STATISTICS_LEVEL parameter to BASIC.
- E. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).
Answer: A,D
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 # 29
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 taken offline before the cloning process begins.
- C. PDB1 must be in read-only mode.
- D. Both CDBs need to be in local undo mode.
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 # 30
Which three are benefits of using temp UNDO when performing DML on global temporary tables?
- A. It reduces I/Os to the SYSTEM tablespace.
- B. It reduces the amount of UNDO stored in the UNDO tablespace.
- C. It permits DML on global temporary tables even if the database is opened read-only.
- D. It reduces I/Os to the SYSAUX tablespace.
- E. It reduces the amount of redo generated.
Answer: A,B,E
Explanation:
Temp UNDO, introduced in Oracle 12c and refined in 23ai, stores undo for global temporary tables (GTTs) in temporary tablespaces:
A . It permits DML on GTTs even if the database is opened read-only.False. In read-only mode, DML on GTTs is allowed regardless of temp UNDO, as GTT data is session-private, but temp UNDO doesn't specifically enable this.
B . It reduces the amount of UNDO stored in the UNDO tablespace.True. Temp UNDO stores undo in the temporary tablespace, reducing usage of the permanent UNDO tablespace.
C . It reduces I/Os to the SYSTEM tablespace.True. By avoiding permanent undo, it reduces metadata updates in the SYSTEM tablespace related to undo management.
D . It reduces the amount of redo generated.True. Temp UNDO changes are not redo-logged to the same extent as permanent undo, minimizing redo generation.
E . It reduces I/Os to the SYSAUX tablespace.False. SYSAUX is unrelated to undo management; temp UNDO affects temporary and SYSTEM tablespaces.
NEW QUESTION # 31
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. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
- B. Ensure that DB_CREATE_FILE_DEST specifies 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. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.
- E. Add the AUTOEXTEND ON clause with NEXT set to 100M.
Answer: B,C
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 # 32
You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?
- A. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;
- B. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;
- C. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
- D. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
Answer: C
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 # 33
Which two tasks can be performed in the NOMOUNT state?
- A. Full database recovery.
- B. Enabling online redo log archiving.
- C. Re-creating control files.
- D. Renaming data files.
- E. Creating a database.
Answer: C,E
Explanation:
A .False. Requires MOUNT to access data files.
B .False. Requires MOUNT for redo logs.
C .True. CREATE DATABASE runs in NOMOUNT.
D .True. CREATE CONTROLFILE is possible.
E .False. Recovery needs MOUNT or OPEN.
NEW QUESTION # 34
Which two are benefits of external tables?
- A. They can be queried, transformed, and joined with other tables without having to load the data first.
- B. They support UPDATEs, which transparently updates records in the file system as if they were table rows.
- C. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
- D. They support DELETEs, which transparently deletes records in the file system as if they were table rows.
- E. They can be queried while the database is in the MOUNT state like dynamic performance views.
Answer: A,C
Explanation:
A .False. External tables are read-only; no DELETE.
B .False. Require OPEN state, unlike V$ views.
C .False. No UPDATE support; read-only.
D .True. Queryable like regular tables without loading.
E .True. Data Pump can unload query results to files.
NEW QUESTION # 35
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?
- A. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.
- B. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.
- C. The first block with enough free space to accommodate a row being inserted will always be used for that row.
- D. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.
- E. PCTFREE defaults to 10% for all blocks in all segments for all compression methods.
Answer: A,D
Explanation:
A .True. ASSM categorizes blocks (e.g., 0-25%, 25-50%) for efficient space use.
B .False. Updates may cause chaining/migration, not always relocation.
C .True. ASSM optimizes inserts into suitable blocks.
D .False. ASSM uses a bitmap, not necessarily the first block.
E .False. PCTFREE is segment-specific, not universally 10%.
NEW QUESTION # 36
Which three statements are true about roles?
- A. The SET ROLE statement can enable one or more roles for a session.
- B. Roles may be granted to other roles.
- C. Roles must be password protected.
- D. The SET ROLE statement can disable one or more roles for a session.
- E. Object privileges may not be granted to roles.
- F. All roles granted to a user are set on default when the user logs in.
Answer: A,B,D
Explanation:
Roles in Oracle manage privileges efficiently. Let's dive into each option:
A . Roles must be password protected.
False. Roles can be password-protected (e.g., CREATE ROLE mgr IDENTIFIED BY secret), but it's optional. Non-protected roles (default) are enabled automatically if granted, requiring no password.
Mechanics:Password-protected roles need SET ROLE mgr IDENTIFIED BY secret, enhancing security for sensitive privileges.
B . Roles may be granted to other roles.
True. Roles can form hierarchies (e.g., GRANT clerk TO mgr), allowing nested privilege management.
Mechanics:A user with mgr inherits clerk privileges indirectly. Revoking clerk from mgr cascades appropriately.
Practical Use:Simplifies complex privilege structures in large organizations.
C . The SET ROLE statement can enable one or more roles for a session.
True. SET ROLE role1, role2; activates specified roles for the session, assuming they're granted and not password-protected (or password is provided).
Mechanics:Enabled roles grant their privileges immediately within the session scope.
D . Object privileges may not be granted to roles.
False. Object privileges (e.g., GRANT SELECT ON emp TO clerk) are a primary use of roles, making this statement incorrect.
Why Incorrect:Roles are designed for this purpose, contradicting the option.
E . All roles granted to a user are set on default when the user logs in.
False. Only roles marked as DEFAULT ROLE (via ALTER USER ... DEFAULT ROLE role1) are enabled at login. Non-default roles require SET ROLE.
Mechanics:Check via SELECT * FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES'.
F . The SET ROLE statement can disable one or more roles for a session.
True. SET ROLE NONE disables all roles, or SET ROLE role1 implicitly disables others not listed, providing granular control.
Practical Use:Useful for testing or restricting privileges temporarily.
NEW QUESTION # 37
Which three tasks are part of the predefined Automated Maintenance Tasks?
- A. Automatic SQL Plan Management advisor tasks.
- B. Automatic error and failure log collection tasks.
- C. Automatic segment and segment statistics advisor tasks.
- D. Automatic Backups of the database system files.
- E. Automatic notification tasks.
- F. Automatic Optimizer Statistics Collection.
Answer: A,C,F
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 # 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. In the SPFILE, PFILE, and memory
- B. In the SPFILE and PFILE
- C. Only in memory
- D. Only in the SPFILE
- E. In the SPFILE and memory
Answer: E
Explanation:
B .True. Without SCOPE, ALTER SYSTEM defaults to BOTH (memory and SPFILE); PFILE isn't updated unless manually recreated.
NEW QUESTION # 39
Which two statements are true about views used for viewing tablespace and datafile information?
- A. Tablespace free space can be viewed in V$TABLESPACE.
- B. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
- C. V$TABLESPACE displays information that is contained in the control file about tablespaces.
- D. V$TABLESPACE displays information about tablespaces contained in the data dictionary.
- E. Tablespace free space can be viewed in DBA_TABLESPACES.
Answer: B,C
Explanation:
A .False. V$TABLESPACE doesn't show free space directly.
B .False. It's from the control file, not the data dictionary.
C .True. Renaming in MOUNT state updates DBA_DATA_FILES post-open.
D .False. DBA_TABLESPACES shows attributes, not free space directly (use DBA_FREE_SPACE).
E .True. V$TABLESPACE reflects control file data.
NEW QUESTION # 40
......
Oracle 1Z0-182 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
1Z0-182 Practice Test Pdf Exam Material: https://braindumps.getvalidtest.com/1Z0-182-brain-dumps.html