Want to pass your DB2 9 Family Fundamentals C2090-730 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which of the following DB2 data types can NOT be used to create an identity column?
A. SMALLINT
B. INTEGER
C. NUMERIC
D. DOUBLE
Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?
A. Index
B. Check constraint
C. Referential constraint
D. Default constraint
A view is created with the following statement: CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTION
What is the effect of the CHECK OPTION clause?
A. Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B. From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C. At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D. Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.