Which two statements are true about the initialization of internal LOBs?

Which two statements are true about the initialization of internal LOBs? (Choose two.)

Which two statements are true about the initialization of internal LOBs? (Choose two.)

A.
The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal
LOBs.

B.
The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL
internal LOBs.

C.
The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and
non-NULL internal LOBs.

D.
The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and
EMPTY_BLOB() functions, respectively.

E.
The CLOB and BLOB columns can be initialized with a character or raw string, respectively,
provided they are less than 4000 bytes in size.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

PIERO

PIERO

OPS C,E
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements001.htm

Clusters cannot contain LOBs, either as key or non-key columns.

The following data structures are supported only as temporary instances. You cannot store these instances in database tables:

VARRAY of any LOB type

VARRAY of any type containing a LOB type, such as an object type with a LOB attribute

ANYDATA of any LOB type

ANYDATA of any type containing a LOB

You cannot specify LOB columns in the ORDER BY clause of a query, or in the GROUP BY clause of a query or in an aggregate function.

You cannot specify a LOB column in a SELECT… DISTINCT or SELECT… UNIQUE statement or in a join. However, you can specify a LOB attribute of an object type column in a SELECT… DISTINCT statement or in a query that uses the UNION or MINUS set operator if the column’s object type has a MAP or ORDER function defined on it.

You cannot specify LOB columns in ANALYZE… COMPUTE or ANALYZE… ESTIMATE statements.

The first (INITIAL) extent of a LOB segment must contain at least three database blocks.

When creating an UPDATE DML trigger, you cannot specify a LOB column in the UPDATE OF clause.

You cannot specify a LOB column as part of an index key. However, you can specify a LOB column in the indextype specification of a domain index. In addition, Oracle Text lets you define an index on a CLOB column.

In an INSERT… AS SELECT operation, you can bind up to 4000 bytes of data to LOB columns and attributes.

If a table has both LONG and LOB columns, you cannot bind more than 4000 bytes of data to both the LONG and LOB columns in the same SQL statement. However, you can bind more than 4000 bytes of data to either the LONG or the LOB column.

Reply