1Z0-071 practice question 13 of 35
Whith three statements are true about built in data types?
Full set: 326 questionsThe 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.
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.
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)
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
