This preview shows page 1. Sign up to view the full content.
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.
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
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
D. Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before
using the DROP TABLESPACE command
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.
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
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
Which two statements are true regarding the use of UTF-16 encoding? (Choose
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
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
- Fall '09