Table TAB_A resides within table space TBSP_1. Which statement is correct?
A.
Using the COPY NO option means the data in any table within table space TBSP_1
cannot be updated or deleted until either a table spacebackup of TBSP_1 or a full database
backup is completed.
B.
Using the INSERT INTO and the INCREMENTAL indexing mode allows DB2 to increase
the concurrency of table access during the LOADoperation because LOAD will always
append the inserted data to the end of the table and the new index pages are also added to
the end ofthe existing index when using INCREMENTAL indexing mode.
C.
Using the COPY NO and ALLOW READ ACCESS options means that the existing table
data is only readable until the index build phase begins,since no copy of the existing data is
made during the LOAD.
D.
Using the ALLOW READ ACCESS option along with INCREMENTAL indexing mode
means that the newly inserted data can be accessedbecause of the new CURRENTLY
COMMITTED semantics.