READ Free Dumps For Oracle- 1z0-023
Question ID 8859 | In order to guarantee a minimum number of concurrent updates on a data block, which parameter do you need to set?
|
Option A | PCTFREE
|
Option B | INITRANS
|
Option C | MAXTRANS
|
Option D | MIN_SESSIONS
|
Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. INITRANS parameter guarantees a minimum number of concurrent updates on a table block. Incorrect Answers: A: PCTFREE parameter is used to specify the amount of space left free in each block to accommodate the growth of existing rows in the block. C: MAXTRANS provides maximum number of concurrent updates on a data block. D: There is no MIN_SESSION parameter in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352 Chapter 7: Managing the Physical Database Structure
Question ID 8860 | Which two parameters might affect the concurrency of transactions on a data block? (Choose two)
|
Option A | PCTUSED
|
Option B | PCTFREE
|
Option C | MAX_EXTENT
|
Option D | NEXT_EXTENT
|
Correct Answer | BC |
Explanation Explanation/Reference: Explanation: Answers B and C are correct. PCTFEE and MAX_EXTENT parameters can affect the concurrency of transactions on a data block. Incorrect Answers: A: PCTUSED parameter cannot affect the concurrency of transactions. D: NEXT_EXTENT just provide size of next allocated extent, it has nothing to do with the concurrency of transactions. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352 Chapter 7: Managing the Physical Database Structure