The application will be handling a large volume of input data that will need to be added to or
update 4 different tables. On average, there will be 50 million input records daily. To ensure that
the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level
of availability to the tables involved in this application process, what is a key component of the
application coding?
A.
Issue a LOCK TABLE for all 4 tables.
B.
Execute the SQL INSERT before the SQL UPDATE.
C.
Provide an effective commit / restart process.
D.
Run a QUIESCE utility before the process starts.
Explanation: