Revision Quiz

10 Questions | Total Attempts: 127

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

.


Related Topics
Questions and Answers
  • 1. 
    Data integrity constraints are used to:
    • A. 

      Control who is allowed access to the data;

    • B. 

      Ensure that duplicate records are not entered into the table;

    • C. 

      Improve the quality of data entered for a specific property;

    • D. 

      Prevent users from changing the values stored in the table

  • 2. 
    Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
    • A. 

      Entity

    • B. 

      Attribute

    • C. 

      Identifier

    • D. 

      Relationship

  • 3. 
    A logical description of some portion of database that is required by a user to perform task is called as:
    • A. 

      Data View;

    • B. 

      Logical View

    • C. 

      User View

    • D. 

      System View

  • 4. 
    Properties that describe the characteristics of entities are called ………………
    • A. 

      Entities

    • B. 

      Attributes

    • C. 

      Identifiers

    • D. 

      Relationship

  • 5. 
    Which of the following is a reason to model data?
    • A. 

      Understand each user’s perspective of data;

    • B. 

      Understand the data itself irrespective of the physical representation;

    • C. 

      Understand the use of data across application areas;

    • D. 

      All of the above

  • 6. 
    Many- to -many relationships mostly cause problems in database management. Instead of using a composite entity to link the two entities a(n) ____________ can be used to represent the association between two entities.
    • A. 

      Compound table;

    • B. 

      Association class;

    • C. 

      Bridge entity;

    • D. 

      Iterative super key

  • 7. 
    “All key entries must be unique, and no part of the primary key may be null”. The statement refers to ____________:
    • A. 

      Entity integrity

    • B. 

      Primary key;

    • C. 

      Referential integrity;

    • D. 

      Mandatory participation.

  • 8. 
    Multiplicity is the main constraint that exists on a relationship. Which two (2) constraints does it describe?
    • A. 

      Relationship and degree;

    • B. 

      Cardinality and relationship;

    • C. 

      Degree and cardinality;

    • D. 

      Cardinality and participation.

  • 9. 
    If K is a foreign key in a relation R1, then:
    • A. 

      Every tuple of R1 has a distinct value for K;

    • B. 

      K cannot have a null value for tuples in R1;

    • C. 

      K is a key for some other relation;

    • D. 

      K is a Primary key for R1.

  • 10. 
    ____________exists when different versions of the same data appear separately in different places.
    • A. 

      Data decomposition;

    • B. 

      Normalisation;

    • C. 

      Data consistency;

    • D. 

      Data redundancy.