The server manager is not supported in oarcle9i any

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: i database. The Server Manager is not supported in Oarcle9i any more, so you need to use SQL*Plus for administration tasks, as start or stop of database, also. Incorrect Answers A: The NOLOG option must be used to run this script because the instance is not started yet. B: Script that need to be executed can be started with @ symbol, not with -S. C: The S option cannot be used to run the startmydb.sql script. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 4-10 Chapter 1: Security Enhancements Oracle 9i New Features, Robert Freeman, p. 132-139 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 25: What are two key features of Automatic Undo Management? (Choose two.) A. Oracle manages all undo space automatically. B. The SYSTEM tablespace is never used to store automatic undo segments. C. Undo tablespaces contain all undo information not stored in the SYSTEM rollback segment. D. Rollback segments are gradually replaced with automatic undo segments as the instance gathers statistics about rollback requirements. E. The number of automatic undo segments available to an instance is determined by the number of undo tablespaces defined in its initialization parameter file. Answer: A, C Explanation: There are two key features of Automatic Undo Management: Oracle manages all undo space automatically and undo tablespaces contain all undo information not stored in the SYSTEM rollback segment. Incorrect Answers Actualtests.com - The Power of Knowing 1Z0-030 B: The SYSTEM rollback segment is created automatically during database creation and is managed automatically just as it was in previous versions. D: AUM creates automatic undo segments itself based on gathered statistics about rollback requirements. Regular rollback segments are not gradually replaced with automatic undo segments, because these types of segments cannot coexist in one database instance. E: The number of automatic undo segments available to an instance is not determined by the number of undo tablespaces defined in its initialization parameter file: AUM performs this task. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 19-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 26: Examine this fragment from a SQL*Plus session: SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%'; NAME VALUE -------------------------------- ------work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038 What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter? A. You cannot conclude anything because these statistics are not related to the PGA_AGGREGATE_TARGET parameter. B. It may be set too low because there are many more multipass work area executions than one pass executions. C. It may be set too high because there are many more multipass work area executions than one...
View Full Document

Ask a homework question - tutors are online