Multiple choice technology databases

Which statements are true about internal LOBs?

  1. They can be used as attributes of a user-defined data type.

  2. They cannot use redo logging.

  3. They cannot be passed as parameters to PL/SQL subprograms.

  4. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

Internal LOBs can be used as attributes within user-defined data types (object types), allowing structured data with large object components. They also support separate tablespace storage from their parent table for better management. They DO use redo logging (contrary to option B) and CAN be passed as parameters to PL/SQL subprograms (contrary to option C).

Keep practicing — related questions