Oracle
1Z0-873 · Question #31
1Z0-873 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-873 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Question
Which of the following statements are true for the MERGE storage engine?
Options
- AIt uses table-level locking.
- BIt uses row-level locking.
- CUnderlying MyISAM tables are read-locked when you issue a SELECT statement on a MERGE
- DUnderlying MyISAM tables are write-locked when you issue a SELECT statement on a MERGE
- EUnderlying MyISAM tables are read-locked when you issue a statement that modifies a MERGE
- FUnderlying MyISAM tables are write-locked when you issue a statement that modifies a MERGE
- GTo LOCK a MERGE table, it is sufficient to lock just that table.
- HTo LOCK a MERGE table, you need to lock all underlying MyISAM tables as well.
Unlock 1Z0-873 to see the answer
You've previewed enough free 1Z0-873 questions. Unlock 1Z0-873 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.