-
what is the result of the following statement?
Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What is the result of issuing the following statement? SELECT * FROM dwaine.mytab
-
DB2 Index Storate Format
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree B - Tree format
-
DB2 Index and Table Space
I) Index Space are created automatically when Index are created. II) Table Space are created automatically when Tables are created. Of the above statementBoth are True( I ) is Only True( II) is only TrueBoth are False( I ) is Only 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