AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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

Send email to admin@getfreedumps for new dumps request!!!