Question 51 : The ______ pre-compiler translates embedded SQL into calls to the Oracle runtime library.
1. Pro*C
2. ORM
3. ApexSQL
4. None of the mentioned
View Answer   Discuss with Members

Question 52 : LINQ to Entities applications requires __________ mapping provider.
1. DataClient
2. EntityClient
3. SqlClient
4. All of the mentioned
View Answer   Discuss with Members

Question 53 : Point out the wrong statement :
1. LINQ to SQL is translated to SQL by way of Binary Trees
2. LINQ to SQL is translated to SQL calls and executed on the specified database while LINQ to Objects is executed in the local machine memory
3. LINQ to SQL is translated to SQL calls and executed on the specified database while LINQ to Objects is executed in the local machine memory
4. LINQ to SQL needs a Data Context object
5.
View Answer   Discuss with Members

Question 54 : LINQ to SQL in SQL Server fully supports :
1. Transactions
2. Functions
3. Stored Procedures
4. All of the mentioned
View Answer   Discuss with Members

Question 55 : Point out the wrong statement :
1. Compared to SQL, LINQ is complex, tidier, and lower-level
2. LINQ supports ad hoc join
3. Another benefit of LINQ is that you can query across relationships without having to join
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 56 : LINQ Query to list all purchases of $1000 or greater made by customers who live in Washington :
1.

FROM p IN db.PurchasesWHERE p.Customer.Address.State == "WA" || p.Customer == NULLWHERE p.P 
  2.  
FROM p IN db.PurchasesWHERE p.Customer.Address.State == "WA" || p.Customer == NULLWHERE p.P 
 3.  
FROM p IN db.PurchasesWHERE p.Customer.Address.State == "WA" || p.Customer == NULLWHERE p.P 
  4.  None of the mentioned 

                                                
                                                    
                                                     View Answer
                                                       Discuss with Members
                                            

Question 57 : __________object is used to fill a DataSet/DataTable with query results in ADO.net.
1. DataReader
2. Dataset
3. DataAdapter
4. DataTables
View Answer   Discuss with Members

Question 58 : The main features of dotConnect for SQL Server includes :
1. Extra data binding capabilities
2. Ability of monitoring query execution
3. Supports the latest versions of SQL Server
4. All of the mentioned
View Answer   Discuss with Members

Question 59 : Which of the following gives trusted Connection from a CE device ?
1.

connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;Integrated Security=SSPI;User ID=myDomain\UserName;Password=Password;

2.

connetionString="Data Source=ServerName; Integrated Security=SSPI;User ID=myDomain\UserName;Password=Password;

3.

connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;User ID=myDomain\UserName;Password=Password;

4. All of the mentioned
View Answer   Discuss with Members

Question 60 : Syntax for closing and opening the connection in ADO.net is :
1. sqlConn.Open() and sqlConn.close()
2. sqlConn.open() and sqlConn.Close()
3. sqlConn.Open() and sqlConn.Close()
4. None of the mentioned
View Answer   Discuss with Members