Practice exercise
Internal LOBs can be used as attributes of a user-defined data type:
True.
False.
Internal LOBs cannot be passed as parameters to PL/SQL subprograms:
True.
False.
Internal LOBs can be stored in a tablespace that is different from the tablespace that stores the table containing the
LOBcolumn:True.
False.
You issue the following command to create a table called
LOB_STORE:CREATE TABLE
LOB_store (LOB_id NUMBER(3), photo BLOBDEFAULT EMPTY_CLOB(), cv CLOBDEFAULT NULL, ext_file BFILE DEFAULT NULL) /Identify the issue in this script:
The table is created successfully.
It generates an error because a
BLOBcolumn cannot be initialized withEMPTY_CLOB().It generates an error because
DEFAULTcannot be set toNULLfor aCLOBcolumn during table creation.It generates an error because
DEFAULTcannot be set toNULLfor aBFILEcolumn during table creation.
Identify the correct statements relating to the initialization of LOBs:
An internal
LOBcannot be initialized in theCREATETABLEstatement...
