467.In a database with the database character set of US7ASCII and a national character set of UTF-8,
which datatypes would be capable of storing Unicode data by default?
A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
Answer: C
NVARCHAR2 Data Type
The NVARCHAR2
data type is a Unicode-only data type. When you create a table with an NVARCHAR2
column, you supply the maximum number of characters
it can hold. Oracle subsequently stores each value in the column exactly as you specify it, provided the value does not exceed the maximum length of the column.
The maximum length of the column is determined by the national character set definition. Width specifications of character
data type NVARCHAR2
refer to the number of characters. The maximum column size allowed is 4000 bytes.