Help me on this question plz



IBM's flagship relational database management system

Help me on this question plz

Postby edward87 » Wed Dec 07, 2011 7:15 am

A table named TAB_A was created with the COMPRESS YES option specified and populated with
100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?
A. In order for the index to be compressed, it must be enabled for compression by specifying the
COMPRESS YES option with the CREATE INDEX statement that is used to create it.
B. The index will automatically be compressed since the table it is associated with is compressed; the
ALTER INDEX command does not have to be executed.
C. In order for the index to be compressed, it must be enabled for compression by specifying the
COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not
be compressed until the ALTER INDEX command is used to create an index compression dictionary.
D. The index will automatically be enabled for compression because the associated table is compressed;
however, the index will not be compressed until it is REORGed.

i think the correct answer should be B, but what is the explanation?
edward87
 
Posts: 2
Joined: Wed Dec 07, 2011 7:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: Help me on this question plz

 

Re: Help me on this question plz

Postby db2sysdba » Wed Dec 07, 2011 3:17 pm

Option 'A' is the correct answer.

[img]but%20what%20is%20the%20explanation?[/img]

Just google this page

http://www.redbooks.ibm.com/redpieces/abstracts/redp4345.html?Open
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post