Advanced Oracle PL/SQL Developer's Guide - Second Edition

Practice exercise

• Internal LOBs can be used as attributes of a user-defined data type:
  1. True.
  2. False.
• Internal LOBs cannot be passed as parameters to PL/SQL subprograms:
  1. True.
  2. False.
• Internal LOBs can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column:
  1. True.
  2. False.
• You issue the following command to create a table called LOB_STORE:

  CREATE TABLE LOB_store
  (LOB_id NUMBER(3),
  photo BLOB DEFAULT EMPTY_CLOB(),
  cv CLOB DEFAULT NULL,
  ext_file BFILE DEFAULT NULL)
  /

  Identify the issue in this script:

  1. The table is created successfully.
  2. It generates an error because a BLOB column cannot be initialized with EMPTY_CLOB().
  3. It generates an error because DEFAULT cannot be set to NULL for a CLOB column during table ...