Alien head

Simple IBM DB2 Quiz

Description: Simple IBM DB2 Quiz
Number of Questions: 8
Created by:
Tags: db2

Which of the following is NOT a characteristic of a data warehouse?

db2
  1. Sub-second response time

  2. Heterogeneous data sources

  3. Voluminous historical data

Answer: 1

Which of the following tools can be used to automate table reorganization operations?

db2
  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center

Answer: 4

Which of the following tasks can NOT be performed using the Developer Workbench?

db2
  1. Develop and debug an SQL stored procedure

  2. Develop and debug a user-defined data type

  3. Develop and debug a user-defined function

  4. Develop and run XML queries

Answer: 2

Which of the following allow you to perform administrative tasks against database objects?

db2
  1. Control Center

  2. Journal

  3. Task Center

  4. Health Center

Answer: 1

Which of the following allow you to perform administrative tasks against database objects?

db2
  1. Control Center

  2. Journal

  3. Task Center

  4. Health Center

Answer: 1

Which of the following DB2 tools allows a user to set DB2 registry parameters?

db2
  1. Task Center

  2. Visual Explain

  3. Configuration Assistant

  4. Satellite Administration Center

Answer: 3

Which of the following is used to create and debug user-defined functions?

db2
  1. SQL Assist

  2. Control Center

  3. Command Editor

  4. Developer Workbench

Answer: 4

Which of the following tools can be used to catalog a database?

db2
  1. Visual Explain

  2. Alert Center

  3. Journal

  4. Configuration Assistant

Answer: 1
+ View questions