Practice Questions

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