•  
    Questions not Attemped
  •  
    Questions Attemped
  •  
    Questions Marked for review
  •  
    Current Question
00:00

Questions: 1/15

Question

For which of the following data types can a COLLATE clause be applied?

options


Questions: 2/15

Question

What is the maximum number of columns that can be combined into a single composite index key?

options


Questions: 3/15

Question

Analyze the following permissions:

1.ALTER permission on the database.
2.CONTROL permission in the database.
3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database.

Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?

options


Questions: 4/15

Question

Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?

options


Questions: 5/15

Question

Which of the following spatial data types are used in SQL Server 2008?

options


Questions: 6/15

Question

Which of the following arguments of the fn_get_audit_file() function of SQL Server 2008 specifies the directory indicating the location and audit file set to be read?

options


Questions: 7/15

Question

Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?

options


Questions: 8/15

Question

What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?

options


Questions: 9/15

Question

Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

options


Questions: 10/15

Question

Which of the following security features have been introduced in SQL Server 2008?

options


Questions: 11/15

Question

Which of the following commands is used to start the Resource Governor in SQL Server 2008?

options


Questions: 12/15

Question

What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

options


Questions: 13/15

Question

Analyze the following data types and schemas:

1.The SQL Server system data type.
2.The default schema of the current user in the current database.
3.The dbo schema in the current database.

In which order does the SQL Server Database Engine refer to type_name when a type_schema_name is NOT specified while creating a table in SQL Server 2008?

options


Questions: 14/15

Question

Analyze the following code snippet:

DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01

options


Questions: 15/15

Question

Which of the following is the correct precedence order of the data types in SQL Server 2008?

1.xml
2.text
3.bigint
4.image
5.float
6.datetime

options


Questions: 1/15

Question

Which of the following statements are true regarding the ref and out parameters in C#?

options


Questions: 2/15

Question

Performance-wise, which of the following is the most efficient way to calculate the sum of integers stored in an object array?

options


Questions: 3/15

Question

If i == 0, why is (i += i++) == 0 in C#?

options


Questions: 4/15

Question

What is the output of the following code?

class Test
{
static void Main() {
string myString = "1 2 3 4 5"
myString = Regex.Replace(myString, @"s+", " ");
System.Console.WriteLine(myString);
}

options


Questions: 5/15

Question

What type of code is written to avail the services provided by Common Language Runtime?

options


Questions: 6/15

Question

An enum is defined in a program as follows:
[Flags]
public enum Permissions
{
None = 0,
Read = 1,
Write = 2,
Delete = 4
}

What will be the output of the following Main program (which has access to the enum defined above) in this C# console application (Assume required namespaces are included) :

static void Main(string[] args)
{
var permissions = Permissions.Read | Permissions.Write;
if ((permissions & Permissions.Write) == Permissions.Write)
{
Console.WriteLine("Write");
}
if ((permissions & Permissions.Delete) == Permissions.Delete)
{
Console.WriteLine("Delete");
}
if ((permissions & Permissions.Read) == Permissions.Read)
{
Console.WriteLine("Read");
}
Console.ReadLine();
}

options


Questions: 7/15

Question

Consider the following code block:

public class Person
{
public string GetAge()
{
lock (this)
{
// Code to get Age of this person object.
}
}
}

Which of the following statements is true?

options


Questions: 8/15

Question

Which of the following statements is true about the code below?

string[] lines = theText.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);

options


Questions: 9/15

Question

What will be the value of result after these two statements?

int num1 = 10, num2 = 9;
int result = num1 ^ num2;

options


Questions: 10/15

Question

What is the issue with the following function?

public string GetName(int iValue)
{
string sValue = "0";
switch (iValue)
{
case 1:
sValue = iValue.ToString();
case 2:
sValue = iValue.ToString();
break;
default:
sValue = "-1";
break;
}
return sValue;
}

options


Questions: 11/15

Question

Which statements will give the path where the executing assembly is currently located?

options


Questions: 12/15

Question

Which of the following is true for CLR?

options


Questions: 13/15

Question

What will be the output of the following Main program in a C# console application (Assume required namespaces are included)?
static void Main(string[] args)
{
string sPrint = String.Format("{{ My name is bond. }}");
Console.WriteLine(sPrint);
Console.ReadLine();
}

options


Questions: 14/15

Question

Which of the following define the rules for .NET Languages?

options


Questions: 15/15

Question

What will be the output if in a WinForms application, the following code is executed in the Load event of a form? Assume this form has lblMessage as a Label Control.

private void Form1_Load(object sender, EventArgs e)
{
try
{
ThreadPool.QueueUserWorkItem(ShowMessage,null);
}
catch (Exception ex)
{
}
}

private void ShowMessage(object obj)
{
try
{
lblMessage.Text = "Hello from Thread Pool";
}
catch (Exception ex)
{
}
}

options


Questions: 1/15

Question

What is a Decorator in WPF of .Net framework 4.0?

options


Questions: 2/15

Question

How will you implement the logic for the following scenario in .Net framework 4.0?

Suppose you have a GridView with paging enabled. You select the third row on page 1 and then move to page 2. Nothing is selected on page 2. When you move back to page 1, the third row should still be selected.

options


Questions: 3/15

Question

Suppose you want to eliminate duplicate elements from the array

int[] source = { 7, 4, 1, 3, 9, 8, 6, 7, 2, 1, 8, 15, 8, 23}

and sort the elements in descending order using LINQ in .Net framework 4.0. Which of the following statements can you use?

options


Questions: 4/15

Question

What is default format used to represent data returned in an ADO.NET Data Services response in .Net framework 4.0?

options


Questions: 5/15

Question

How many columns can you select by $orderby OData system query option in .Net Framework 4.0?

options


Questions: 6/15

Question

What result will you get when you run the following LINQ query in .Net framework 4.0?

List alphabets = new List() { "whats", "new", "in", "aspnet" };
var alphabetsquery = from alphabet in alphabets select alphabet.Substring(0, 1);
foreach (var alpha in alphabetsquery)
{
Response.Write(alpha);
}

options


Questions: 7/15

Question

Which of the following ASP.NET MVC namespaces includes the classes that support forms, input controls, links, partial views, and validation in .Net Framework 4.0?

options


Questions: 8/15

Question

What is the purpose of the System.Windows.Data namespace in .Net framework 4.0?

options


Questions: 9/15

Question

Which of the following classes of System.Windows.Media namespace provides rendering support in WPF which includes hit testing, coordinate transformation, and bounding box calculations in .Net framework 4.0?

options


Questions: 10/15

Question

How do you add MetaDescription to your web page in .Net framework 4.0?

options


Questions: 11/15

Question

In WCF, what is the significance of the ReceiveRetryCount property of a Poison message in .Net framework 4.0?

options


Questions: 12/15

Question

What result will you get when you run the following LINQ query in .Net framework 4.0?

var scoreRecords = new[] { new {Name = "Alice", Score = 50},
new {Name = "Bob" , Score = 40},
new {Name = "Cathy", Score = 45}
};

var scoreRecordsDict = scoreRecords.ToDictionary(sr =>sr.Name);

Response.Write(scoreRecordsDict["Bob"]);

options


Questions: 13/15

Question

Which of the following is NOT a valid QueryExtender filter option in .Net framework 4.0?

options


Questions: 14/15

Question

What is the function of WCF Data contracts in .Net framework 4.0?

options


Questions: 15/15

Question

What is DLR in .Net framework 4.0?

options


Previous Question