IBM
C2090-312 · Question #93
C2090-312 Question #93: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
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?
Options
- AIssue a LOCK TABLE for all 4 tables.
- BExecute the SQL INSERT before the SQL UPDATE.
- CProvide an effective commit / restart process.
- DRun a QUIESCE utility before the process starts.
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.