Freeblocks procedure on an automatic space management

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: FREELIST GROUPS parameters. So you CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment. Incorrect Answers A: You can create an automatic space management segment only in a locally managed tablespace, not in a dictionary-managed tablespace.. C: You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment because of eliminating the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters in an automatic space management segment. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140 Actualtests.com - The Power of Knowing 1Z0-030 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes QUESTION 53: The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement? A. Only MEMORY is updated B. Only SPFILE values are updated C. Only init<SID>.ora parameters are updated. D. Both SPFILE and MEMORY memory values are updated. E. Both init<SID>.ora parameters and SPFILE values are updated. Answer: A Explanation: The default scope of changes made by using the SET clause of the ALTER SYSTEM statement is only MEMORY scope. The MEMORY scope only makes changes in memory for the current instance and not the SPFILE; it does not persist. Incorrect Answers B: The SPFILE is not a default scope of changes made by using the SET clause of the ALTER SYSTEM statement. It makes changes only in the SPFILE and not in the instance. C: The ALTER SYSTEM command does not change the init<SID>.ora file. D: Only MEMORY scope is updated by default. E: The init<SID>.ora file is not updated by the ALTER SYSTEM command. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 80-83 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 32-37 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 54: Examine the following parameter settings from an initialization (init.ora) file: DB_CREATE_FILE_DEST = '/u01/oradata/' DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/' DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/' If you create an Oracle Managed Files (OMF) database using these settings, what is the result? A. The data files, temp files, and control file will be on device /u01; one online redo log group will be on device /u02; another redo log group will be on device /u03. B. The data files and temp files will be on device /u01; one copy of the control file Actualtests.com - The Power of Knowing 1Z0-030 and one online redo log group will be on device /u02; another copy of the control file and a second redo log group will be on device /u03. C. The data files, temp files, online redo log files, and control file will be on device /u01; multiplexed copies of the archive log files will be created: one set on device /u02, and another set on device /u03. D. The data files and temp files will be on device /u01; one copy of the control file and the first member in each online redo log group will be on device /u02;...
View Full Document

Ask a homework question - tutors are online