Q. Which of the following code will retrieve all products in the Beverages category sorted by product name?

View solution

Q. Which of the following sample code is used to retrieve single row at a time?

View solution

Q. Which of the following method is used to delete records in LINQ?

View solution

Q. Which of the following code in LINQ performs functionality similar to joins in SQL?

View solution

Q. Service broker was added to SQL Server ___________

View solution

Q. Point out the correct statement.

View solution

Q. There are _________ components of the Service broker in SQL Server.

View solution

Q. Which of the following service broker component defines the infrastructure used for exchanging messages between instances?

View solution

Q. Point out the wrong statement.

View solution

Q. Service Broker also provides security by preventing __________ access from networks and by message encryption.

View solution

Q. (SSBS) is a new architecture which allows you to write ____________ message based application.

View solution

Q. Which of the following change was introduced in SQL Server 2012 related to Service Broker?

View solution

Q. Which of the following is a Service Broker Related Dynamic Management View?

View solution

Q. Which of the utility is used for reporting the issue in Service Broker?

View solution

Q. ___________ is a set of technologies for copying and distributing data and database objects from one database to another.

View solution

Q. Point out the correct statement.

View solution

Q. How many types of replication is provided by SQL Server?

View solution

Q. Replication in SQL Server is used to overcome ________________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following stored procedure provide replication support for AlwaysOn?

View solution