Tag: databases

Corelated Subquery

Index

TOP()

None

1,10

10,10

1,249

249,1

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.