Practice Test GeeksIKM - International Knowledge Measurement Practice Test
← All IKM Flashcard Decks

Database Administration Concepts Flashcards

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

Read the first 6 Database Administration Concepts flashcards as text

  1. What is a Write-Ahead Log (WAL)?

    Answer: Records all changes before they are written to data files

    WAL records modifications before applying them to data files, enabling crash recovery.

  2. Which isolation level prevents dirty reads but allows non-repeatable reads?

    Answer: Read Committed

    Read Committed prevents dirty reads but allows non-repeatable reads.

  3. What is a materialized view?

    Answer: Physically stored query result that must be refreshed

    A materialized view stores the query result physically, requiring periodic refresh.

  4. What is the CAP theorem?

    Answer: A distributed system can guarantee at most two of Consistency, Availability, Partition tolerance

    CAP states a distributed system cannot simultaneously provide all three: Consistency, Availability, Partition tolerance.

  5. What is the purpose of a foreign key constraint?

    Answer: Enforce referential integrity between tables

    Foreign keys ensure values in one table match existing values in the referenced table.

  6. What is the difference between horizontal and vertical scaling?

    Answer: Horizontal adds more servers; vertical adds resources to existing servers

    Vertical scaling adds more CPU/RAM; horizontal scaling adds more servers.