1) In a SQL Statement while working with SqlCommand it returns a single value, at that time which method of Command Object will be used? a. ExecuteNonQuery b. ExecuteReader c. ExecuteScalar d. All of the above
|
||||
2) According to the given below statements, choose the correct option. Statement 1: Application caching is the process of storing data (and not pages) in a cache object. Statement 2: Page output caching stores a rendered page, portion of a page, or version of a page in memory. Statement 3: Caching reduces the time required to render cached page in future requests. a. Only statement 1 is correct. b. Statement 2 and 3 are correct. c. Only statement 3 is correct. d. All statements are correct.
|
||||
3) Which LINQ statement defines the range variable in a LINQ query? a. from b. select c. join d. where
|
||||
4) Which query expression is used to limit the number of results? a. Skip b. Take c. Where d. Select
|
||||
5) Which interface defines the basic extension methods for LINQ? a. IComparable b. IList c. IEnumerable d. IQueryable
|
||||
6) What LINQ expressions are used to shape results in a query? 1. where 2. select 3. join 4. group a. 2, 4 b. 1, 2 c. 3, 4 d. None
|
||||
7) What types of shapes can LINQ query results be shaped into? 1. Collections of primitive types 2. Collections of complex types 3. Single types 4. Collections of anonymous types a. 1, 2, 4 b. 1,2,3 c. 1,3,4 d. None of the above
|
||||
8) Which LINQ statement is used to merge two data sources to perform queries? a. where b. select c. join d. group
|
||||
9) Which LINQ keyword is used to categorize results in a query? a. where b. select c. join d. group
|
||||
10) Which of the following statements is true? a. LINQ to SQL works with any database. b. LINQ to SQL works with SQL Server. c. LINQ to SQL is a CLR feature. d. LINQ to SQL is a SQL Server feature.
|
||||
11) LINQ query can work with? a. DataSet b. List c. Array d. All of the above
|
||||
12) How you can merge the results from two separate LINQ queries into a single result set. a. Use the ToList method. b. Use the DataContractJsonSerializer class. c. Use the XElement class. d. Use the Concat method.
|
||||
13) Which of the following objects represents a LINQ to SQL O / R map? a. DataSet b. XElement c. ObjectContext d. DataContext
|
||||
14) What is lamda expression? 1. Anonymous function 2. Can be used to create delegates 3. Named function 4. None a. 1, 2 b. 1, 2, 3 c. 1, 3 d. 4
|
||||
15) Choose the correct one a. The lambda must contain the same number of parameters as the delegate type. b. The lambda should not contain the same number of parameters as the delegate type. c. The return value of the lambda (if any) must be explicitly convertible to the delegate's return type d. None of the above
|
||||
16) Choose the correct one. a. The return value of the lambda (if any) must be explicitly convertible to the delegate's return type b. Each input parameter in the lambda must be implicitly convertible to its corresponding delegate parameter. c. Lamda expression does not work with LINQ. d. None of the above
|
||||
17) Choose the correct one a. Variables introduced within a lambda expression are not visible in the outer method. b. Variables introduced within a lambda expression are visible in the outer method. c. The lambda should not contain the same number of parameters as the delegate type. d. None of the above
|
||||
18) Choose the correct option. a. Dynamic type is non - static type. b. Dynamic type is static type. c. Implicit conversion does not work with type dynamic. d. None of the above
|
||||
19) Which of the following statement is correct? a. Anonymous types are class types that derive directly from object. b. Anonymous types are not class types that derive directly from object. c. Anonymous types are class types that derive directly from System.Class. d. None of the above
|
||||
20) What types of Objects can you query using LINQ? a. DataTables and DataSets b. Any .NET Framework collection that implements IEnumerable(T) c. Collections that implement interfaces that inherit from IEnumerable(T) d. All of the above
|