READ Free Dumps For Oracle- 1z0-023
| Question ID 8835 | Which two data dictionary views show the number of extents of a certain segment? (Choose two)
|
| Option A | V$EXTENTS
|
| Option B | DBA_EXTENTS
|
| Option C | DBA_SEGMENTS
|
| Option D | DBA_TABLESPACES
|
| Correct Answer | BC |
Explanation Explanation/Reference: Explanation: Answers B and C are correct. DBA_EXTENTS view displays the segment name, type, owner, name of tablespace storing the extent, ID for the extent, file ID storing the extent, starting block ID of the extent, total bytes, and blocks of the extent. DBA_SEGMENTS view is summary view for all types of segments listed by the data dictionary views and their storage parameters. Incorrect Answers: A: There is no V$EXTENTS view in Oracle. D: DBA_TABLESPACES shows the default storage settings for the tablespaces in the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 352-353 Chapter 7: Managing the Physical Database Structure
| Question ID 8836 | Which statement about organizing tablespaces and segments is true?
|
| Option A | You should mix segments with short and long life spans in the same tablespace.
|
| Option B | You should keep good control over space allocation and define storage limits for users.
|
| Option C | You should use the autoextend feature on tablespaces that have a high update, delete, and insert activity.
|
| Option D | Data that is accesses by multiple users should be stored in tablespaces that reside on the same disk for easier management.
|
| Correct Answer | B |
Explanation Explanation/Reference: 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 Exam Guide, Jason S. Couchman, p. 348-355 Chapter 7: Managing the Physical Database Structure