oracle 1z0-182 practice test

Exam Title: Oracle Database 23ai Administration Associate

Last update: Nov 27 ,2025
Question 1

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. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
  • D. They are owned by the SYSTEM user.
  • E. They can be queried only when the database is open.
Answer:

A,B,C


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.
Reference:Oracle Database Reference 23ai, "Dynamic Performance Views."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 2

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.
Reference:Oracle Database Reference 23ai, "Initialization Parameters."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 3

Which statement regarding PDBs (Pluggable Databases) is correct?

  • A. You can drop a PDB as long as it is not the PDB seed.
  • B. You cannot drop a source PDB of a refreshable PDB.
  • C. You can drop an application root along with the associated PDBs.
  • D. When the relocation of a PDB is finished, the source PDB must be dropped.
Answer:

A


Explanation:
A .True. Any PDB except PDB$SEED can be dropped.
B .False. Source PDBs of refreshable clones can be dropped after cloning.
C .False. Dropping an application root requires explicit handling of PDBs.
D .False. Relocation doesn’t mandate dropping the source PDB.
Reference:Oracle Multitenant Administrator’s Guide 23ai, "Dropping a PDB."

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 4

Which three statements are true about Deferred Segment Creation in Oracle databases?

  • A. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
  • B. It is supported for SYS-owned tables contained in locally managed tablespaces.
  • C. It is the default behavior for tables and indexes.
  • D. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.
  • E. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
Answer:

C,D,E


Explanation:
A .False. IOTs require immediate segment creation.
B .False. SYS-owned tables don’t use deferred creation.
C .True. Default since 11gR2, continued in 23ai.
D .True. Indexes inherit this attribute unless overridden.
E .True. Sessions can alter this via DEFERRED_SEGMENT_CREATION.
Reference:Oracle Database Concepts 23ai, "Deferred Segment Creation."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 5

Which two statements are true regarding Oracle database space management within blocks
managed by Automatic Segment Space Management (ASSM)?

  • A. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.
  • B. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.
  • C. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.
  • D. The first block with enough free space to accommodate a row being inserted will always be used for that row.
  • E. PCTFREE defaults to 10% for all blocks in all segments for all compression methods.
Answer:

A,C


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%.
Reference:Oracle Database Concepts 23ai, "Automatic Segment Space Management."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 6

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. V$TABLESPACE displays information about tablespaces contained in the data dictionary.
  • C. 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.
  • D. Tablespace free space can be viewed in DBA_TABLESPACES.
  • E. V$TABLESPACE displays information that is contained in the control file about tablespaces.
Answer:

C,E


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.
Reference:Oracle Database Reference 23ai, "V$TABLESPACE, DBA_DATA_FILES."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 7

Which advisor is used to detect missing or stale object statistics?

  • A. SQL Tuning Advisor
  • B. SQL Statistics Advisor
  • C. SQL Performance Analyzer
  • D. SQL Access Advisor
Answer:

B


Explanation:
B .True. The SQL Statistics Advisor (new in 23ai) identifies stale or missing statistics. Others focus on
tuning, performance analysis, or access paths.
Reference:Oracle Database SQL Tuning Guide 23ai, "SQL Statistics Advisor."

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 8

Which three statements are true about row chaining and row migration done by Oracle database
block space management?

  • A. 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.
  • B. Update statements can result in one or more migrated rows.
  • C. Update statements can result in one or more chained rows.
  • D. Row pieces of a chained row must always reside in different blocks.
  • E. Insert statements can result in a migrated row.
Answer:

A,B,C


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.
Reference:Oracle Database Concepts 23ai, "Row Chaining and Migration."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 9

Which two are true about shrinking a segment online?

  • A. To shrink a table it must have row movement enabled.
  • B. It is not possible to shrink either indexes or Index Organized Tables (IOTs).
  • C. To shrink a table it must have a UNIQUE KEY constraint.
  • D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).
  • E. To shrink a table it must have a PRIMARY KEY constraint.
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.
Reference:Oracle Database SQL Language Reference 23ai, "SHRINK SPACE."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 10

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 and PFILE
  • B. In the SPFILE and memory
  • C. Only in memory
  • D. In the SPFILE, PFILE, and memory
  • E. Only in the SPFILE
Answer:

B


Explanation:
B .True. Without SCOPE, ALTER SYSTEM defaults to BOTH (memory and SPFILE); PFILE isn’t updated
unless manually recreated.
Reference:Oracle Database Administrator’s Guide 23ai, "Managing Initialization Parameters."

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Page 1 out of 9
Viewing questions 1-10 out of 94
Go To
page 2