SQL Server Mock Test 5

10%

Question 1 of 10

1. Service broker was added to SQL Server ___________

2008

2005

2000

2012

Question 1 of 10

Question 2 of 10

2. Which of the following SQL syntax elements is dictated by the SQL dialect levels?

Parameter marker support

Nested query support

LIKE support

None of the mentioned

Question 2 of 10

Question 3 of 10

3. Query alternative to the following SQL code in LINQ is ____________

SELECT TOP 10 UPPER (c1.Name)
FROM Customer c1
WHERE
   c1.Name LIKE 'A%'
   AND c1.ID NOT IN
   (
      SELECT TOP 20 c2.ID
      FROM Customer c2
      WHERE c2.Name LIKE 'A%'
      ORDER BY c2.Name
   ) 
ORDER BY c1.Name

var query =
   from c in db.Customers
   where c.Name.StartsWith ("A")
   orderby c.Name
   select c.Name.ToLower();
var thirdPage = query.Skip(20).Take(10);

var query =
   from c in db.Customers
   where c.Name.EndsWith ("A")
   orderby c.Name
   select c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

var query =
   from c in db.Customers
   where c.Name.StartsWith ("A")
   orderby c.Name
   select c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

var query =
   from c in db.Customers
   where c.Name.StartsWith ("65")
   orderby c.Name
   select c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

Question 3 of 10

Question 4 of 10

4. Point out the wrong statement.

Replication is object level low availability feature

All of the mentioned

Replication allows to maintain some part of the database (a set of required objects) at users location

Log shipping and mirroring allows to maintain complete database redundancy

Question 4 of 10

Question 5 of 10

5. Point out the correct statement.

Loosely coupled applications are supported by the Service broker

Each Service Broker conversation is considered to be a dialog where only participants are involved

Service broker find applications when a single SQL server instance is used

None of the mentioned

Question 5 of 10

Question 6 of 10

6. Which of the following makes data available for replication?

Distributor

Subscription

Publisher

Article

Question 6 of 10

Question 7 of 10

7. The easiest way to start is to create a linked server 'localhost' by using _____________

sp_addlinkedsrvlogin 'localhost'

sp_addlinkedserv 'localhost'

sp_addlinkedserverlogin 'localhost'

sp_addlinkedserver 'localhost'

Question 7 of 10

Question 8 of 10

8. ________ parameter specifies the number of rows in a batch in bulk insert script.

KEEPIDENTITY

KEEPNULLS

FIRE_TRIGGERS

None of the mentioned

Question 8 of 10

Question 9 of 10

9. The key counters for Integration Services and SQL Server are _______________

Process Bytes

Public Bytes

All of the mentioned

Private Set

Question 9 of 10

Question 10 of 10

10. Which of the following query combines data from more than one SQL Server instance?

None of the mentioned

 USE SCRATCH
   GO
  SELECT TOP 500 *
  FROM REMOTE.Scratch.dbo.Table1 T1
  OUTER JOIN REMOTE.Scratch.dbo.Table2 T2
  ON T1.ID
  = T2.ID

 USE SCRATCH
   GO
  SELECT TOP 1000 *
  FROM REMOTE.Scratch.dbo.Table1 T1
  INNER JOIN REMOTE.Scratch.dbo.Table2 T2
  ON T1.ID
  = T2.ID

USE SCRATCH
   GO
  SELECT *
  FROM dbo.Table1 T1
  INNER JOIN REMOTE.Scratch.dbo.Table2 T2
  ON T1.ID
  = T2.ID
  WHERE T1.GUIDSTR < '001'

Question 10 of 10

« Prev - SQL Server Mock Test 4

» Next - SQL Server Mock Test 6