Practice Test Geeks(1Z0-006) Oracle Database Foundations Associate Practice Test
← All 1Z0-006 Flashcard Decks

Database Objects and Constraints Flashcards

7 cards from real 1Z0-006 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Database Objects and Constraints flashcards as text

  1. What is the primary purpose of an index in Oracle Database?

    Answer: To speed up data retrieval operations on a table

    An index improves query performance by allowing Oracle to quickly locate rows matching a search condition without performing a full table scan.

  2. Which type of index does Oracle automatically create when you define a PRIMARY KEY constraint?

    Answer: Unique B-tree index

    When a PRIMARY KEY constraint is defined, Oracle automatically creates a unique B-tree index on the primary key column(s) to enforce uniqueness and enable fast lookups.

  3. What is a composite index in Oracle Database?

    Answer: An index that spans two or more columns of a table

    A composite (concatenated) index is built on two or more columns, allowing Oracle to use it efficiently for queries that filter on those columns together.

  4. When should you consider dropping an index in Oracle Database?

    Answer: When the index is rarely used by queries but causes significant overhead on DML operations

    Indexes add overhead to INSERT, UPDATE, and DELETE operations because Oracle must keep them synchronized; an index that is rarely used by queries provides little benefit while slowing down data modifications.

  5. Which statement about indexes and DML operations in Oracle Database is TRUE?

    Answer: Oracle automatically updates all indexes when DML operations modify indexed column values

    Oracle transparently maintains all indexes on a table whenever DML (INSERT, UPDATE, DELETE) modifies the data, which is why having too many indexes can slow down write-intensive workloads.

  6. What is a function-based index in Oracle Database?

    Answer: An index built on the result of an expression or function applied to one or more columns

    A function-based index stores precomputed results of a function or expression on column values, enabling Oracle to use the index for queries that filter on that same expression.

  7. In which scenario is a bitmap index most appropriate in Oracle Database?

    Answer: A column with low cardinality such as a status flag or gender code

    Bitmap indexes are most efficient for low-cardinality columns (few distinct values) because a single bit per row compactly represents membership in each category, making them ideal for data warehouse queries.