Db2 Mock Test 3

10 Questions

Settings
Mock Test Quizzes & Trivia

Questions and Answers
  • 1. 
    What is the collection of data designed to be used by different people is called
    • A. 

      File

    • B. 

      Database

    • C. 

      Table

  • 2. 
    DB2 is
    • A. 

      Relational Database Management system

    • B. 

      D) Programming language

    • C. 

      ) Database

  • 3. 
    What are the aggregate functions supported by DB2 ?  
    • A. 

      SUM, MAX, MIN, AVG and COUNT

    • B. 

      SUM and AVG

    • C. 

      NONE

  • 4. 
    EXPLAIN allows the user to obtain information regarding the optimizer’s choice of access strategy for a given SQL statements
    • A. 

      True

    • B. 

      False

  • 5. 
    SELECT * FROM ………. will  retrieve all columns of the table meeting the selection criteria .
    • A. 

      True

    • B. 

      False

  • 6. 
    How does the defining of a stored procedure affect the size of a DB2 database?
    • A. 

      It decreases the size of the database.

    • B. 

      It increases the size of the database.

    • C. 

      It does not affect the size of the database. It does not affect the size of the database

  • 7. 
    Which authority can be granted to a group of users using the GRANT statement?
    • A. 

      SYSCTRL

    • B. 

      DBCTRL

    • C. 

      SYSADM

  • 8. 
    Given the statement      CREATE TABLE userid.test (      date_taken   DATE NOT NULL,      number       SMALLINT NOT NULL,      PRIMARY KEY (number))
    • A. 

      Userid

    • B. 

      Number

    • C. 

      Test

  • 9. 
    Which system catalog view can be used to determine when a bind      operation was performed on a given package?
    • A. 

      SYSCAT.PACKAGES

    • B. 

      SYSCAT.TIMESTAMP

    • C. 

      SYSCAT.ACCESSPLAN

  • 10. 
    Which type of cursor should be used so that its position will be     maintained between transactions?
    • A. 

      FOR FETCH

    • B. 

      FOR UPDATE

    • C. 

      WITH HOLD