Oracle Database Administration II — Question 12

Which two are true about the character sets used in an Oracle database? (Choose two.)

Answer options

• A. Single-byte character sets provide better performance than multibyte character sets.
• B. Unicode enables information from any language to be stored using a single character set.
• C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
• D. Single-byte character sets always use 7-bit encoding schemes.
• E. Multibyte character sets allow more efficient space utilization than single byte character sets.
• F. Single-byte character sets always use 8-bit encoding schemes.

Correct answer: A, B

Explanation

Option A is correct because single-byte character sets are generally faster due to simpler encoding. Option B is also correct as Unicode can represent characters from multiple languages in a single format. Options C, D, E, and F are incorrect; C is false since other character sets are supported, D and F are misleading about encoding, and E is incorrect as single-byte sets can be more efficient in certain scenarios.