TRANSLATE
Restricts the length of the String
Replaces a sequence of characters in a string with another set of characters
Modifies the datatype of a column
Renames a column
which of these can be used to filter aggregate functions?
WHEN
HAVING
WHERE
ANY
REPLACE
Replaces word by word
Replaces a column with another column
Replaces character by character
Replaces a row with another row
How is IN different form EXISTS ?
IN executes the inner query for each row affected by the outer query and EXISTS executes the inner query only once irrespective of the outer query
IN executes the inner query only once irrespective of the outer query and EXISTS executes the inner query only once irrespective of the outer query
IN executes the inner query only once irrespective of the outer query and EXISTS executes the outer query for each row affected by the outer query
IN executes the inner query for each row affected by the outer query and EXISTS executes the outer query for each row affected by the outer query
Which one is similar to Delegates?
Interface in Java
pointer in C or C++
function pointer in C or C++
Interface in .NET
The C# keyword int maps to which .NET type
System.Int16
System.Int32
System.Int64
System.Int8
Which of these statements correctly declares a two-dimensional array in C#?
int[,] myArray;
int[][] myArray;
int[2] myArray;
System.Array[2] myArray;
In C# Thread.Sleep(time) measures time in:
seconds
milliseconds
nanoseconds
minutes
Which access label allows the variables to be accessible in both the current assembly and by any classes derived from the base class?
private
protected
protected internal
It is not possible to do it