D create a tablespace in which a user can create

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: ents for usage during sorts. D. Create a tablespace in which a user can create tables that will be automatically dropped after a week Answer: C Explanation: This statement can be used to create segments for sort usage by Oracle. Incorrect Answers: A: This tablespace will not be dropped on instance shutdown. B: There is no way for user to create sort segments explicitly, only Oracle can do this itself. D: Tables can be created by user in TEMP tablespace, but they will not be dropped automatically. Also TEMPORARY clause will prevent users from creating permanent objects in tablespaces containing temporary segments. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 893-895. Chapter 19: Tuning Disk Utilization QUESTION 18: Which type of transaction should you assign to a specific large rollback segment? A. Batch jobs that modify many rows. B. Long running serializable transactions. Actualtests.com - The Power of Knowing 1Z0-024 C. Long running reports, to avoid 'snapshot too old' errors. D. Discrete transactions that modify many rows in the same block. Answer: A Explanation: Using SET TRANSACTION USE ROLLBACK SEGMENT command you can assign batch job transaction that modify many rows to a specific large rollback segment. Incorrect Answers: B: You don't need to assign long running serializable transactions to a specific large rollback segment. C: Reports are not changing data usually, so they will not cause 'Snapshot too old' error. D: Discrete transactions do not need a specific large rollback segment to be assigned. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 911. Chapter 19: Tuning Disk Utilization QUESTION 19: What is the least number of buffers an LRU latch must cover in the database buffer cache? A. 5 B. 10 C. 30 D. 50 E. 100 Answer: D Explanation: There must be at least 50 block buffers for every LRU latch you allocate to database buffer cache. Incorrect Answers: A: 5 buffers are not enough for an LRU latch, there must be at least 50 blocks. B: 10 buffers are not enough for an LRU latch, there...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online