-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Advanced Oracle PL/SQL Developer's Guide (Second Edition)
By :

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 LOB
column:
True.
False.
You issue the following command to create a table called LOB_STORE
:
CREATE TABLELOB
_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:
The table is created successfully.
It generates an error because a BLOB
column cannot be initialized with EMPTY_CLOB()
.
It generates an error because DEFAULT
cannot be set to NULL
for a CLOB
column during table creation.
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:
An internal LOB
cannot be initialized in the CREATE
TABLE
statement...
Change the font size
Change margin width
Change background colour