Access & SQL - Quiz 1

15 Questions | Attempts: 192
Share

SettingsSettingsSettings
SQL Quizzes & Trivia

This quiz consists of 10 questions. You have 10 minutes to take the quiz.


Questions and Answers
  • 1. 
    Which of the following is NOT one of the three phases for Database Design phase?
    • A. 

      A) Global Database Design

    • B. 

      B) Conceptual Database Design

    • C. 

      C) Logical Database Design

    • D. 

      D) Physical Database Design

  • 2. 
    Application Design phase includes two important activities, which are ______________ and user interface design.
    • A. 

      A) table design

    • B. 

      B) transaction design

    • C. 

      C) data design

    • D. 

      D) user view design

  • 3. 
    Which of the following is NOT one of transaction types mentioned in class?
    • A. 

      A) Retrieval transaction

    • B. 

      B) Update transaction

    • C. 

      C) Group transaction

    • D. 

      D) Mixed transaction

  • 4. 
    Which is not one of the evaluation criteria during testing phase?
    • A. 

      A) Learnability

    • B. 

      b) Performance

    • C. 

      C) Robustness

    • D. 

      D) Creativity

  • 5. 
    Which of the following is an advantage of using the DBMS approach?
    • A. 

      A) Enforcing integrity constraints

    • B. 

      B) Increasing data redundancy

    • C. 

      C) Providing single user interface for different types of users

    • D. 

      D) Allowing unauthorized access

  • 6. 
    Which of the following is NOT a typical DBMS functionality?
    • A. 

      A) Manipulating the database

    • B. 

      B) Manage the user interface of database application

    • C. 

      C) Define a particular database in terms of its data types, structures and constraints

    • D. 

      D) Processing and sharing by a set of concurrent users and application programs

  • 7. 
    When taking the centralized approach for Requirement Collection and Analysis phase, we create local data models for each user view.
    • A. 

      True

    • B. 

      False

  • 8. 
    Data model comprises all of the following, except _________
    • A. 

      A) a structural part

    • B. 

      B) a manipulative part

    • C. 

      C) a set of integrity rules

    • D. 

      D) a managerial part

  • 9. 
    ______________ refers to a minimal set of attributes that uniquely identifies each occurrence of an entity.
    • A. 

      A) Composite Key

    • B. 

      B) Primary Key

    • C. 

      C) Candidate Key

    • D. 

      D) Super Key

  • 10. 
    Entity Relationship Model is a type of Objec-based data model
    • A. 

      True

    • B. 

      False

  • 11. 
    Database System includes database management system, data, and applications.
    • A. 

      True

    • B. 

      False

  • 12. 
    The description of data within the database system is called mega-data.
    • A. 

      True

    • B. 

      False

  • 13. 
    DBMS provides insulation between program and data. This is referred to as _______________
    • A. 

      A) program-data independence

    • B. 

      B) program-data dependence

    • C. 

      C) database-data dependence

    • D. 

      D) program-database independence

  • 14. 
    When we say a relationship is 1 to 1, or 1 to many, we are referring to the modality (participation).
    • A. 

      True

    • B. 

      False

  • 15. 
    Record-based data model includes relational data model, network data model,and hierarchical data model.
    • A. 

      True

    • B. 

      False

Related Topics

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.