Oracle Database SQL — Question 195

Which three statements are true about built-in data types? (Choose three.)

Answer options

• A. The default length for a CHAR column is always one character.
• B. A VARCHAR2 blank-pads column values only in the data stored is non-numeric and contains no special characters.
• C. A VARCHAR2 column definition does not require the length to be specified.
• D. A CHAR column definition does not require the length to be specified.
• E. A BLOB stores unstructured binary data within the database.
• F. A BFILE stores unstructured binary data in operating system files.

Correct answer: D, E, F

Explanation

Option D is correct because a CHAR column, by default, is defined with a length of 1 if not specified. Options E and F are also correct as they accurately describe how BLOB and BFILE types work with binary data. The other options contain inaccuracies regarding the specifications and behaviors of CHAR and VARCHAR2 data types.