SQL And Relational Database Management

39 Questions | Total Attempts: 70

SettingsSettingsSettings
Please wait...
SQL Quizzes & Trivia

This quiz covers chapter 1 of The Practical SQL Handbook.


Questions and Answers
  • 1. 
    A relational Database management system must:Represent all information in the database as _______.
  • 2. 
    A relational Database management system must:Keep the logical representation of data independent from its ________ storage characteristics.
  • 3. 
    A relational Database management system must:Support _____, which allow the user to specify alternative ways of looking at data in tables.
  • 4. 
    A relational Database management system must:Provide a method for differentiating between unknown values (____) and ____ or _____.
  • 5. 
    A relational Database management system must:Support mechanisms for _______ and authorization
  • 6. 
    A relational Database management system must:Support mechanisms for security and ____________.
  • 7. 
    A relational Database management system must:Support the main relational operations (selection, projection, and join) and set operations such as _____, ____________, __________, and __________.
  • 8. 
    A relational Database management system must:Protect data-________ through ___________ and __________ procedures.
  • 9. 
    Most relational databases support features needed in the commercial world: stored ________, _______, and SQL _________.
  • 10. 
    ___ is the language in which one "_______" ________ database.
  • 11. 
    Relational expert C.J. Date gives this informal definition of a relational database management system, or DBMS: It represents all information in the database as ________.It supports the three ________ operations, known as _________, ____________, and _______, for specifying exactly what data you want to see (and it can carry out these operations without requiring the system to store its data _________ in any particular form.
  • 12. 
    Dr. E. F. Codd, the inventor of the relational model has 12 rules that the relational model must meet, known as "Codd's rules".  To be considered fully relational, a relational database management system must:1) Represent all information in the database as ______2) Keep the logical representation of the data independent from its __________ storage characteristics3) Use one ____-level language for structuring, querying, and changing the information in the database4) Support the main relational operations (_________, ______, _____) and set operations such as _______, ____________, _________, and _________.5) Support _____, which allow the user to specify alternative ways of looking at data in tables6) Provide a method for differentiating between unknown values (____) and ____ or ______.7) Support mechanisms for s_______ and a__________8) Protect data integrity through __________ and ________ procedures
  • 13. 
    A primary key is also known as a _______ ____________
  • 14. 
    A unique identifier is also known as a ________ ____.
  • 15. 
    A set of related tables forms a __________
  • 16. 
    Each table consists of a set of _____ and ________.  Each row describes one occurrence of an ______ - a person, a company, a sale or some other thing.  Each column describes one _____________ of the entity -- a person's name or address.
  • 17. 
    Each data element or ______, can be identified as the ___________ of a row and a column.
  • 18. 
    There are two types of tables in a relational database: ______ tables and ________ tables.  ________ tables contain the information.  __________ tables, also known as the _______ catalog contain the database description.
  • 19. 
    You may want to improve performance, efficiency, or ease of use by changing the method by which the system locates the physical data.  These methods are referred to generically as ________ strategies, which often make use of ________.
  • 20. 
    ________ independence means that relationships among tables, columns, and rows can change without impairing the function of application programs and ad hoc (on-the-fly) queries.
  • 21. 
    ________ _____ independence means that the representation of the data - the user's eye view - is completely independent of how the data is physically stored.
  • 22. 
    The definition of a relational system and Codd's rules require that a single language -- sometimes called a ___________ ___ sublanguage -- be able to handle all communications with the database.  In the commercial world of relational database management, that language is ___.
  • 23. 
    SQL is used for three kinds of operations:
    • A. 

      Data Manipulation

    • B. 

      Data definition

    • C. 

      Data administration

    • D. 

      Data projection

    • E. 

      Data Selection

    • F. 

      Data Convergence

  • 24. 
    Every manipulation, definition, or administrative operation is expressed as a SQL ________ or ___________.
  • 25. 
    There are two varieties of ____ _________ operation, collectively called DML, ____ _______ language:Data _________ : finding the particular data you wantData __________: adding, removing, or changing the data
Related Topics
Back to Top Back to top