D the temporary tablespace cannot contain permanent

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: nition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 383-385 Chapter 8: Managing Database Objects I QUESTION 138: 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 tablespace. Answer: A, B 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. Actualtests.com - The Power of Knowing 1Z0-023 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)...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online