Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Managing Schemas and Database Objects Flashcards

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

Read the first 6 Managing Schemas and Database Objects flashcards as text

  1. Which constraint type enforces uniqueness of values in one or more columns but allows NULL values?

    Answer: UNIQUE

    A UNIQUE constraint ensures no two rows have the same non-null value(s) in the constrained column(s), but unlike PRIMARY KEY, it permits NULL values.

  2. What is an Index-Organized Table (IOT) in Oracle?

    Answer: A table whose rows are stored in primary key order within a B-tree index structure

    An IOT stores table data in a B-tree index ordered by the primary key, eliminating a separate heap table and improving access performance for primary key lookups.

  3. Which data dictionary view lists all indexes owned by the current user?

    Answer: USER_INDEXES

    USER_INDEXES shows all indexes owned by the currently connected user, providing details such as index type, uniqueness, and associated table.

  4. What is the primary purpose of the DBMS_STATS package in Oracle?

    Answer: To collect optimizer statistics on tables, indexes, and schemas

    DBMS_STATS gathers, manages, and exports optimizer statistics that the Cost-Based Optimizer uses to generate efficient execution plans for SQL statements.

  5. Which index type is most appropriate for a column with very few distinct values, such as a gender or status flag?

    Answer: Bitmap index

    Bitmap indexes are ideal for low-cardinality columns because they store a bit for each possible value per row, enabling efficient AND/OR operations in analytical queries.

  6. What is the purpose of a database link (DBLINK) in Oracle?

    Answer: To create a connection that allows queries to access objects in a remote Oracle database

    A database link defines a named connection path from a local Oracle database to a remote Oracle database, enabling distributed queries and DML across databases.