Sessional 2

20 Questions | Total Attempts: 60

SettingsSettingsSettings
Please wait...
Spring Quizzes & Trivia

CSC271 - Database Systems, Spring 2010


Questions and Answers
  • 1. 
    By ___________, we mean known facts that can be recorded and that have implicit meaning.
    • A. 

      Information

    • B. 

      Database

    • C. 

      Data

    • D. 

      Constraints

  • 2. 
    Change in schema is known as schema
    • A. 

      Constraints

    • B. 

      Invalid State

    • C. 

      Intention

    • D. 

      Evolution

  • 3. 
    Constraints that can not be expressed directly in the schema are called
    • A. 

      Domain Constraints

    • B. 

      Implicit Constraints

    • C. 

      Semantic Constraints

    • D. 

      Relational Constraints

  • 4. 
    Database state changes very _____________.
    • A. 

      Often

    • B. 

      Rarely

    • C. 

      Constantly

    • D. 

      Exponentially

  • 5. 
    Each object in schema is called ___________.
    • A. 

      Entity

    • B. 

      Relationship

    • C. 

      Schema Construct

    • D. 

      Relation

  • 6. 
    The data in the database at a particular moment in time is called a database ____________ .
    • A. 

      Schema

    • B. 

      State

    • C. 

      Query

    • D. 

      Transaction

  • 7. 
    _________ represents a real-world object or concept.
    • A. 

      Attribute

    • B. 

      Relationship

    • C. 

      Association

    • D. 

      Entity

  • 8. 
    _________ represents some property of interest that further describes an object or concept.
    • A. 

      Relationship

    • B. 

      Entity

    • C. 

      Attribute

    • D. 

      Tuple

  • 9. 
    Network, hierarchical and relational data models are the examples of ____________ data models.
    • A. 

      Conceptual

    • B. 

      Implementation

    • C. 

      Logical

    • D. 

      Global

  • 10. 
    The UPDATE operation can violate which of the following constraints?
    • A. 

      All Four

    • B. 

      RI and Key

    • C. 

      All Five

    • D. 

      All Three

  • 11. 
    In ER Model, the key attribute of a weak entity is called ________.
    • A. 

      Candidate Key

    • B. 

      Primary Key

    • C. 

      Partial Key

    • D. 

      Foreign Key

  • 12. 
    In order for a database to be accurate and reliable at all time, it must be a true reflection of the __________ that it represents.
    • A. 

      User Requirements

    • B. 

      Mini-world

    • C. 

      Company Database

    • D. 

      ER Diagram

  • 13. 
    The key attribute of any entity must be the part of a composite attribute.
    • A. 

      True

    • B. 

      False

  • 14. 
    The relational model represents the database as a collection of ___________ .
    • A. 

      Files

    • B. 

      Databases

    • C. 

      Relations

    • D. 

      Entities

  • 15. 
    In Relational Data Model, the degree of a relation is _________.
    • A. 

      # of Entities

    • B. 

      # of Relationships

    • C. 

      # of Tuples

    • D. 

      # of Attribute

  • 16. 
    A database state that does not obey all integrity constraints is in ___________ .
    • A. 

      Initial State

    • B. 

      Run-time State

    • C. 

      Invalid State

    • D. 

      Valid State

  • 17. 
    The Super Key (SK) must always be a composite key.
    • A. 

      True

    • B. 

      False

  • 18. 
    A relational database schema is a set of relational schema and a set of _______________.
    • A. 

      Relationships

    • B. 

      Attributes

    • C. 

      Integrity Constraints

    • D. 

      Key Constraints

  • 19. 
    Relational Data Model contains the main concepts of ___________.
    • A. 

      Domain, Attribute

    • B. 

      Domain, Attribute, Tuple, Relation

    • C. 

      Domain, Attribute, Relation

    • D. 

      Domain, Attribute, Tuple

  • 20. 
    The current version of SQL specifications is ______________ .
    • A. 

      SQL2005

    • B. 

      SQL99

    • C. 

      SQL2000

    • D. 

      SQL82