Practice Test GeeksICT - Information Communication Technology Practice Test
← All ICT Flashcard Decks

Database Management Concepts Flashcards

7 cards from real ICT 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 Management Concepts flashcards as text

  1. Which SQL clause is used to filter records after a GROUP BY operation?

    Answer: HAVING

    HAVING filters grouped results, while WHERE filters rows before grouping occurs.

  2. What does ACID stand for in database transactions?

    Answer: Atomicity, Consistency, Isolation, Durability

    ACID properties ensure reliable database transactions: Atomicity, Consistency, Isolation, and Durability.

  3. Which type of join returns only rows where there is a match in both tables?

    Answer: INNER JOIN

    An INNER JOIN returns only the rows that have matching values in both joined tables.

  4. What is a foreign key in a relational database?

    Answer: A column that references the primary key of another table

    A foreign key is a field in one table that refers to the primary key in another table, establishing a relationship.

  5. Which normal form eliminates transitive functional dependencies?

    Answer: Third Normal Form (3NF)

    3NF removes transitive dependencies, ensuring non-key attributes depend only on the primary key.

  6. What is the purpose of an index in a database?

    Answer: To speed up data retrieval operations

    An index creates a data structure that allows the database engine to find rows faster without scanning the entire table.

  7. Which SQL command removes all rows from a table but keeps its structure?

    Answer: TRUNCATE

    TRUNCATE removes all rows from a table quickly without logging individual row deletions, but preserves the table structure.