Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?
A. All objects in the database
B. Tables owned by SYS and SYSTEM
C. Data dictionary tables
D. NCHAR columns
E. CHAR columns
Only option E is correct.Tables owned by the SYS and SYSTEM users are not affected by default-length semantics.Data dictionary tables always use byte semantics,and NCHAR columns always use character semantics.Therefore,neither is affected by the setting of the NLS_LENGTH_SEMANTICS parameter.