In previous versions the next step would have been to

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: om the client for a shared server connection, it locates the address of the least loaded dispatcher process. In previous versions, the next step would have been to pass this address back to the client for the client to contact the dispatcher again over the network. Instead, in Oracle9i's direct handoff method, the listener hands the connection request to the dispatcher. The dispatcher communicates directly with the client to establish a connection without the need for the additional network calls that were required in previous versions. Incorrect Answers A: The initial request from the client to the listener is not eliminated. B: Messages between the dispatcher and the shared server background processes are used in Oracle9i also as in previous versions. D: Round-trip messages between the listener and the shared server background processes are used in Oracle9i as in previous versions of Oracle. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 144-152 Chapter 3: Manageability Enhancements Actualtests.com - The Power of Knowing 1Z0-030 Oracle 9i New Features, Robert Freeman, p. 59-60 Chapter 2: Oracle9i Architecture Changes QUESTION 57: You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do? A. Use the DROP DATAFILE command B. Use the DROP TABLESPACE command C. Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command D. Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command Answer: B Explanation: You can drop the tablespace and the segments, and also delete the OS datafiles with the following command: DROP TABLESPACE tablespace_name INCLUDING CONTENTS and DATAFILES. Incorrect Answers A: You cannot achieve this purpose with the DROP DATAFILE command. C: You can delete not-OMF datafiles also using the DROP TABLESPACE command. D: To delete not-OMF datafiles you don't need to be ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 157-158 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 58: Which two statements are true regarding the use of UTF-16 encoding? (Choose two.) A. Enables easier loading of multinational data B. Uses a fixed-width multibyte encoding sequence C. Asian characters are represented in three characters D. Uses a variable-width multibyte encoding sequence E. European characters are represented in one or two bytes Answer: A, B Actualtests.com - The Power of Knowing 1Z0-030 Explanation: AL16UTF16 is a 2-byte, fixed-width Unicode character set, which is also referred to as UTF16 or UCS2. The ASCII English character set is assigned the first 128 values from 0 (0X00) through 127 (oX7F) in Unicode, which translates to 1 byte. Even though AL16UTF16 uses one more byte than UTF8 for ASCII character representation, it is...
View Full Document

Ask a homework question - tutors are online