1Z0-071 practice question 13 of 35

Whith three statements are true about built in data types?

Full set: 326 questions
Answer options
A: A VARCHAR2 blank pads column values only if the data stored is non numeric and contains no special characlers
B: A BFILE stores unstructured binary data in operating systerm files Correct answer
C: A CHAR column definition does not require the length to be specified
D: The default length for a CHAR column is always one character Correct answer
E: A VARCHAR2 column definition does not require the length to be specified
F: A BLOB stores unstructured binary data within the database Correct answer
Correct Answer:
B. A BFILE stores unstructured binary data in operating systerm files; D. The default length for a CHAR column is always one character; F. A BLOB stores unstructured binary data within the database
Explanation

The BFILE data type stores a locator to a binary file stored externally in the operating system, not within the database itself. The BLOB data type, in contrast, stores large unstructured binary data directly inside the database. For the CHAR data type, if the length is not specified during column definition, Oracle Database defaults it to a length of one character. Therefore, statements B, D, and F are all factually correct descriptions of Oracle's built-in data types.

Why Incorrect

A. CHAR columns are blank-padded to their maximum length, not VARCHAR2 columns, which store only the characters entered.
C. While technically true that length is not required (as it defaults), option D is more specific and accurate about the default behavior. In the context of choosing the best three answers, D is a better choice.
E. The length for a VARCHAR2 column is mandatory and must be specified in its definition; there is no default.

References

1. Oracle Database SQL Language Reference, 19c, E96341-13. "Data Types", Section 2.

BFILE: "The BFILE data type enables access to binary file LOBs that are stored in file systems outside the Oracle database." (Section 2-22)

BLOB: "The BLOB data type stores unstructured binary large objects." (Section 2-22)

CHAR: "If you do not specify size, then the default is 1." (Section 2-6)

VARCHAR2: "You must specify size for a VARCHAR2 column." (Section 2-7)

Scroll to Top