IBM Certification Question:

Explain the Given following DDL statement
CREATE TABLE RMW TABEL46″
11″ INTEGER
D11″ DECIMAL (1′0)NOT NULL
D12″ DECIMAL (1′0) NOT NULL
S7″ SMALLINT
C8″ CHAR(1) WITH DEFAULT)
organize by (
(D12″ ;D11″))
How many indexes will be created?

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

C.3

Previous Question	Next Question
Explain Which of the following DB2 data types CANNOT be used to contain the date an employee was hired? A.CLOB B.TIME C.VARCHAR D.TIMESTAMP	Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS. Which of the following will establish the capacity for a new z/OS server? A. AD Tools B. Estimate the AIX load and add to CP3000 results. C. CP3000 D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ