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

Exam 1z0-148 All Questions

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

Exam 1z0-148 topic 1 question 29 discussion

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

Which statement is true about internal and external LOBs?

  • A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.
  • B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
  • C. Internal and external LOBs can be written using DBMS_LOB.
  • D. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
  • E. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
Reference:
https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_lob.htm
by orakell at Dec. 1, 2019, 4:44 p.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
Rakeshpro
2 years, 4 months ago
Selected Answer: A
NOEXIST_DIRECTORY: Directory does not exist WRITE: Only internal LOBS can be written After the exception transfers program control outside the PL/SQL program block, all references to the open BFILEs are lost. Only external LOBs need to be opened first, and the function to use is FILEOPEN, not OPEN.
upvoted 1 times
...
CosminCof
4 years, 2 months ago
AD correct
upvoted 1 times
...
jcamt
4 years, 3 months ago
the only answer in the documentation is D https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_lob.htm
upvoted 1 times
...
szefco
4 years, 8 months ago
I think only A is correct. Question says "which STATEMENT" (singular, so there is only 1 correct answer)
upvoted 1 times
...
kahabe59
4 years, 11 months ago
Only answer A is correct
upvoted 1 times
...
yurijk
5 years ago
A, D are correct
upvoted 2 times
...
orakell
5 years, 2 months ago
AE, not DE. Only external LOBs need to be opened first, and the function to use is FILEOPEN, not OPEN.
upvoted 1 times
orakell
5 years, 2 months ago
I meant AD, not DE, for the same reason. A and D are correct.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago