Actualtestscom the power of knowing 1z0 024 a same

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (USER_ID). Where should USERS and USERID_NDX be stored? Actualtests.com - The Power of Knowing 1Z0-024 A. Same tablespace. B. SYSTEM tablespace. C. Same tablespace on different disks. D. Different tablespace on different disks. Answer: D Explanation: For better performance the USERS table and the USERID_NDX index must be stored in different tablespaces on different disks. Incorrect Answers: A: If these objects will be in the same tablespace it will cause performance degradation. B: SYSTEM tablespace is used to store only data dictionary objects, not for user tables or indexes. C: It's not recommended to put data and index data in one tablespace: it will cause I/O contention, because Oracle will try to retrieve index and data blocks from one tablespace in one time. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 844. Chapter 18: Tuning Memory and Operating System Use QUESTION 60: You are creating a new rollback segment. Why should you choose the same value for the NEXT and INITIAL attributes? A. That depends on the PCTINCREASE value you specify. B. To avoid contention on the rollback segment header. C. Rollback segment extents are used in a circular way. D. Because you get an error message if you specify different values. Answer: C Explanation: Rollback segment extents are used in a circular way, so the NEXT and INITIAL attributes are the same for rollback segment. Incorrect Answers: A: PCTINCREASE parameter for rollback segments is zero always. B: Value for the NEXT and INITIAL attributes are the same for the rollback segment, it does not relate with contention on the rollback segment header. D: You should choose the same value for the NEXT and INITIAL attributes because rollback segments extents are used in a circular way, not because of error message. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 904-911. Chapter 19: Tuning Disk Utilization Actualtests.com - The Power of Knowing 1Z0-024 QUESTION 61: What should be your main redo log buffer tuning goal? A. A...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online