Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 234

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

    Correct Answer: A, E, F

    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
tom100menOptions: DEF

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

billysunday1Options: AEF

Answer is A,E,F

a947739

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

ogi33

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

NOT ALWAYS ONE CHARACTER