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 creation.

  4. It generates an error because DEFAULT cannot be set to NULL for a BFILE column during table creation.

• Identify the correct statements relating to the initialization of LOBs:

  1. An internal LOB cannot be initialized in the CREATE TABLE statement...