IBM Certification Interview Questions and Answers

 

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

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

Posted by:Richards