March 07, 2008

As conference season approaches (IDUG North America is coming up in May), you might be starting to think about taking advantage of the free certification exams offered at these shows. These questions, reprinted with permission from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, should help you prepare. Check back each week for more questions, and try past questions here.

QUESTION 19
A database server has one instance named DB2INST1 and two databases named SALES and PAYROLL. Which of the following commands will allow the DB2INST1 instance and the SALES database, but prevent the PAYROLL database from being seen by DB2 Discovery?

A. UPDATE DBM CFG USING DISCOVER_INST SEARCH;
UPDATE DB CFG FOR sales DISCOVER_DB SEARCH;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
B. UPDATE DBM CFG USING DISCOVER_INST ENABLE;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
C. UPDATE DBM CFG USING DISCOVERY SEARCH;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
D. UPDATE DBM CFG USING DISCOVERY ENABLE;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;

QUESTION 20
If the following CREATE INDEX statements are executed:

CREATE INDEX cust_zip_idx ON customer(custinfo)
GENERATE KEY
USING XMLPATTERN '/customerinfo/addr/zip-pcode'
AS SQL DOUBLE;

CREATE INDEX cust_city_idx ON customer(custinfo)
GENERATE KEY
USING XMLPATTERN '/customerinfo/addr/city'
AS SQL VARCHAR(40);

And the following XML documents are inserted into the CUSTOMER table:

<?xml version="1.0" encoding="UTF-8" ?>
<customerinfo xmlns="http://crecord.dat. id="1000">
<name>John Doe</name>
<addr country="United States">
<street>25 East Creek Drive</street>
<city>Raleigh</city>
<state-prov>North Carolina</state-prov>
<zip-pcode>27603</zip-pcode>
</addr>
<phone type="work">919-555-1212</phone>
<email>john.doe@yahoo.com</email>
</customerinfo>

<?xml version="1.0" encoding="UTF-8" ?>
<customerinfo xmlns="http://crecord.dat. id="1010">
<name>Jane Smith</name>
<addr country="United States">
<street>2120 Stewart Street</street>
<city></city>
<state-prov>South Carolina</state-prov>
<zip-pcode>29501</zip-pcode>
</addr>
<phone type="work">843-555-3434</phone>
<email>jane.smith@aol.com</email>
</customerinfo>

How many index keys will be generated?

A. 1
B. 2
C. 3
D. 4

Trackback Pings

TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/03/post_2.html

« DB2 LUW Performance: More on Locks | Main | DB2 9 DBA Certification Exam: DB2 Indexes and Create Table Statements »