Practice Questions

1.	Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs? A. DB2 Everyplace B. DB2 Express Edition C. DB2 Workgroup Server Edition D. DB2 Enterprise Server Edition
2.	Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server? A. DB2 Express-C B. DB2 Express C. DB2 Personal Edition D. DB2 Enterprise Server Edition
3.	Which of the following DB2 products can only be installed on a System i server? A. DB2 for z/OS B. DB2 for i5/OS C. DB2 Data Warehouse Edition D. DB2 Enterprise Server Edition
4.	What is the purpose of the Design Advisor? A. To analyze workloads and make recommendations for indexes and MQTs B. To present a graphical representation of a data access plan and recommend design changes that will improve performance C. To replicate data between a DB2 database and another relational database D. To configure clients so they can access databases stored on remote servers
5.	Which of the following DB2 tools allows a user to set DB2 registry parameters? A. Task Center B. Visual Explain C. Configuration Assistant D. Satellite Administration Center
6.	What is the SQL Performance Monitor used for? A. To examine the health of a DB2 Database Manager instance B. To visually construct complex DML statements and examine the results of their execution C. To schedule tasks, run tasks, and send notifications about completed task s to other users D. To analyze database operations performed against a DB2 for i5/OS database
7.	Which of the following tasks can NOT be performed using the Developer Workbench? A. Develop and debug an SQL stored procedure B. Develop and debug a user-defined data type C. Develop and debug a user-defined function D. Develop and run XML queries
8.	Which of the following tools can be used to automate table reorganization operations? A. Control Center B. Command Center C. Command Line Processor D. Task Center
9.	Which of the following can be viewed with the Journal? A. Historical information about tasks, database changes, messages, and notifications B. Information about licenses associated with each DB2 9 product installed on a particular system C. Graphical representations of data access plans chosen for SQL statements D. Warning and alarm thresholds for database indicators
10.	Which of the following is NOT a characteristic of an OLTP database? A. Granular transactions B. Current data C. Optimized for queries D. Frequent updates
11.	Which of the following is NOT a characteristic of a data warehouse? A. Summarized queries that perform aggregations and joins B. Heterogeneous data sources C. Voluminous historical data D. Sub-second response time
12.	Which of the following products is used to shred extensible markup language documents? A. DB2 AVI Extender B. DB2 Text Extender C. DB2 XML Extender D. DB2 Spatial Extender
13.	Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender? A. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe D. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography
14.	Which of the following is true about XML columns? A. XML columns are used to store XML documents as a hierarchical set of entities B. Only XQuery can be used to retrieve an XML document from an XML column C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
15.	Which of the following is the major difference between relational data and XML data? A. Relational data is self-describing; XML data is not B. Relational data has inherent ordering; XML data does not C. Relational data must be tabular; XML data does not have to be tabular D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

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.)