SQL Server Practice Test 9

1. Point out the wrong statement.

BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data

Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer

Data is factual information for analysis

None of the mentioned

2. Which of the log_reuse_wait_desc value has log_reuse_wait value 0?

NOTHING

All of the mentioned

ACTIVE_TRANSACTION

CHECKPOINT

3. Point out the correct statement.

All of the mentioned

Deadlocking is same as normal blocking

A deadlock occurs when there is a cyclic dependency between two or more threads for some set of resources

No other transactions can read or modify data locked with shared lock

4. The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.

ITransJoin

None of the mentioned

IactionJoin

ITransactionJoin

5. ____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool.

MAX_MEMORY_PERCENT

CAP_CPU_PERCENT

MAX_CPU_PERCENT

MIN_CPU_PERCENT

6. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?

Server

Database

Membership

Client

7. Which of the following query deletes a job candidate?

BEGIN TRANSACTION;
GO
DELETE FROM HumanResources.JobCandidate
    WHERE JobCandidateID = 13;
GO
ROLLBACK TRANSACTION;

BEGIN TRANSACTION;
GO
DELETE FROM HumanResources.JobCandidate
    WHERE JobCandidateID = 13;
GO
COMMIT TRANSACTION;

BEGIN TRANSACTION;
GO
DELETE FROM HumanResources.JobCandidate
    WHERE JobCandidateID = 13;
GO
END;

All of the mentioned

8. Implicit transactions are maintained by SQL Server for ___________

DDL

All of the mentioned

DML

SELECT

9. Point out the wrong statement.

Disallowing a locking level can affect concurrency adversely

By default, SQL Server transactions times out after a certain time

Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required

Schema modification (Sch-M) locks are used when a table data definition language operation is being performed

10. Point out the correct statement.

SQL-92 was the third revision of the SQL database query language

You can use ROLLBACK WORK TRANSACTION to erase all data modifications made from the start of the transaction

Transaction ID Returns an object that can be used to specify configuration options for a subsequent call to ITransactionJoin

COMMIT WORK syntax, with or without specifying the optional keyword WORK, is compatible with SQL-92