nerdexam
Oracle

1Z0-146 · Question #132

Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)

The correct answer is B. FILEOPEN can be used to open only external LOBs in the indicated mode. C. OPEN can be used to open internal and external LOBs in the indicated mode. See the full explanation below for the reasoning.

Question

Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)

Options

  • AOPEN can be used to open only internal LOBs in the indicated mode.
  • BFILEOPEN can be used to open only external LOBs in the indicated mode.
  • COPEN can be used to open internal and external LOBs in the indicated mode.
  • DFILEOPEN can be used to open internal and external LOBs in the indicated mode.

How the community answered

(18 responses)
  • A
    11% (2)
  • B
    83% (15)
  • D
    6% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice