Oracle Advanced PL/SQL Developer Professional Guide

Practice exercise

1. Internal LOBs can be used as attributes of a user-defined data type.
   1. True
   2. False
2. Internal LOBs cannot be passed as parameters to PL/SQL subprograms.
   1. True
   2. False
3. 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
4. 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 the above 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. ...