Practice Test GeeksSQL Practice Test
← All SQL Flashcard Decks

General Concepts Flashcards

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

Read the first 7 General Concepts flashcards as text

  1. What does ACID stand for in database transactions?

    Answer: Atomicity, Consistency, Isolation, Durability

    ACID describes the four properties guaranteeing reliable transactions.

  2. Which command permanently saves a transaction's changes?

    Answer: COMMIT

    COMMIT makes all changes in a transaction permanent.

  3. What does the LIKE operator do in a WHERE clause?

    Answer: Matches a pattern in text

    LIKE performs pattern matching using wildcards such as % and _.

  4. Which wildcard in LIKE matches any sequence of characters?

    Answer: %

    The % wildcard matches zero or more characters in a LIKE pattern.

  5. What does a normalized database aim to reduce?

    Answer: Data redundancy

    Normalization organizes data to minimize redundancy and improve integrity.

  6. Which statement changes existing rows in a table?

    Answer: UPDATE

    UPDATE modifies existing rows based on a condition.

  7. What does the ORDER BY clause control?

    Answer: The sort order of results

    ORDER BY sorts the result set in ascending or descending order.