Tag: databases

It loads the Java code into the database.

It publishes Java methods in CardValidation.java

It loads the metadata related to the Java class file into the database.

It loads the Java class file into the Java pool in the database instance.

Query results are bigger than the available space in the result cache are not cached

Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in query.

All query results are stored in the result cache if possible.

Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query

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

They cannot use redo logging.

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

They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column

SecureFiles storage can be used for internal and external LOBs

ASSM must be enabled for a tablespace to store SecureFile LOBs

SecureFile is the default storeage paradigm for all LOBs

SecureFile options enabled for a LOB column can be overridden on a per-LOB basis wihtin the LOB column

Only local subroutins can be inlined

Inlining always reduces the execution time for the PL/SQL program unit

PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2

the PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining

DDL report for all objects dependent on a table

DDL report for all the invalidated objects in a schema

data definition language (DDL) report for all the tables in a schema

DDL report for all the objects stored in a tablespace

A cursor variable points to the current roe in the result set of a multirow query stored in work area

A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored.

A cursor variable can be used only if a query is performed and its results are processed in the same subprogram.

A cursor variable can be used to perform a query in one subprogram , and process results in a different sub program

It is a standard method to enforce information integrity

It is a standard method to manipulate data in databases

They are policies to enforce security access to database

Are method that allow users to authenticate

When a field that is a primary key cannot be used a foreign key because of security policies

When a primary key is composed by more than field

When a primary key is a set of fields that are foreign keys

When a set of fields that are foreign keys are set as a primary key

stack variables and other info

session's variables and arrays

session info stored in PGA

binding variables and runtime buffers