Upwork .Net Technology

/Upwork .Net Technology

Knowledge of SQL Server 2008 Skills Test

1. Which of the following statements using GROUP BY clause are allowed in SQL Server 2008? Answers: SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2 SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2 SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2 SELECT Column1 + Column2 FROM [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments

Knowledge of Net Framework 4.0 Skills Test

1. 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}; Answers: int findoddNumbers = numbers.Count(n => n % 2 == 1); int findoddNumbers = numbers.Count( n % 2 == 1); int findoddNumbers = (from number in numbers where numbers%2==1 select Count()); int findoddNumbers = (from [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments

Dot Net 3.5 using C# Test

1. Which of the following are static methods of the System.Reflection Activator class? Answers: CreateComInstanceFrom< CreateInstanceFrom GetInstance CreateInstance All of the above 2. Which of the following are true about Extension methods? Answers: They must be declared static They can be declared either static or instance members They must be declared in the same assembly [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments

Dot Net 2.0 using C# Test

1. Which of the following are true when comparing built in types for equality? Answers: Integral types are considered equal if they represent the same value. Object types are considered equal if they both refer to the same object or if both are null String types are considered equal if they have identical lengths and [...]

By | September 24th, 2015|Upwork .Net Technology|0 Comments

ASP.Net 3.5 using VB Test

1. Which of the following mechanisms are not suitable for returning a single row from a DataTable containing a large number of records? Answers: DataTable.Rows.Find DataTable.Rows.Select DataTable.Select Enumerating across DataTable.Rows 2. Given the following code, which of the following are syntactically correct? <Extension()> _ Public Function AppendTest(ByVal s As String, ByVal suffix As String) Return [...]

By | September 24th, 2015|Upwork .Net Technology|0 Comments

ASP.Net 3.5 using C# Test

1. Which of the following does using Initializer Syntax with a collection as shown below require? CollectionClass<int> numbers = new CollectionClass<int> { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 }; Answers: Collection Class must implement System.Collections.Generic.ICollection<T> Collection Class must implement System.Collections.Generic.IList<T> Each of the Items in the Initializer List will be passed [...]

By | September 24th, 2015|Upwork .Net Technology|0 Comments

C# Test

1. Which of the following define the rules for .NET Languages? Answers: GAC CLS CLI CTS CLR JIT 2. What is the syntax required to load and use a normal unmanaged windows DLL (e.g. kernel32.DLL) in a managed .NET C# code? Answers: Assembly.Load(''Kernel32.DLL'') LoadLibrary(''Kernel32.DLL'') [DllImport(''kernel32'', SetLastError=true)] Unmanaged DLLs cannot be used in a managed .NET [...]

By | September 24th, 2015|Upwork .Net Technology|2 Comments