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

Questions: 1/15

Question

Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

options


Questions: 2/15

Question

Which of the following data types can be specified as SPARSE?

options


Questions: 3/15

Question

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

options


Questions: 4/15

Question

What exactly is Full-Text Catalog in SQL Server 2008?

options


Questions: 5/15

Question

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

options


Questions: 6/15

Question

What amount of storage is required by a date variable in SQL Server 2008?

options


Questions: 7/15

Question

What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?

options


Questions: 8/15

Question

The login timeout when you try to connect to a server must be a number between __________.

options


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

Question

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

options


Questions: 11/15

Question

Analyze the following code snippet:

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

options


Questions: 12/15

Question

Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?

options


Questions: 13/15

Question

Which of the following encryption algorithms are used by the Transparent Data Encryption security mechanism of SQL Server 2008?

options


Questions: 14/15

Question

What is returned by NULLIF if the two expressions that it compares are NOT equal?

options


Questions: 15/15

Question

Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?

options


Questions: 1/15

Question

Which of the following keywords prevents a class from being overridden further?

options


Questions: 2/15

Question

The global assembly cache:

options


Questions: 3/15

Question

Which type of class members are associated with the class itself rather than the objects of the class?

options


Questions: 4/15

Question

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

options


Questions: 5/15

Question

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

options


Questions: 6/15

Question

_____________ helped overcome the DLL conflict faced by the C# language versions prior to .NET.

options


Questions: 7/15

Question

Which of the following code snippets for catch shows a better way of handling an exception?

1
catch (Exception exc)
{
throw exc;
}
2
catch (Exception exc)
{
throw;
}

options


Questions: 8/15

Question

Which of the following statements is true about IEnumerable?

options


Questions: 9/15

Question

Which of the following code snippets will call a generic method when the type parameter is not known at compile time?

options


Questions: 10/15

Question

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

options


Questions: 11/15

Question

An Interface represents which kind of relationship?

options


Questions: 12/15

Question

What is an Action delegate?

options


Questions: 13/15

Question

Which of the following exceptions cannot be thrown by the Delete() function of the FileInfo class (ie. FileInfo.Delete())?

options


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

Question

Which of the following statements is true regarding the code samples below?

A: 
try {
// code goes here
} catch (Exception e) {
throw e; 
}

B:
try {
// code goes here
} catch (Exception e) {
throw; 
}

options


Questions: 1/15

Question

Which of the following statements is correct for WSHttpBinding of WCF in .Net framework 4.0?

options


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

Question

How is data passed from controllers to views in an ASP.NET MVC Application?

options


Questions: 4/15

Question

Suppose your site has a page called Index.aspx that you no longer use. Search engines may keep requesting this page.

Which of the following method will you add to the CodeBehind file of Index.aspx that will send requests (including search engine requests) to Default.aspx in .Net framework 4.0?

options


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

Question

How will you count the odd numbers from the array shown below using LINQ in .Net framework 4.0?

int[]numbers={5,4,1,3,9,8,6,7,2,0};

options


Questions: 8/15

Question

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

options


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

Question

Suppose your WCF service root URL is "http://examples.svc". What will be the response when you request a WCF data service URL with a $skip system query option, as shown below, in .Net framework 4.0?

http://examples.svc/Products?$skip=2&$top=2&$orderby=Rating

options


Questions: 11/15

Question

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

options


Questions: 12/15

Question

Which of the following statements is correct for the bubbling routing strategies used by the routing events in WPF in .Net framework 4.0?

options


Questions: 13/15

Question

What is DLR in .Net framework 4.0?

options


Questions: 14/15

Question

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

options


Questions: 15/15

Question

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

options


Previous Question