Practice Test Geeks(AMCAT) Aspiring Minds Computer Adaptive Test Practice Test
← All AMCAT Flashcard Decks

Computer Science: DBMS Concepts Flashcards

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

Read the first 6 Computer Science: DBMS Concepts flashcards as text

  1. Which normal form eliminates transitive dependencies?

    Answer: 3NF

    Third Normal Form (3NF) eliminates transitive dependencies where a non-key attribute depends on another non-key attribute.

  2. What does ACID stand for in database transactions?

    Answer: Atomicity, Consistency, Isolation, Durability

    ACID = Atomicity (all or nothing), Consistency (valid state), Isolation (concurrent transactions behave serially), Durability (committed data persists).

  3. Which SQL clause is used to filter groups after a GROUP BY?

    Answer: HAVING

    HAVING filters groups formed by GROUP BY, whereas WHERE filters individual rows before grouping.

  4. Which join returns all rows from both tables, with NULLs where there is no match?

    Answer: FULL OUTER JOIN

    FULL OUTER JOIN returns all rows from both tables, filling NULLs where there is no matching row in the other table.

  5. What is the purpose of a foreign key?

    Answer: To enforce referential integrity between tables

    A foreign key enforces referential integrity so that values reference existing rows in the related table.

  6. Which of the following is NOT a type of database index?

    Answer: Loop index

    B-Tree, Hash, and Clustered are all real index types. 'Loop index' is not a database index type.