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.

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

5. Identify the correct statements about the initialization of LOBs.

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

   2. The BFILE...