Know-IT-All Chapter Quiz: SQL concepts & facilities

Think you know all there is to know about SQL? We challenge you to test your skills by taking our latest quiz. All answers to this quiz are found in the free excerpt. It is best to copy and paste the answer into the box. Good luck!

  1. SQL is a query language for end users. True or false?

    Your answer:

    See book excerpt for answer

  2. Triggers are implemented via the SQL language and the DB2 UDB database. True or false?

    Your answer:

    See book excerpt for answer

  3. SQL basic facilities include:
    a. table facility, table editor, query facility
    b. table facility, table editor
    c. SQL facility, table query
    Your answer:

    See book excerpt for answer

  4. The SQL name is log, the System 5 name is:
    a. journal
    b. job
    c. book

    Your answer:

    See book excerpt for answer


  5. A relational database is a database that is perceived by its users to be a collection of tables. True or false?

    Your answer:

    See book excerpt for answer

  6. CRTPF is short for:
    a. create physical file
    b. create real table physical file
    c. both above options are correct

    Your answer:

    See book excerpt for answer

  7. DDS and SQL's capabilities are virtually the same. True or false?

    Your answer:

    See book excerptfor answer

  8. DML is short for:
    a. Data Manual Language
    b. Decimal Manipulation Language
    c. Data Manipulation Language

    Your answer:

    See book excerpt for answer

  9. The function is "Select verb starts the statement." What is the command?
    a. start
    b. select
    c. from

    Your answer:

    See book excerpt for answer

  10. What does DCL stand for?
    a. Decimal Control Language
    b. Basic SQL Data Control Language
    c. Data Capacity Language

    Your answer:

    See book excerpt for answer




    11. This was first published in April 2006

Back to top