Lesson 8

    Cards (23)

    • What is the primary function of a DBMS?
      Interface between OS and user for data access
    • What are the main functions of a DBMS?
      Data storage, retrieval, and update
    • How does a DBMS simplify data access for users?
      By hiding the internal structure of the database
    • What does a DBMS allow users to do with data?
      Store, retrieve, and update information
    • What is the purpose of a data dictionary in a DBMS?
      To maintain metadata about the database
    • What is a key function of DBMS regarding security?
      Handle password allocation and checking
    • How do user database views work in a DBMS?
      They provide different access levels to users
    • What might a receptionist in a hospital see in a DBMS?
      Patient name and address, not medical info
    • What is a range check in data validation?
      Ensures input data lies within a specific range
    • What does a presence check do?
      Prevents progress if a required field is blank
    • What is a format check used for?
      To ensure data matches a specific pattern
    • What does a data type check ensure?
      Input data is of a particular data type
    • What is the purpose of a length check?
      To ensure input data string is sensible length
    • What is 'Restricted' validation in databases?
      Limits data entry to specific valid choices
    • What is verification in data entry?
      Checking entered data matches intended data
    • How is verification typically performed?
      By comparing data with another copy
    • What is referential integrity in databases?
      Ensures foreign keys correspond to primary keys
    • What happens if referential integrity is violated?
      Errors occur when foreign keys are invalid
    • What information does a Data Dictionary hold?
      • Information about every table in the database
      • Information about every field in the database
      • Characteristics of each data item (length, type)
      • Restrictions on column values (validation rules)
      • Relationships between data items
      • Programs accessing data and their permissions
    • What is the role of a DB Administrator regarding user access?
      Assigns different access levels to users
    • How does a DBMS handle backup and recovery?
      Provides ability to recover database after failure
    • What is the significance of 'Not Null' fields in a database?
      Records can't be added without data in those fields
    • What is the purpose of input masks in format checks?
      To create specific patterns for data entry
    See similar decks