1z0-071 Exam QuestionsBrowse all questions from this exam

1z0-071 Exam - Question 234


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

Show Answer
Correct Answer: ADEF

The default length for a CHAR column is always one character because if you define a CHAR column without specifying the length, it will default to 1 character. A BLOB stores unstructured binary data within the database, allowing you to store large amounts of binary data in the database itself. A BFILE stores unstructured binary data in operating system files, providing a reference in the database to access binary files stored outside of the database.

Discussion

4 comments
Sign in to comment
tom100menOptions: DEF
Apr 19, 2024

DEF for me, CHAR default is 1 byte, we can use: CREATE TABLE tmp (col CHAR);

billysunday1Options: AEF
Mar 30, 2024

Answer is A,E,F

ogi33
Apr 26, 2024

If you do not specify a qualifier, the value of the NLS_LENGTH_SEMANTICS parameter of the session creating the column defines the length semantics, unless the table belongs to the schema SYS, in which case the default semantics is BYTE.

ogi33
Apr 26, 2024

NOT ALWAYS ONE CHARACTER

a947739
Jul 13, 2024

you can't create a table in ORACLE without specifying the length in CHAR column