Tag: databases
Questions Related to databases
-
Table Space
-
Bufferpools
-
Table
-
Rows
-
When it is created
-
When it is referenced in an INSERT statement
-
The first time any executable SQL statement references it
-
Any time an executable SQL statement references it
-
Read stability (RS)
-
Repeatable Read (RR)
-
Uncommited Read (UR)
-
Cursor Stability (CS)
-
View
-
Table
-
Routine
-
Package
-
View
-
Catalog Table
-
Stored Procedure
-
Global Temprory Table
-
Compression does not entail table or index compression and vice-versa.
-
Encryption stores the encryption keys for the LOB columns inside the database.
-
Encryption stores the encryption keys for the LOB columns outside the database.
-
Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.
-
tablespace
-
to store data and control information
-
datafile
-
instance
-
The L_OUT variable must be initialized to an empty locator.
-
The L_OUT variable has to be declared as a temporary LOB.
-
The A_CLOB variable has to be declared as a temporary LOB.
-
The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.
-
V_BLOB should be initialized to EMPTY_BLOB().
-
The WRITE routine of DBMS_LOB should be used instead of LOADFROMFILE.
-
The return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement.
-
OPEN, CLOSE, and READONLY routines of DBMS_LOB should be used instead of FILEOPEN, FILECLOSE, and FILE_READONLY.