This preview shows page 1. Sign up to view the full content.
Unformatted text preview: nition.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 383-385
Chapter 8: Managing Database Objects I
Which two methods can be used to increase the size of tablespace? (Choose two)
A. The ALTER TABLESPACE command with the ADD DATAFILE clause.
B. The ALTER DATABASE DATAFILE command with the RESIZE clause.
C. The ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
D. The ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
E. The ALTER TABLESPACE command to increase the MINIMUM EXTENT for the
Answer: A, B
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.
Actualtests.com - The Power of Knowing 1Z0-023
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
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09