C2090-730 Exam - Free IBM Questions and Answers

Question #11 (Topic: )

Given the following table:
STOCK
--------------------------
CATEGORY CHAR(1)
PARTNO CHAR(12)
DESCRIPTION VARCHAR(40)
QUANTITY INTEGER
PRICE DEC(7,2)
If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY
and PRICE to zero, which of the following statements updates the STOCK table to indicate
that all items except those with CATEGORY of S are temporarily out of stock?

A. UPDATE stock SET description = ’NULL’, quantity = 0, price = 0 WHERE category ‘S’ B. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category S C. UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’ D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’

Answer: D

Question #12 (Topic: )

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

A. SERVER B. SERVER_ENCRYPT C. CLIENT D. DCS

Answer: D

Question #13 (Topic: )

Which of the following products must be installed on an AIX server in order to build an
application for AIX that will access a DB2 for z/OS database?

A. DB2 Enterprise Server Edition B. DB2 Personal Developer's Edition C. DB2 UniversalDeveloper's Edition D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Answer: C

Question #14 (Topic: )

Which of the following tools can be used to schedule a backup operation that is to be run
every Sunday evening?

A. Journal B. Task Center C. Activity Monitor D. Command Line Processor

Answer: B

Question #15 (Topic: )

A stored procedure object is created into which DB2 object?

A. Alias B. Schema C. Package D. Routine Space

Answer: B

IBM C2090-730 - DB2 9 Family Fundamentals Exam