Answer - The LOB datatypes includes BLOB, CLOB, NCLOB and BFILE that can
store large blocks of unstructured data such as graphic images, video clips,
and sound wave. LOB datatypes can be stored within a table, out-of-line within
a tablespaces using a LOB locator, or in an external file (BFILE datatypes).
Explain ROWID in oracle.
Answer - Each table in oracle has a pseudocolumn called ROWID. Oracle
uses ROWID to store address of each rows of the table. Oracle uses ROWID to
maintain indexes. Each key in an index is associated with a ROWID that points
to the associated row's address for fast access.
No comments:
Post a Comment