DB2 9 Fundamentals: Certification Study Guide
| 1. | Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?
| |
| 2. | Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
| |
| 3. | Which of the following DB2 products can only be installed on a System i server?
| |
| 4. | What is the purpose of the Design Advisor?
| |
| 5. | Which of the following DB2 tools allows a user to set DB2 registry parameters?
| |
| 6. | What is the SQL Performance Monitor used for?
| |
| 7. | Which of the following tasks can NOT be performed using the Developer Workbench?
| |
| 8. | Which of the following tools can be used to automate table reorganization operations?
| |
| 9. | Which of the following can be viewed with the Journal?
| |
| 10. | Which of the following is NOT a characteristic of an OLTP database?
| |
| 11. | Which of the following is NOT a characteristic of a data warehouse?
| |
| 12. | Which of the following products is used to shred extensible markup language documents?
| |
| 13. | Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?
| |
| 14. | Which of the following is true about XML columns?
| |
| 15. | Which of the following is the major difference between relational data and XML data?
| |
Answers
| 1. | The correct answer is B. DB2 Express Edition (or DB2 Express) is an entry-level data server that is designed to be used on microcomputers that have up to two CPUs (a dual-core processor is treated as a single CPU), up to 4 GB of memory, and are running a supported version of Linux, Solaris, or Windows. DB2 Everyplace is a small footprint (approximately 350 KB) relational database and a high performance data synchronization solution that allows enterprise applications and data to be extended to mobile devices like personal digital assistants (PDAs), handheld personal computers (HPCs), and smart phones; DB2 Workgroup Server Edition (WSE) is a multi-user, full-function, client/server database management system designed to be used on microcomputers that have up to four CPUs, up to 16 GB of memory, and are running any of the following operating systems: AIX, HP-UX, Solaris, Linux, and Windows; and DB2 Enterprise Server Edition (ESE) is a multi-user, full-function, Web-enabled client/server database management system that is designed to be used on any size server (from one to hundreds of CPUs) that is running any of the following operating systems: AIX, HP-UX, Solaris, Linux, and Windows. |
| 2. | The correct answer is D. DB2 Enterprise Server Edition (ESE) is designed to be used on a server that is running any of the following operating systems: AIX, HP-UX, Solaris, Linux, and Windows. DB2 Express-C is designed to be used on microcomputers that are running a supported version of Linux or Windows; DB2 Express is designed to be used on microcomputers that are running a supported version of Linux, Solaris, or Windows; and DB2 Personal Edition can be deployed on any Personal Computer (PC) that is running Linux or Windows. |
| 3. | The correct answer is B. DB2 for i5/OS is an advanced, 64-bit relational database management system that leverages the On-Demand capabilities of System i to quickly respond to changing workloads. DB2 for z/OS is a multi-user, full-function, database management system that has been designed specifically for z/OS, IBM's flagship mainframe operating system. DB2 Data Warehouse Edition (DWE) is comprised of, among other things, DB2 Enterprise Server Edition and the DB2 Data Partitioning Feature - DB2 Enterprise Server Edition (ESE) is designed to be used on a server that is running any of the following operating systems: AIX, HP-UX, Solaris, Linux, and Windows. |
| 4. | The correct answer is A. The Design Advisor is a special tool that is designed to capture specific information about typical workloads (queries or sets of SQL operations) performed against your database and recommend changes based upon the information provided. When given a set of SQL statements in a workload, the Design Advisor will make recommendations for new indexes, new materialized query tables (MQTs), conversions of base tables to multi-dimensional clustering (MDC) tables, redistribution of table data, and deletion of indexes and MQTs that are not being used by the workload specified. Visual Explain is used to present a graphical representation of a data access plan but it does not recommend design changes; the Replication Center allows users to administer data replication between a DB2 database and any other relational database; and the Configuration Assistant allows users to configure clients so they can access databases stored on remote DB2 servers. |
| 5. | The correct answer is C. The Configuration Assistant is an interactive GUI application that allows users to configure clients so they can access databases stored on remote DB2 servers. From the Configuration Assistant, users can: catalog new databases, work with or uncatalog existing databases, bind applications, set DB2 environment/registry variables, configure the DB2 Database Manager instance, configure ODBC/CLI parameters, import and export configuration information, change passwords, and test database connections. The Task Center allows users to schedule tasks, run tasks, and send notifications about completed tasks to other users; Visual Explain provides database administrators and application developers with the ability to view a graphical representation of the access plan that has been chosen by the DB2 Optimizer for a particular SQL statement; and the Satellite Administration Center is a GUI application that allows users to set up and administer a group of DB2 servers that perform the same business function. |
| 6. | The correct answer is D. If you are running DB2 for i5/OS, the SQL Performance Monitor is a valuable tool that can be used to keep track of the resources SQL statements use. The Health Monitor is a server-side tool that constantly monitors the health of a DB2 Database Manager instance without a need for user interaction; SQL Assist is an interactive GUI application that allows users to visually construct complex SELECT,INSERT,UPDATE, and DELETE SQL statements and examine the results of their execution; and the Task Center is allows users to schedule tasks, run tasks, and send notifications about completed tasks to other users. |
| 7. | The correct answer is B. The Developer Workbench is a comprehensive development environment that can be used to create, edit, debug, deploy, and test DB2 stored procedures and user-defined functions. The Developer Workbench can also be used to develop SQLJ applications, and to create, edit, and run SQL statements and XML queries (XQuery expressions). |
| 8. | The correct answer is D. The Task Center allows users to schedule tasks, run tasks, and send notifications about completed tasks to other users. Users can create a task within the Task Center, generate a task by saving the results from a DB2 dialog or wizard, create a script within another tool and save it to the Task Center, or import an existing script. Thus, it is possible to create a script that calls the REORG command and have the Task Center to execute that script on a routine basis. |
| 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 License Center allows users to view information about the license associated with each DB2 9 product installed on a particular system; Visual Explain provides database administrators and application developers with the ability to view a graphical representation of the access plan that has been chosen by the DB2 Optimizer for a particular SQL statement; and the Health Center is used to select the instance and database objects that you want to monitor, customize the threshold settings of any health indicator, and specify where notifications are to be sent and what actions are to be taken if an alert is issued. |
| 10. | The correct answer is C. OLTP systems are designed to support day-to-day, mission-critical business activities such as order entry, stock trading, inventory management, and banking. This typically involves hundreds to thousands of users issuing millions of transactions per day against databases that vary in size. Response time requirements tend to be sub-second and workloads tend to be a mix of real-time DML operations (inserts, updates, and deletes). Workloads in a data warehouse can consist of bulk load operations, short running queries, long running complex queries, random queries, occasional updates to data, and the execution of online utilities. Thus, data warehouses are optimized for queries. |
| 11. | The correct answer is D. Data Warehousing involves storing and managing large volumes of data (often historical in nature) that is used primarily for analysis. Workloads in a data warehouse vary; they can consist of bulk load operations, short running queries, long running complex queries, random queries, occasional updates to data, and the execution of online utilities. OLTP workloads, on the other hand, tend to be a mix of real-time DML operations (inserts, updates, and deletes) and often require sub-second end-user response time. |
| 12. | The correct answer is C. The DB2 XML Extender can be used to decompose (shred) XML elements from a document and store them in columns and tables; it can also compose (create) new XML documents from existing character and numerical data or previously shredded XML documents. (If the DB2 XML extender is not used, XML documents are stored hierarchically in columns with the XML data type.) 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). |
| 13. | The correct answer is C. 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). With this capability, you can generate, analyze, and exploit spatial information about geographic features, such as the locations of office buildings or the size of a flood zone and present it in a three-dimensional format. The DB2 Geodetic Extender contains a set of user-defined data types and functions that treat the Earth like a globe rather than a flat map (it can construct a virtual globe at any scale); a round earth is paramount for calculations and visualizations for users in disciplines like military command/control and asset management, meteorology and oceanography (scientific, government, and commercial), and satellite imagery. The DB2 Geodetic Extender has the capability to manage geospatial information referenced by latitude-longitude coordinates and support global spatial queries without the limitations inherent in map projections. To handle objects defined on the earth's surface with precision, the DB2 Geodetic Extender uses a latitude-longitude coordinate system on an ellipsoidal earth model-or geodetic datum-rather than a planar, x- and y-coordinate system. |
| 14. | The correct answer is A. With DB2 9, XML documents are stored in tables that contain one or more columns that are based on the new XML data type. Along with the XML data type, support for XML data includes new storage techniques for efficient management of the hierarchical entities that inherent in XML documents, new indexing technology to speed up retrieval of subsets of XML documents (entire documents do not have to be read in order to retrieve specific information), new capabilities for validating XML data and managing changing XML schemas, new query language support (including native support for XQuery as well as new SQL/XML enhancements), new query optimization techniques, integration with popular application programming interfaces (APIs), and extensions to popular database utilities. |
| 15. | The correct answer is C. Extensible Markup Language (XML) is a simple, very flexible text format that provides a neutral, flexible way to exchange data between different devices, systems, and applications because data is maintained in a self-describing format. XML documents are comprised of a hierarchical set of entities and many XML documents contain heavily nested parent/child relationships and/or irregular structures. Relational data, on the other hand, is a collection of numeric values, character strings, and date/time/timestamp values that must be stored in a tabular format. (XML documents can be "shredded" or decomposed and their contents stored across multiple columns in one or more tables and this approach is ideal if the XML data being stored is tabular in nature. However, the cost associated with decomposing XML data often depends on the structure of the underlying XML document and may require a large number of tables, some of which may need to have values generated for foreign keys in order to capture the relationships and ordering that is inherent in the original documents.) |
Категории