New Features for Administrators - Question 094

What does the Character Set Scanner command line utility do?

A. Reports only on any Unicode character conversions required

B. Performs character set conversions to the new specified character set

C. Scans on any character set conversion required, then converts the data

D. Checks for any character definitions that will fail conversion to the new character set

Answer: D

Explanation:

Oracle9i provides you with the Character Set Scanner (csscan) utility that scans the data to discover potential problems with character set migrations. The scanner verifies the following: that the data in the target database can fit into the column’s data size, that the data in the source can be mapped without being replaced in the target database, that the data can be correctly converted particularly when dealing with differences in byte sizes and fixed/variable byte encoding systems.

Incorrect Answers

A: It does not report only on any Unicode character conversions required.

B: The Character Set Scanner does not perform character set conversions to the new specified character set.

C: It does not convert the data, only scans it.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 273-275 Chapter 5: Language Enhancements

Oracle 9i New Features, Robert Freeman, p. 141 Chapter 5: Miscellaneous Oracle9i Features and Enhancements