DB2 Universal Database V8.1 Certification Exam 700 Study Guide

Question 1

Which of the following is the best client to use to allow users to execute ad-hoc queries, using the Command Line Processor, that retrieve data from a DB2 UDB server?

  • A. DB2 Run-Time Client

  • B. DB2 Administration Client

  • C. DB2 Application Development Client

  • D. DB2 CLP Support Client

Question 2

A client application on OS/390 must access a DB2 UDB database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

  • A. DB2 Connect Enterprise Edition

  • B. DB2 UDB Workgroup Server Edition

  • C. DB2 UDB Workgroup Server Edition and DB2 Connect Enterprise Edition

  • D. DB2 UDB Enterprise Server Edition and DB2 Connect Enterprise Edition

Question 3

A developer needs to build an application on a Linux workstation that will access a database on an OS/400 server. At a minimum, which of the following products must be installed on the Linux workstation?

  • A. DB2 Personal Developer's Edition

  • B. DB2 Universal Developer's Edition

  • C. DB2 Personal Developer's Edition and DB2 Connect Enterprise Edition

  • D. DB2 Connect Developer's Edition

Question 4

Which of the following products is used to manage extensible markup language documents?

  • A. DB2 AVI Extender

  • B. DB2 Text Extender

  • C. DB2 XML Extender

  • D. DB2 Spatial Extender

Question 5

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

  • A. SQL Assist

  • B. Control Center

  • C. Command Center

  • D. Development Center

Question 6

Which two of the following are performed by the DB2 Warehouse Manager?

  • A. Query

  • B. Extraction

  • C. Categorization

  • D. Replication

  • E. Transformation

Question 7

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

  • A. Control Center

  • B. Command Center

  • C. Command Line Processor

  • D. Task Center

  • E. Health Center

Question 8

Which of the following tools is used to automate backup operations?

  • A. Control Center

  • B. Command Center

  • C. Command Line Processor

  • D. Task Center

Question 9

Which of the following maintains a history of all warnings and errors generated by the Control Center?

  • A. Journal

  • B. Health Center

  • C. Information Center

  • D. Visual Explain

Question 10

Which of the following tools can be used to determine if the creation of an index will improve query performance?

  • A. Control Center

  • B. SQL Assist

  • C. Visual Explain

  • D. Development Center

Related

Категории