SQL Server Practice Test 5

1. Point out the wrong statement.

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

Replication is object level low availability feature

Log shipping and mirroring allows to maintain complete database redundancy

All of the mentioned

2. Point out the correct statement.

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

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

Loosely coupled applications are supported by the Service broker

None of the mentioned

3. Point out the wrong statement.

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

LINQ to SQL needs a Data Context object

LINQ to SQL is translated to SQL by way of Binary Trees

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. ________ parameter specifies the number of rows in a batch in bulk insert script.

None of the mentioned

KEEPNULLS

FIRE_TRIGGERS

KEEPIDENTITY

5. Which is the default field terminator for bulk insert in SQL Server?

Parenthesis

Brackets

Comma

Full stop

6. Point out the wrong statement.

None of the mentioned

The maintenance of the Service Broker is difficult

The developers can design applications from independent components known as “services"

Maintenance of Service Broker is a part of the routine database

7. Which of the following is a bulk import operation?

INSERT..SELECT

BULK INSERT

All of the mentioned

bcp

8. Which of the following script is example of SQL injection attack?

var Shipcity;
ShipCity = Request.form ("ShipCity");
var sql = "select * from OrdersTable where ShipCity = '" + ShipCity + "'";

var Shipcity;
ShipCity = Request.form ("ShipCity");

All of the mentioned

var Shipcity;
var sql = "select * from OrdersTable where ShipCity = '" + ShipCity + "'";

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

dm_broker_activated_tasks

sys.dm_broker_tasks

sys.dm_broker_activated

sys.dm_broker_activated_tasks

10. Which of the following steps should be carried out using data types in SSIS for efficient results?

Do not perform excessive casting of data types

None of the mentioned

Do not watch precision issues when using the money, float, and decimal types

Make data types as wide as possible so you will allocate more memory for your transformation