1Z0-023

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: : Managing the Physical Database Structure QUESTION 90: Which statement about organizing tablespaces and segments is true? A. You should mix segments with short and long life spans in the same tablespace. B. You should keep good control over space allocation and define storage limits for users. C. You should use the autoextend feature on tablespaces that have a high update, delete, and insert activity. D. Data that is accesses by multiple users should be stored in tablespaces that reside on the same disk for easier management. Answer: B Explanation: Answer B is correct. You can control space allocation and define storage limits for users by using quotas. Incorrect Answers: A: You should not mix segments with short and long spans in the same tablespace. C: You need to avoid AUTOEXTEND feature for tablespaces with high level activity, like inserts, updates and deletes. D: You should reside datafiles of tablespaces on different disks for better database performance. Oracle 8, DBA Certification Ex...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online