READ Free Dumps For Oracle- 1z0-023
Question ID 8807 | What determines the initial size of a tablespace?
|
Option A | Use INITIAL clause of the CREATE TABLESPACE statement.
|
Option B | The MINEXTENTS clause of the CREATE TABLESPACE statement
|
Option C | The MINIMUM EXTENTS clause of the CREATE TABLESPACE statement
|
Option D | The sum of the INITIAL and NEXT clauses of the CREATE TABLESPACE statement.
|
Option E | The sum of the sizes of datafiles specified in the CREATE TABLESPACE statement.
|
Correct Answer | E |
Explanation Explanation/Reference: Explanation: Answer E is correct. The sum of the sizes of datafiles specified in the CREATE TABLESPACE statement determines the initial size of a tablespace. Incorrect Answers: A: INITIAL clause specifies the size of the object's initial segment, not initial size of a tablespace. B: The MINEXTENTS clause defines the minimum number of extents the object can allocate in the tablespace. C: There is one storage option that, when defined in a tablespace, cannot be overridden. That option is MINIMUM EXTENT, which ensures that every extent size used in the tablespace is a multiple of the specified integer value. But this option does not specify the initial size of a tablespace. D: The sum of the INITIAL and NEXT clauses of the CREATE TABLESPACE statement do not determine the initial size of a tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 337-342 Chapter 7: Managing the Physical Database Structure
Question ID 8808 | What can a permanent tablespace contain?
|
Option A | Only temporary segments.
|
Option B | Only permanent segments.
|
Option C | Both temporary and ordinary segments.
|
Option D | Both permanent and temporary segments.
|
Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. Users can be assigned to either permanent or temporary tablespaces for creating temporary segments. If the user assigned to a permanent tablespace for creating temporary segments, the temporary segment will be created at the time the disk sort is required. Incorrect Answers: A: A permanent tablespace contains mostly permanent segments, but can be used to keep temporary segments for data sorting. B: A permanent tablespace contains not only permanent segments. C: There is no ordinary segments in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 383-345 Chapter 8: Managing Database Objects I