PrepAway - Latest Free Exam Questions & Answers

Which statement is correct?

Table TAB_A resides within table space TBSP_1. Which statement is correct?

PrepAway - Latest Free Exam Questions & Answers

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. Whilenew 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 thedata 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 beappended 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 bebuilt using the INCREMENTAL
indexing mode, the concurrency of table TAB_A will be maximized for any applications that
wish to access thetable.

Explanation:


Leave a Reply