Table TAB_A resides within table space TBSP_1.
Which statement is correct?
A.
TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular
columns and hidden columns. While new data is being loaded into TAB_A, applications will be able to read
the data that existed prior to the LOAD operation.
B.
A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This
copy allows applications to read the data that existed in the table prior to the LOAD operation and improves
performance since the read operations will not collide with the LOAD.
C.
The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used.
Instead, new index keys will be appended to the original indexes. This will improve concurrency for the
applications that are reading TAB_A during the LOAD operation.
D.
The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES
option. Since the indexes will also be built using the INCREMENTAL indexing mode, the concurrency of
table TAB_A will be maximized for any applications that wish to access the table.
implicitlyhiddeninclude
If this modifier is specified, the utility assumes that the input data file contains data for the implicitly hidden columns and this data will also be loaded. This modifier cannot be used with the implicitlyhiddenmissing modifier. See the Note: section for information about the precedence when multiple modifiers are specified.
0
0