Oracle Advanced PL/SQL Developer Professional Guide

Chapter 6, Working with Large Objects

Question No.	Answer	Explanation
1	a	LOBs can appear as a database column or a user defined object type attribute.
2	b	LOB type parameters can exist.
3	a	LOB data greater than 4 K is stored out of line with the current row. Mandatorily, it's a different LOB segment which may or may not be in the same tablespace.
4	b	The BLOB column must be initialized with EMPTY_BLOB()
5	c	The constructor methods EMPTY_CLOB() and EMPTY_BLOB() are used to initialize NULL and NOT NULL LOB types.
6	b and c	FILEOPEN works only with BFILEs.
7	b	Temporary LOBs are session specific.
8	c and d	BFILE is a read-only type. The files accessed through the BFILE locator open in read-only mode. They cannot be ...