Oracle 1Z0-182 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

ACapacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

BOnline table segment shrink.

COnline index segment shrink.

DOracle Managed Files (OMF).

EAutomatic data file extension (AUTOEXTEND).

Correct : A, D, E

Dictionary-managed tablespaces (DMTs) use the data dictionary for extent management, whilelocally managed tablespaces (LMTs) use bitmaps. Let's evaluate compatibility:

A . Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

True. AWR tracks space usage (e.g., DBA_HIST_TBSPC_SPACE_USAGE) regardless of tablespace type, enabling growth reports for both DMTs and LMTs.

Mechanics:MMON collects metrics like segment growth, stored in SYSAUX, accessible via EM or scripts.

Practical Use:Helps predict when to add data files, universal across management types.

B . Online table segment shrink.

False. ALTER TABLE ... SHRINK SPACE requires LMTs with Automatic Segment Space Management (ASSM), unavailable in DMTs, which lack bitmap-based free space tracking.

Why Incorrect:DMTs use freelists, incompatible with shrink operations.

C . Online index segment shrink.

False. Like tables, ALTER INDEX ... SHRINK SPACE requires LMTs with ASSM, not supported in DMTs.

Why Incorrect:Same limitation as B; DMTs can't compact online.

D . Oracle Managed Files (OMF).

True. OMF automates file naming and placement (via DB_CREATE_FILE_DEST) for both DMTs and LMTs, agnostic to extent management.

Mechanics:Example: CREATE TABLESPACE ts1; creates an OMF file in either type.

Edge Case:DMTs are rare in 23ai, but OMF still applies.

E . Automatic data file extension (AUTOEXTEND).

True. AUTOEXTEND ON allows data files to grow as needed, supported in both DMTs and LMTs since early versions.

Mechanics:ALTER DATABASE DATAFILE ... AUTOEXTEND ON NEXT 100M; works universally.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ACapacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

BOnline table segment shrink.

COnline index segment shrink.

DOracle Managed Files (OMF).

EAutomatic data file extension (AUTOEXTEND).

0 / 1500

Question 2

Which three statements are true about using SQL*Plus?

AIt can run scripts passed to it by a shell script.

BIt can run Recovery Manager (RMAN) commands.

CIt must be downloaded from the Oracle Technology Network (OTN).

DIt has both command-line and graphical user interfaces (GUI).

EIt can run scripts entered at the SQL prompt.

FIt has its own commands that are separate from any SQL statements.

Correct : A, E, F

A .True. sqlplus @script.sql works from shell scripts.

B .False. RMAN uses its own client, not SQL*Plus.

C .False. Bundled with Oracle DB software.

D .False. Command-line only; no GUI in 23ai.

E .True. @script runs scripts interactively.

F .True. Commands like SHOW PARAMETER are unique.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt can run scripts passed to it by a shell script.

BIt can run Recovery Manager (RMAN) commands.

CIt must be downloaded from the Oracle Technology Network (OTN).

DIt has both command-line and graphical user interfaces (GUI).

EIt can run scripts entered at the SQL prompt.

FIt has its own commands that are separate from any SQL statements.

0 / 1500

Question 3

Which three statements are true about an SPFILE?

AIt can be created by SYS from an idle instance.

BIt contains only static initialization parameters.

CIt can be used to create a PFILE.

DIt must exist for a database instance to start.

EIt contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.

Correct : A, C, E

A .True. CREATE SPFILE FROM PFILE works when idle.

B .False. Includes dynamic parameters too.

C .True. CREATE PFILE FROM SPFILE generates a PFILE.

D .False. A PFILE can start the instance if no SPFILE exists.

E .True. Dynamic parameters (e.g., DB_CACHE_SIZE) are modifiable.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt can be created by SYS from an idle instance.

BIt contains only static initialization parameters.

CIt can be used to create a PFILE.

DIt must exist for a database instance to start.

EIt contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.

0 / 1500

Question 4

What are Oracle Database Metrics?

AOracle Database Metrics monitor performance using thresholds to generate alerts.

BOracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

COracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

DOracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

EOracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

Correct : A, C

A .True. Metrics (e.g., V$SYSMETRIC) use thresholds for alerts.

B .False. Metrics aren't tied to email notifications directly.

C .True. Metrics measure rates (e.g., IOPS, transactions/sec).

D .False. EMCC uses metrics, but they're DB-level, not EM-specific.

E .False. Metrics exist in the DB, not just EMCC.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AOracle Database Metrics monitor performance using thresholds to generate alerts.

BOracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

COracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

DOracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

EOracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

0 / 1500

Question 5

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

AThe role has the privileges to administer the PDB.

BThe role has the privileges to perform DDL operations on all local schema objects.

CThe role has the privileges to create and manage users within the PDB.

DNo privileges are provided with the PDB_DBA role.

Correct : A

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.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe role has the privileges to administer the PDB.

BThe role has the privileges to perform DDL operations on all local schema objects.

CThe role has the privileges to create and manage users within the PDB.

DNo privileges are provided with the PDB_DBA role.

0 / 1500

Master Oracle 1Z0-182 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: