Db2 Mock Test 3

10 Questions | Total Attempts: 1743
SettingsSettingsSettings
Please wait...
or Create Online Test
Mock Test Quizzes & Trivia
More Mock Test Quizzes
Kt And Ra Mock Question Kt And Ra Mock Question
Mock Test 1b Mock Test 1b
California Private Patrol Operator Ppo License Test California Private Patrol Operator Ppo License Test
Featured Quizzes
Quiz: The Best Pokemon Picker! Quiz: The Best Pokemon Picker!
Which Harry Potter Hogwarts House Do You Belong To Quiz? Which Harry Potter Hogwarts House Do You Belong To Quiz?
This Is The Easiest Quiz You'll Take In Your Life! This Is The Easiest Quiz You'll Take In Your Life!
Related Topics
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

Back to Top Back to top