Db2 Basics, Part 1

50 Questions | Total Attempts: 71

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Questions and Answers
  • 1. 
    A ________ may contain multiple ________ (each behaving like a separate installation of DB2), and an instance can control multiple ________.
  • 2. 
    A DB2 ________ manages the storage, modification, and retrieval of data.
  • 3. 
    A DB2 database is a collection of related ________.
  • 4. 
    A DB2 database may be created with the
    • A. 

      DEFINE DATABASE command

    • B. 

      Create Database wizard

    • C. 

      CREATE DATABASE command

  • 5. 
    A DB2 database is implicitly ________ as soon as it is created.
  • 6. 
    A DB2 database can be explicitly cataloged using any of these 3 methods:      the ________ Center      the ________ Assistant      the ________ ________ command 
  • 7. 
    The ________ statement deletes existing database objects when they are no longer needed.
  • 8. 
    Any of the DB2 database objects is created using the _________ statement.
  • 9. 
    Which of the following is NOT a numeric data type?
    • A. 

      BINARY

    • B. 

      SMALLINT

    • C. 

      NUMERIC

    • D. 

      DOUBLE

    • E. 

      REAL

  • 10. 
    Which of the following is NOT a numeric data type?
    • A. 

      DECIMAL

    • B. 

      FLOAT

    • C. 

      LARGEINT

    • D. 

      DOUBLE PRECISION

    • E. 

      BIGINT

  • 11. 
    Which of the following is NOT a character data type?
    • A. 

      CHARACTER

    • B. 

      CLOB

    • C. 

      LONG VARCHAR

    • D. 

      DOUBLE CHARACTER

    • E. 

      CHARACTER VARYING

  • 12. 
    An equivalent term for CHARACTER VARYING is ________.
  • 13. 
    An equivalent term for CHARACTER LARGE OBJECT is ________.
  • 14. 
    The double-byte character data types (in alpha order) are ________, ________, ________, ________.
  • 15. 
    The date and time data types (in alpha order) are ________, _______, ________.
  • 16. 
    The binary and XML data types (in alpha order) are ________, _______.
  • 17. 
    Execution of an SQL statement in a basic client/server environment:      SQL statement is sent through a ________ from the ________ workstation to a database ________.      The database ________ processes the statement.      The results are sent back through the ________ to the ________. 
  • 18. 
    For every SQL statement executed, how many messages must go through the network?
  • 19. 
    Focus of client/server development:      Place the application logic on one or more ________.      Place the code that interacts directly with a database on a ________. 
  • 20. 
    Structured Query Language (SQL) is a standardized language used to work with ________ ________ and the ________ they contain.
  • 21. 
    SQL is a procedural programming language.
    • A. 

      True

    • B. 

      False

  • 22. 
    When using the WHERE clause predicate LIKE, the metacharacter (wildcard) "_" represents any single alphanumeric character.
    • A. 

      True

    • B. 

      False

  • 23. 
    When using the WHERE clause predicate LIKE, the metacharacter (wildcard) "%" represents any single alphanumeric character.
    • A. 

      True

    • B. 

      False

  • 24. 
    The searched update uses one of the normal forms of the UPDATE statement.  The positioned update uses a ________.
  • 25. 
    When using a positioned update, the UPDATE statement must contain a ________________ [CursorName] clause.
Related Topics
Back to Top Back to top