-
DB2 Flavours
What are the flavours of DB2?
-
DB2 Indexes
i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space Single index only
-
How do we know that NULL value has been selected for a nullable column
?a.Check if equal to NULLb.Use null indicator, 0 indicates nullc.Use null indicator, -1 indicates nulld.Use null indicator, -2 indicates nulle.None of the above.Use null indicator, -1 indicates null
-
-
-
-
-
-
-
-
-