| | | | Question 1 | The correct answer is A. The DB2 Run-Time client provides basic connectivity that allows client workstation users to issue interactive SQL statements that access data stored on a DB2 UDB/DB2 Connect server; the DB2 Administration Client provides basic connectivity, along with the ability to perform administrative operations on DB2 UDB databases that reside on a DB2 UDB/DB2 Connect server; and the DB2 Application Development Client provides basic connectivity, along with a collection of tools and components that can be used to develop, test, and run applications that are designed to interact with databases that reside on DB2 UDB/DB2 Connect servers. | | | | | Question 2 | The correct answer is C. DB2 Connect Enterprise Edition is an add-on product for DB2 UDB that allows data to be moved between Linux, UNIX, and Windows DB2 servers and iSeries- and zSeries-based DB2 servers. Because some editions of DB2 UDB must be installed before DB2 Connect can be used, and because DB2 Connect is needed in this case to provide communications between the Solaris server and the OS/390 client, answers A and B are both wrong. The question states "at a minimum, which...products must be installed..." and since DB2 Universal Database Enterprise Server Edition comes packaged with a limited version of DB2 Connect, DB2 Connect does not need to be installed along with DB2 UDB Enterprise Server Edition, so answer D is also incorrect. | | | | | Question 3 | The correct answer is B. Because DB2 Personal Developer's Edition can only be used to develop applications that work with local databases, and because DB2 Personal Developer's Edition must be used with DB2 Connect Personal Edition, not DB2 Connect Enterprise Edition, answers A and C can be eliminated. And since there is no DB2 Connect Developer's Edition, the correct answer is B. | | | | | Question 4 | The correct answer is C. The DB2 XML Extender contains a set of data types and functions that can be used to store extensible markup language (XML) documents in a DB2 UDB database. The DB2 Audio, Video, and Image (AVI) Extender contains a set of data types and functions that can be used to store and manipulate nontraditional data such as audio clips, movies, and pictures in a DB2 UDB database; the DB2 Text Extender contains a set of data types and functions that can be used to store complex text documents in a DB2 UDB database and to extract key information from such documents; and the DB2 Spatial Extender contains a set of user-defined data types that can be used to describe spatial data (for example, points, lines, and polygons) and a set of user -defined functions that can be used to query spatial objects (for example, to find area, endpoints, and intersects). | | | | | Question 5 | The correct answer is D. The Development Center is an interactive GUI application that can be used to create, build, debug , and deploy stored procedures, structured data types, and user-defined functions. | | | | | Question 6 | The correct answers are B and E. The DB2 Warehouse Manager extracts , transforms, and loads data into a data warehouse. | | | | | Question 7 | The correct answers are A and C. The Control Center presents a clear, concise view of an entire system and it serves as the central point for managing systems and performing common administration tasks. The Command Line Processor (CLP) is a text-oriented application that allows users to issue DB2 UDB commands, system commands, and SQL statements, as well as view the results of the statements/commands executed. Because the administrative tasks that can be performed with the Control Center have corresponding DB2 UDB commands, both the Control Center and the Command Line Processor can be used to perform administrative tasks against a database and its objects. | | | | | Question 8 | The correct answer is D. The Task Center is an interactive GUI application that allows users to schedule tasks, run tasks, and send notifications about completed tasks to other users. Because a task can be generated by saving the results from the Backup Database wizard, the Task Center can be used to automate backup operations. | | | | | Question 9 | The correct answer is A. The Journal is an interactive GUI application that tracks historical information about tasks, database actions and operations, Control Center actions, messages, and alerts; the Messages view of the Journal shows a running history of messages that were issued from the Control Center as well as any other GUI tool. | | | | | Question 10 | The correct answer is C. Visual Explain is a GUI application that allows users to view the details of the access plan (including the statistics in the system catalogs) chosen by the DB2 optimizer for a given SQL statement without actually executing the statement. This information allows users to quickly view the statistics that were used at the time a particular query was optimized and determine, among other things, whether or not an index would improve access to a table, which in turn would improve query performance. |  |
