SQL Server Indexes
Quiz
•
Computers
•
Professional Development
•
Practice Problem
•
Medium
Катерина Балик
Used 17+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The leaf nodes contain the data pages of the underlying table ... in which index type?
Nonclustered
Spatial
Clustered
Unique
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Table without a clustered index is called
Heap
Hash
B tree
Nonclustered table
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Nonclustered indexes can not be created on tables stored as a heap.
True
False
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Indexes are automatically created when PRIMARY KEY and UNIQUE constraints are defined on table columns.
True
False
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which code snippet can be used to create clustered index ?
ALTER TABLE dbo.ProductVendor CREATE CLUSTERED INDEX (VendorID)
ALTER TABLE dbo.ProductVendor ADD INDEX (VendorID)
CREATE INDEX IX_ProductVendor_VendorID ON dbo.ProductVendor (VendorID);
CREATE CLUSTERED INDEX IX_ProductVendor_VendorID ON dbo.ProductVendor (VendorID);
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which index option specifies a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild?
FILLFACTOR
FULLFACTOR
PAD_INDEX
PERCENTAGE
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Renaming an index causes the index to be rebuilt.
True
False
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
QUIZ FAST- Auditor
Quiz
•
Professional Development
11 questions
Parts and function of a Mouse
Quiz
•
Professional Development
12 questions
tubitak-quiz-1
Quiz
•
Professional Development
11 questions
Node y NPM (Parte 1)
Quiz
•
Professional Development
10 questions
SQL
Quiz
•
Professional Development
10 questions
Quiz Webinar Smartcity
Quiz
•
Professional Development
10 questions
IP Address
Quiz
•
Professional Development
15 questions
CSS
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
How to Email your Teacher
Quiz
•
Professional Development
6 questions
3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET
Quiz
•
Professional Development
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
22 questions
Multiplying Exponents with the Same Base
Quiz
•
9th Grade - Professio...
40 questions
Flags of the World
Quiz
•
KG - Professional Dev...
