adplus-dvertising

Welcome to the Performance Tuning and Optimization MCQs Page

Dive deep into the fascinating world of Performance Tuning and Optimization with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Performance Tuning and Optimization, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Performance Tuning and Optimization, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Performance Tuning and Optimization. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Performance Tuning and Optimization. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Performance Tuning and Optimization MCQs | Page 7 of 12

Explore more Topics under SQL Server

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

a.

TID

b.

RID

c.

PID

d.

SID

Discuss
Answer: (b).RID
Q62.
Point out the correct statement.

a.

Deadlocking is same as normal blocking

b.

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

c.

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

d.

All of the mentioned

Discuss
Answer: (c).A deadlock occurs when there is a cyclic dependency between two or more threads for some set of resources
Q63.
______________ allow concurrent transactions to read (SELECT) a resource.

a.

Update locks

b.

Shared locks

c.

Exclusive Locks

d.

All of the mentioned

Discuss
Answer: (b).Shared locks
Q64.
Which is the most restrictive isolation level in transaction?

a.

Repeatable Read

b.

Snapshot

c.

Read Committed

d.

SERIALIZABLE

Discuss
Answer: (d).SERIALIZABLE
Q65.
Point out the wrong statement.

a.

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

b.

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

c.

Disallowing a locking level can affect concurrency adversely

d.

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

Discuss
Answer: (b).By default, SQL Server transactions times out after a certain time
Q66.
__________ locks allow processes to bulk copy data concurrently into the same table.

a.

Bulk update

b.

Bulk import

c.

Bulk export

d.

Bulk copy

Discuss
Answer: (a).Bulk update
Q67.
Which of the following locking hint is similar to NOLOCK?

a.

PAGLOCK

b.

READCOMMITTED

c.

READUNCOMMITTED

d.

SERIALIZABLE

Discuss
Answer: (c).READUNCOMMITTED
Q68.
Which of the following mode indicates the intention of the transaction to read all of the resources lower in the hierarchy?

a.

IS

b.

IX

c.

SIX

d.

All of the mentioned

Discuss
Answer: (c).SIX
Q69.
Which of the following lock is incompatible with all lock modes?

a.

Intent exclusive (IX)

b.

Schema stability

c.

Schema modification

d.

Bulk update

Discuss
Answer: (c).Schema modification
Q70.
Which of the following mode has exclusive range and exclusive resource lock?

a.

RangeX_X

b.

RangeS_U

c.

RangeS_S

d.

RangeI_N

Discuss
Answer: (a).RangeX_X
Page 7 of 12

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...