READ Free Dumps For Oracle- 1z0-023
| Question ID 8898 | What can a temporary tablespace contain?
|
| Option A | Only temporary segments.
|
| Option B | Only permanent segments.
|
| Option C | Both temporary and ordinary data files.
|
| Option D | Both permanent and temporary segments.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. A temporary tablespace can contain only temporary segments. Incorrect Answers: B: There are no permanent segments in the temporary tablespace. C: The temporary tablespace cannot contain ordinary data files by definition. D: The temporary tablespace cannot contain permanent segments by definition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 383-385 Chapter 8: Managing Database Objects I
| Question ID 8899 | Which two methods can be used to increase the size of tablespace? (Choose two)
|
| Option A | The ALTER TABLESPACE command with the ADD DATAFILE clause.
|
| Option B | The ALTER DATABASE DATAFILE command with the RESIZE clause.
|
| Option C | The ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
|
| Option D | The ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
|
| Option E | The ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B are correct. To increase the size of tablespace you can use the ALTER TABLESPACE command with the ADD DATAFILE clause or just increase size of the existing datafile(s) using the ALTER DATABASE command with the RESIZE clause. Incorrect Answers: C: MINEXTENTS parameter specifies the number of extents allocated when a segment is first created in the tablespace. When changing the value of MINEXTENTS (that is, in an ALTER statement), you can reduce the value from its current value, but you cannot increase it. You cannot change the value of MINEXTENTS for an object that resides in a locally managed tablespace. D: MAXEXTENTS parameter determines the maximum number of extents that a segment can have. Can also be specified as UNLIMITED. The minimum value is 1 (except for rollback segments, which always have a minimum value of 2). The default value depends on your data block size. E: The MINIMUM EXTENT clause lets you control free space fragmentation in the tablespace by ensuring that every used or free extent in a tablespace is at least as large as, and is a multiple of, integer. This clause is not relevant for a dictionary-managed temporary tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 337-339 Chapter 7: Managing the Physical Database Structure