What is the Character Set Scanner?
A.
a separate program that searches the database for invalid strings
B.
a package (DBMS_CSS) that searches the database for invalid strings
C.
a separate program that searches for strings that require Unicode conversion if you want to support multiple languages
D.
a separate program that identifies character data loss if you change the character sets of the database
Explanation:
Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features:
1) convertibility check of existing data and potential issues.The Scanner checks all character data in the database including the data dictionary and tests for the effects and problems of changing the character set encoding (characterset). At the end of the scan, it generates a summary and exception report of the database scan.
2) from csscan V1.1 onwards it allows you also to do a check if there is no data in the database that is incorrectly stored.
REF.: Metalink Note : 123670.1 – Use Scanner Utility before Altering the Database Character Set