PrepAway - Latest Free Exam Questions & Answers

Which statement(s) must be executed before applications…

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ
ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

PrepAway - Latest Free Exam Questions & Answers

A.
SET INTEGRITY FOR mytab IMMEDIATE CHECKED

B.
ALTER TABLE mytab CHECK (COL IS VALIDATED)

C.
ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED

D.
ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;

One Comment on “Which statement(s) must be executed before applications…

  1. Chow, Kenneth KY says:

    ALLOW READ ACCESS
    Load will lock the target table in a share mode. The table state will be set to both Load In Progress and Read Access. Readers can access the non-delta portion of the data while the table is being load. In other words, data that existed before the start of the load will be accessible by readers to the table, data that is being loaded is not available until the load is complete. LOAD TERMINATE or LOAD RESTART of an ALLOW READ ACCESS load can use this option; LOAD TERMINATE or LOAD RESTART of an ALLOW NO ACCESS load cannot use this option. Furthermore, this option is not valid if the indexes on the target table are marked as requiring a rebuild.
    When there are constraints on the table, the table state will be set to Set Integrity Pending as well as Load In Progress, and Read Access. At the end of the load, the table state Load In Progress will be removed but the table states Set Integrity Pending and Read Access will remain. The SET INTEGRITY statement must be used to take the table out of Set Integrity Pending. While the table is in Set Integrity Pending and Read Access states, the non-delta portion of the data is still accessible to readers, the new (delta) portion of the data will remain inaccessible until the SET INTEGRITY statement has completed. A user can perform multiple loads on the same table without issuing a SET INTEGRITY statement. Only the original (checked) data will remain visible, however, until the SET INTEGRITY statement is issued.




    0



    0

Leave a Reply