rename datafile command you need to copy the data

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: to copy the data files by using operation system command. D: There is no ALTER DATABASE ... MOVE DATAFILE command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 340-343 Chapter 7: Managing the Physical Database Structure QUESTION 61: What determines the initial size of a tablespace? A. Use INITIAL clause of the CREATE TABLESPACE statement. B. The MINEXTENTS clause of the CREATE TABLESPACE statement. C. The MINIMUM EXTENTS clause of the CREATE TABLESPACE statement. D. The sum of the INITIAL and NEXT clauses of the CREATE TABLESPACE statement. E. The sum of the sizes of datafiles specified in the CREATE TABLESPACE statement. Answer: E 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,...
View Full Document

Ask a homework question - tutors are online