Answers
QUESTION 27
The correct answer is A. Tools Settings notebook is an interactive GUI application that is used to customize settings and set properties for the various DB2 administration tools avail-able. To present and collect this information in an organized manner, the Tools Settings notebook uses several different pages/tabs – some pages/tabs will only be displayed after the tools for which they apply have been installed. The pages available with the Tools Settings notebook are:
General page. This page is used to specify whether the local DB2 instance should be started automatically when the DB2 tools are started, whether to use a statement termination character, and whether to use filtering when the maxi-mum number of rows returned for a display sample contents request is ex-ceeded.
Documentation page. This page is used to specify whether hover help and info-pop help features in the DB2 administration tools should display automatically, and also to specify the location from which the contextual help is accessed at the instance level.
Fonts page. This page is used to change the font in which text and menus ap-pear in the DB2 administration tools.
OS/390 and z/OS page. This page is used to set column headings and define the online and batch utility execution options for OS/390 and z/OS objects.
Health Center Status Beacon page. This page is used to specify the type of no-tification you will receive when an alert is generated in the Health Monitor. You can be notified through a pop-up message or with the graphical beacon that dis-plays on the lower-right portion of the status line for each DB2 center, or using both methods of notification.
Scheduler Settings page. This page is used to set the default scheduling scheme. Select Server Scheduling if you want task scheduling to be handled by the scheduler that is local to the database server; select Centralized Scheduling if you want the storage and scheduling of tasks to be handled by a centralized system, in which case you need to select the centralized system from the Cen-tralized Scheduler list. (To enable another scheduler, select a system and click Create New to open a window in which you can create a database for the DB2 Tools Catalog on a cataloged system. If the system you want is not cataloged, you must catalog it first.)
Command Editor page. This page is used to specify how you will generate, edit, execute, and manipulate SQL and XQuery statements, IMS commands, and DB2 commands. This page is also used to specify how you want to work with the resulting output.
IMS page. This page is used to set your preferences when working with IMS. From this page, you can set preferences for using wizards, for syntax support, and for returning results.

The Replication Center is used to define replication environments.

QUESTION 28
The correct answer is D. The Load utility can be used to delete all records in a table without generating corresponding log records by specifying the null device as the input file and in-voking the LOAD with the REPLACE option specified. On UNIX the null device is /dev/null, on Windows it is nul). Thus, the following commands could be used to delete all records found in a table named DEPARTMENT:

LOAD FROM /dev/null OF DEL REPLACE INTO department (UNIX)

LOAD FROM nul OF DEL REPLACE INTO department (Windows)