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

Questions: 1/15

Question

Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?

options


Questions: 2/15

Question

What is the function of DBCC CHECKDB command in SQL Server 2008?

options


Questions: 3/15

Question

Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

options


Questions: 4/15

Question

Which of the following rules must be followed for combining the result sets of two queries by using UNION?

options


Questions: 5/15

Question

Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?

options


Questions: 6/15

Question

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

options


Questions: 7/15

Question

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

options


Questions: 8/15

Question

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

options


Questions: 9/15

Question

Which of the following statements are true?

options


Questions: 10/15

Question

Which of the following statements are true regarding row and page compression in SQL Server 2008?

options


Questions: 11/15

Question

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

options


Questions: 12/15

Question

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

options


Questions: 13/15

Question

Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?

options


Questions: 14/15

Question

Which of the following are valid DATETIME functions in SQL Server 2008?

options


Questions: 15/15

Question

Which of the following counters are used to monitor compression of the whole instance of SQL Server?

options


Questions: 1/15

Question

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

options


Questions: 2/15

Question

What is the syntax required to load and use a normal unmanaged windows DLL (e.g. kernel32.DLL) in a managed .NET C# code?

options


Questions: 3/15

Question

Suppose there is a List of type Person with a property of LastName(string) and PopulateList is a function which returns a Generic List of type Person:
List people = PopulateList();

What does the statement below do?
people.Sort((x, y) => string.Compare(x.LastName, y.LastName));

options


Questions: 4/15

Question

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

options


Questions: 5/15

Question

Is it possible to define custom Exception classes in C#?

options


Questions: 6/15

Question

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

options


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

Question

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

options


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

Question

Which of the following functions are used to wait for a thread to terminate?

options


Questions: 11/15

Question

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

options


Questions: 12/15

Question

What is the benefit of using a finally{} block with a try-catch statement in C#?

options


Questions: 13/15

Question

In which of the following namespaces is the Assembly class defined?

options


Questions: 14/15

Question

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

options


Questions: 15/15

Question

Working with a list of Employees:
List lstEmployees = new List
{
new Employee{Name="Harry",Age=15},
new Employee{Name="Peter",Age=22},
new Employee{Name="John",Age=45},
new Employee{Name="Harry",Age=15},
new Employee{Name="Peter",Age=22},
new Employee{Name="John",Age=45},

};

It is required to filter out employees having distinct names.
Which one of the following options cannot be used?

options


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

Question

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

options


Questions: 3/15

Question

Consider the following code snippet:

namespace ExtensionMethods
{
public static class NumericExtensionMethods
{
public static bool IsNumeric(this string s)
{
float output;
return float.TryParse(s, out output);
}
}
}

After adding the namespace, how will you call the ExtensionMethod on the string if your string variable is defined as:

string test="4

options


Questions: 4/15

Question

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

options


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

Question

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

options


Questions: 8/15

Question

Which of the following is NOT a valid data source control in .Net framework 4.0?

options


Questions: 9/15

Question

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

options


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

Question

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

options


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

Question

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

options


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


Previous Question

00:00