ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 247 discussion

Actual exam question from Oracle's 1z0-071
Question #: 247
Topic #: 1
[All 1z0-071 Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: DEF 🗳️
by billysunday1 at March 30, 2024, 8:51 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
bca123
6 months, 4 weeks ago
Selected Answer: AEF
But based on the scheme ans, id D is correct , then A should be correct!
upvoted 1 times
...
65e59ac
10 months, 1 week ago
Yes, you can create a table in ORACLE without specifying the length in CHAR column. D is right.
upvoted 1 times
...
a947739
1 year ago
you can't create a table in ORACLE without specifying the length in CHAR column
upvoted 1 times
...
ogi33
1 year, 3 months ago
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.
upvoted 1 times
ogi33
1 year, 3 months ago
NOT ALWAYS ONE CHARACTER
upvoted 1 times
...
...
tom100men
1 year, 3 months ago
Selected Answer: DEF
DEF for me, CHAR default is 1 byte, we can use: CREATE TABLE tmp (col CHAR);
upvoted 3 times
HICH9173
11 months, 3 weeks ago
you mean ADE
upvoted 1 times
...
...
billysunday1
1 year, 3 months ago
Selected Answer: AEF
Answer is A,E,F
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel