D use the alter tablespace command to increase the

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: mmand to increase the MAXEXTENTS for the tablespace. E. Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace. Actualtests.com - The Power of Knowing 1Z0-023 Answer: A, B Explanation: Answers A and B are correct. You can add a datafile to a tablespace or just increase the size of a datafile in the tablespace to increase the size of a tablespace. Incorrect Answers: C: By increasing the MINEXTENTS parameter for the tablespace you cannot increase the size of tablespace. D: By increasing the MAXEXTENTS parameter for the tablespace you cannot increase the size of tablespace. E: There is no MINIMUM EXTENT clause in ALTER TABLESPACE command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 339-340 Chapter 7: Managing the Physical Database Structure QUESTION 57: What does the command 'ALTER DATABASE . . . RENAME DATAFILE' do? A. It copies a data file. B. It updates the control file. C. It copies a data file and updates the control file. D. It copies a data file, delete...
View Full Document

Ask a homework question - tutors are online