SQL Server Mock Test 9

10%

Question 1 of 10

1. BI can catalyze a business’s success in terms of _____________

Distinguish the products and services that drive revenues

Ranks customers and locations based on probability

Rank customers and locations based on profitability

All of the mentioned

Question 1 of 10

Question 2 of 10

2. Which of the following resource can be locked in SQL Server?

TID

SID

RID

PID

Question 2 of 10

Question 3 of 10

3. Which of the following is the process of basing an organization’s actions and decisions on actual measured results of performance?

Slice and Dice

Institutional performance management

Gap analysis

None of the mentioned

Question 3 of 10

Question 4 of 10

4. Which of the following compression type is supported by SQL Server 2014?

Column

None of the mentioned

Both row and column

Row

Question 4 of 10

Question 5 of 10

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

CAP_CPU_PERCENT

MIN_CPU_PERCENT

MAX_MEMORY_PERCENT

MAX_CPU_PERCENT

Question 5 of 10

Question 6 of 10

6. ACTIVE_TRANSACTION has log_reuse_wait value is _________

Question 6 of 10

Question 7 of 10

7. You cannot use the ____________ statement to enable Resource Governor when in a user transaction.

ALTER GOVERNOR

ALTER RESOURCE

ALTER RESOURCE GOVERNOR

All of the mentioned

Question 7 of 10

Question 8 of 10

8. Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access?

Deadlock

Exclusive lock

Lock

Block

Question 8 of 10

Question 9 of 10

9. Which of the following query enables the Resource Governor?

None of the mentioned

ALTER RESOURCE GOVERNOR CONFIGURE;

ALTER RESOURCE GOVERNOR RECONFIGURE;

ALTER RESOURCE RECONFIGURE;

Question 9 of 10

Question 10 of 10

10. Which of the following condition will ignore the request to enable delayed durability?

DELAYED_DURABILITY = 0

DELAYED_DURABILITY = FORCED

DELAYED_DURABILITY = NULL

DELAYED_DURABILITY = IGNORED

Question 10 of 10