Answer d explanation the data files and temp files

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: another copy of the control file and a second member of each redo log group will be on device /u03. Answer: D Explanation: The data files and temp files directory name is set by the DB_CREATE_FILE_DEST parameter. If you use Oracle Managed Files Locations for the control files are set by the DB_CREATE_ONLINE_LOG_DEST_1 and DB_CREATE_ONLINE_LOG_DEST_2 parameters. Incorrect Answers A: Control file will not be located on device /u01. One copy of the control file and the first member in each online redo log group will be on device /u02; another copy of the control file and a second member of each redo log group will be on device /u03. B: Each redo log copy will have the first member on device /u02 and a second member will be on device /u03. C: Online redo log files, and control file will not be on device /u01. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 55: Examine the statement: SQL> CREATE TABLESPACE user_ data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which two assumptions must be true for this statement to execute successfully? (Choose two.) A. Oracle Managed Files are used for this instance. B. The USER_DATA tablespace is managed using FET$/UET$ tables. C. The COMPATIBLE initialization parameter must be 9.0.0 or higher. D. Space within segments in the USER_DATA tablespace is managed with freelists. Answer: A, C Explanation: Actualtests.com - The Power of Knowing 1Z0-030 Oracle Managed Files are used for this instance. To use automatic space management segment the COMPATIBLE initialization parameter in the init.ora file must be 9.0.0 or higher. Incorrect Answers B: The USER_DATA tablespace is not managed using FET$/UET$ tables. D: Because of automatic space management segment usage the USER_DATA tablespace cannot be managed with freelists. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes QUESTION 56: The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated? A. The initial request from the client to the listener B. Messages between the dispatcher and the shared server background processes C. A redirect message from the listener to the client during client connections D. Round-trip messages between the listener and the shared server background processes Answer: C Explanation: When a client machine initiates a shared server connection to the database in Oracle9i, the listener uses the direct handoff whenever possible. This connection process requires fewer network calls and, accordingly, less overhead. When the listener receives the request fr...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online