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. What is the role of a Database Administrator (DBA)?

    Answer: Designing, maintaining, and securing the database system

    A DBA is responsible for installing, configuring, upgrading, monitoring, and securing database systems.

  2. Which type of relationship in an ER diagram means one record in Table A can relate to many records in Table B?

    Answer: One-to-many

    A one-to-many relationship means a single record in one table can be associated with multiple records in another table.

  3. What is a stored procedure in a database?

    Answer: A precompiled set of SQL statements stored in the database

    A stored procedure is a prepared SQL code saved in the database that can be reused by calling it by name.

  4. Which property of a transaction ensures that once committed, changes survive system failures?

    Answer: Durability

    Durability guarantees that committed transactions are permanently saved even if the system crashes immediately after.

  5. What does SQL stand for?

    Answer: Structured Query Language

    SQL stands for Structured Query Language, the standard language for managing and querying relational databases.

  6. In database design, what is an entity?

    Answer: A real-world object or concept represented in the database

    An entity is any real-world object, person, place, or concept about which data is stored in the database.

  7. What is the purpose of the ROLLBACK statement in SQL?

    Answer: To undo all changes made during the current transaction

    ROLLBACK reverts all changes made within the current transaction, restoring the database to its previous state.