Practice Test Geeks(DIS) Digital Imaging Specialist Certification Practice Test
← All DIS Flashcard Decks

Database Administration Flashcards

7 cards from real DIS 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 Administration flashcards as text

  1. In a digital imaging database, which indexing strategy best supports range queries on image capture dates?

    Answer: B-tree index

    B-tree indexes maintain sorted order, making them ideal for range queries on date fields.

  2. A DIS database stores EXIF metadata alongside image files. Which normal form violation occurs when camera model and manufacturer are stored in the same image record without a separate camera table?

    Answer: 3NF

    Storing manufacturer derived from camera model in the same table violates 3NF due to a transitive dependency.

  3. Which PostgreSQL feature allows querying image metadata stored as JSON without extracting it into separate columns?

    Answer: JSONB operators

    PostgreSQL's JSONB operators like -> and ->> allow direct querying of JSON fields without restructuring the schema.

  4. When archiving high-resolution images, a DBA implements table partitioning by year. What is the primary benefit for query performance?

    Answer: Enables partition pruning to scan only relevant data

    Partition pruning allows the query planner to skip irrelevant partitions entirely, reducing I/O for date-filtered queries.

  5. A digital imaging database uses a connection pool. What happens when all pool connections are in use and a new request arrives?

    Answer: The request waits in queue until a connection is released

    Connection pools queue incoming requests until an active connection is returned to the pool.

  6. In the context of DIS certification, what does ACID stand for in database transactions?

    Answer: Atomicity, Consistency, Isolation, Durability

    ACID defines the four properties that guarantee reliable database transactions: Atomicity, Consistency, Isolation, and Durability.

  7. A DBA notices that a query retrieving thumbnail paths for a specific photographer is performing a full table scan despite an index on photographer_id. What is the most likely cause?

    Answer: Statistics are stale and the planner underestimates selectivity

    Stale statistics cause the query planner to misjudge row counts, sometimes choosing a full scan over an index seek.