Question 41 : (SSBS) is a new architecture which allows you to write ____________ message based application.
1. asynchronous
2. decoupled
3. distributed
4. all of the mentioned
View Answer   Discuss with Members

Question 42 : Service Broker also provides security by preventing __________ access from networks and by message encryption.
1. Authorized
2. Read
3. Unauthorized
4. All of the mentioned
View Answer   Discuss with Members

Question 43 : Which of the following service broker component defines the infrastructure used for exchanging messages between instances ?
1. Conversation
2. Service definition
3. Security
4. All of the mentioned
View Answer   Discuss with Members

Question 44 : There are _________ components of the Service broker in SQL Server.
1. 2
2. 3
3. 4
4. 5
View Answer   Discuss with Members

Question 45 : Point out the correct statement :
1. Loosely coupled applications are supported by the Service broker
2. Each Service Broker conversation is considered to be a dialog where only participants is involved
3. Service broker find applications when single SQL server instance is used
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 46 : Service broker was added to SQL Server ___________
1. 2000
2. 2005
3. 2008
4. 2012
View Answer   Discuss with Members

Question 47 : Which of the following code in LINQ performs functionality similar to joins in SQL ?
1.

var categoryProducts =    FROM c IN db.Categories    SELECT NEW {c.CategoryName, productCount = products.Count()}
  2.  
var categoryProducts =    FROM c IN db.Categories    JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO products    SELECT NEW 
 3.  
var categoryProducts =    FROM c IN db.Categories    JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate 
  4.  None of the mentioned 

                                                
                                                    
                                                     View Answer
                                                       Discuss with Members
                                            

Question 48 : Which of the following method is used to delete records in LINQ ?
1. DeleteOn
2. Delete
3. DeleteOnSubmit
4. None of the mentioned
View Answer   Discuss with Members

Question 49 : DataContext object is constructed in LINQ to SQL using :
1. NorthwindDataContext db = new malloc NorthwindDataContext();
2. NorthwindDataContext db = new NorthwindDataContext();
3. NorthwindDataContext db = new NorthwindData();
4. None of the mentioned
View Answer   Discuss with Members

Question 50 : Point out the correct statement :
1. Compared to LINQ to Entities, LINQ to SQL has more limitations
2. MSL stands for Map Schema Language
3. If you want to work against a conceptual data model, use LINQ to Entities
4. Conceptual Data Model feature is present in LINQ to SQL
5.
View Answer   Discuss with Members