C create multiple small rollback segments as opposed

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: efresh optimizer statistics. C. Create multiple small rollback segments as opposed to a few big ones. D. Create indexes on all columns that are regularly used in query predicates. E. Set up appropriate default storage parameter values for dynamic (implicit) space allocation. Answer: B, C, Explanation: There are several design paradoxes inherent in OLTP systems. First, OLTP systems need to be designed to facilitate fast data entry without sacrificing accuracy. Any mechanism that checks the data being entered will cause some performance degradation. Data change is the primary function of an OLTP system. The designers and DBAs of such systems must work with users to create an effective trade-off between viewing data quickly and making data changes quickly. Because of quick data changes you need to analyze your tables regularly to keep optimizer statistics up to date. Because of high volume of user connections it's reasonable to create multiple small rollback segments as opposed to a few big ones. Incorrect Answers: A: Using bind variables rather than literals in your SQL code will cause performance degradation because SQL statements will be parsed again. D: Iindexes on ALL columns will decrease performance also, because of high volume of insert, delete and update requires indexes rebuilding constantly. E: Setting up default storage parameter values for dynamic space allocation will cause Actualtests.com - The Power of Knowing 1Z0-024 performance degradation, because these parameters need to be set based on database activity, insert and updates. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 793-795 Chapter 17: Tuning Database Applications QUESTION 13: Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user? A. TEMP B. DATA C. SYSTEM D. ROLL-BACK Answer: C Explanation: SYSTEM tablespace will be used as the temporary tablespace if TEMPORARY TABLESPACE is not specified for a user. Incorrect Answers: A: There is no TEMP table...
View Full Document

Ask a homework question - tutors are online