Instead of Cursor what can be used to perform row by row operation there by increasing performance?
Corelated Subquery
Index
TOP()
None
How many clustered and non clustered indexex exists for single table
1,10
10,10
1,249
249,1
Which one of them is not an String Function?
SOUNDEX
DIFFERENCE
GROUPING
SUBSTRING
What is the function which is used to check whether the value is a numeric value or not?
Select isnumeric('Test Text')
Select numeric('Test Text')
Both of the above
none of the above
What operator performs pattern matching?
&
LIKE
%
NONE
Deterministic functions are?
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
Both of Them
SQL_VARIEANT datatype column can be any datatype except?
TEXT
IMAGE
FLOAT
1) and 2)
What is the maximum number of columns per select statement allowed in SQL 2005?
1024
4096
512
2048
Can we insert data into a view?
True
False
Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode?
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.