SOUNDEX

DIFFERENCE

GROUPING

SUBSTRING

Select isnumeric('Test Text')

Select numeric('Test Text')

Both of the above

none of the above

&

LIKE

%

NONE

Functions always return the same result any time they are called with a specific set of input values.

Functions may return different results each time they are called with a specific set of input values

None

Both of Them

TEXT

IMAGE

FLOAT

1) and 2)

1024

4096

512

2048

True

False

PL/SQL program needs to be recompiled frequently.

/SQL program that spends most of the time executing SQL

PL/SQL program , which performs computation-intensive procedural operations and is recompiled rarely

PL/SQL program , which is called frequently with the same parameter values by multiple sessions and is recompiled rarely.

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

True

False

True

False