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

Questions: 1/15

Question

Which of the following data types are supported by SQL Server 2008?

options


Questions: 2/15

Question

In which of the following statements can TOP clause be used in SQL Server 2008?

options


Questions: 3/15

Question

Which function/functions are performed by the following statement?
BCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

options


Questions: 4/15

Question

The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a __________ relationship.

options


Questions: 5/15

Question

Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?

options


Questions: 6/15

Question

Analyze the following code using wild card characters of SQL Server 2008:

SELECT Name
FROM person.employees
WHERE Name LIKE '[_]n'
GO

Which of the following values will be returned by the above code?

options


Questions: 7/15

Question

How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

options


Questions: 8/15

Question

Which of the following is a valid code to change the index created on a column of a table to page compression?

options


Questions: 9/15

Question

What is the default timeout for login to sqlcmd while you try to connect to a server?

options


Questions: 10/15

Question

Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?

options


Questions: 11/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: 12/15

Question

Which of the following default passwords is used by sqlcmd if -P option is used at the end of the command prompt without a password?

options


Questions: 13/15

Question

Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?

options


Questions: 14/15

Question

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

options


Questions: 15/15

Question

What is the default precision of the date data type in SQL Server 2008?

options


Questions: 1/15

Question

What will happen if the following code is compiled in .NET 4 or above (Assume required namespaces are included)?

public class var { }
public class main
{
public static void main(string[] args)
{
var testVar = new var();
}
}

options


Questions: 2/15

Question

What is the problem with the following function, which is supposed to convert a Stream into byte array?
public static byte[] ReadFully(Stream input)
{
using (MemoryStream ms = new MemoryStream())
{
input.CopyTo(ms);
return ms.ToArray();
}
}

options


Questions: 3/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: 4/15

Question

The global assembly cache:

options


Questions: 5/15

Question

How can a single instance application be created in C#?

options


Questions: 6/15

Question

Which of the following statements is true about IEnumerable?

options


Questions: 7/15

Question

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

int num1 = 10, num2 = 9;

int result = num1 & num2;

options


Questions: 8/15

Question

Which of the following is true for CLR?

options


Questions: 9/15

Question

What are the benefits of using the ExpandoObject class over a using dictionary?

options


Questions: 10/15

Question

Which of the following will block the current thread for a specified number of milliseconds?

options


Questions: 11/15

Question

Which of the following code samples will create a comma separated list from IList or IEnumerable?

options


Questions: 12/15

Question

Which of the following will correctly remove duplicates from a List?

options


Questions: 13/15

Question

Which of the following statements is true regarding predicate delegates in C#?

options


Questions: 14/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: 15/15

Question

What is the purpose of the catch block in the following code?

try { 
// Code that might throw exceptions of different types 
}

catch { 
// Code goes here 
}

options


Questions: 1/15

Question

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

options


Questions: 2/15

Question

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

options


Questions: 3/15

Question

How can you determine, at runtime, if your application is running in the 64-bit version of .Net framework 4.0?

options


Questions: 4/15

Question

Which of the following is the correct way to expand the size of application URLs in .Net framework 4.0?

options


Questions: 5/15

Question

Which of the following arrays will be returned as result when you run the following LINQ query in .Net framework 4.0?

object[] varnumbers = { null, 1.0, "two", 3, "four", 5, "six", 7.0 };

var doubles = varnumbers.OfType();

foreach (var d in doubles)
{
Response.Write(d);
}

options


Questions: 6/15

Question

Which of the following pieces of information is provided by the WCF service contract in .Net framework 4.0?

options


Questions: 7/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: 8/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: 9/15

Question

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

options


Questions: 10/15

Question

Which of the following OData system query options is used to determine the maximum number of records to be returned in .Net framework 4.0?

options


Questions: 11/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: 12/15

Question

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

options


Questions: 13/15

Question

Which of the following statements is correct for ASP.NET MVC Routing in .Net Framework 4.0?

options


Questions: 14/15

Question

Which of the following is NOT a valid WPF Localizability attribute in .Net framework 4.0?

options


Questions: 15/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


Previous Question