READ Free Dumps For Oracle- 1z0-023
| Question ID 8839 | The table should be _____ and _______ used to allow usage of the CACHE clause.
|
| Option A | Big, rarely
|
| Option B | Small, rarely
|
| Option C | Big, frequently
|
| Option D | Small, frequently
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. The table should be small and frequently used to allow usage of the CACHE clause. This clause will load table in the cache for quick table data processing in memory without loading data blocks from the disk. Incorrect Answers: A: Big and rarely used table is bad candidate for caching. B: There is no sense to put table in the cache if it is used rarely. C: Big table is bad candidate for caching. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 345-348 Chapter 18: Tuning Memory and Operating System Use
| Question ID 8840 | What are two characteristics of the control file? (Choose two)
|
| Option A | It has a fixed size.
|
| Option B | It should be multiplexed.
|
| Option C | It can be edited by the DBA
|
| Option D | It is required to start the instance
|
| Option E | It is required to open the database
|
| Option F | It is associated with multiple databases
|
| Correct Answer | BE |
Explanation Explanation/Reference: Explanation: Answers B and E are correct. The control file should be multiplexed to reduce Oracle's dependence on any one disk available on the host machine. In the event of failure, the database is more recoverable because multiple copies of the control file have been maintained. This file also is required to open database. Incorrect Answers: A: It does not have fixed size. C: The control file is binary file and under any circumstances it cannot be edited manually. D: The control file required to mount and open the instance, but not to start it. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 319-324 Chapter 7: Managing the Physical Database Structure