gs gs116 Performance Tuning and Optimization - Indexing Strategies - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Performance Tuning and Optimization. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: Point out the correct statement.
The Database Engine merges the sorted runs of index leaf rows into a single, sorted stream
SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types
The fill-factor value is a percentage from 1 to 50
All of the mentioned
Question 3: Which of the following rebuilds the IX_Employee_OrganizationLevel_OrganizationNode index with a fill factor of 80 on the HumanResources.Employee table?
ALTER INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources REBUILD WITH (FILLFACTOR = 80); CREATE INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources.Employee REBUILD WITH (FILLFACTOR = 80); ALTER INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources.Employee REBUILD WITH (FILLFACTOR = 80);
All of the mentioned
Question 4: Which of the following guideline is considered during column design?
Keep the length of the index key short for non clustered indexes
An xml data type can only be a key column only in an XML index
Examine column which have composite primary keys
None of the mentioned
Question 5: Point out the wrong statement.
SQL Server supports only two index types: clustered and non-clustered
Appropriate indexes can make a world of difference in performance
SET option requires ALTER permission on the table or view
None of the mentioned
Question 6: By default, indexes are stored in the ______ filegroup as the base table on which the index is created.
same
different
may be same or different
none of the mentioned
Question 7: Specifying the order in which key values are stored in an index is useful when queries referencing the table have _____________
ORDER BY clauses
SORT clauses
WHERE clauses
None of the mentioned
Question 8: Every table should have a ________ index defined on the column or columns.
CLUSTERED
NON CLUSTERED
FULL TEXT
All of the mentioned
Question 9: Which of the following option is immediately applied to the index by using the SET clause in the ALTER INDEX statement?
ALLOW_PAGE_LOCKS
ALLOW_COLUMN_LOCKS
STATISTICS_RECOMPUTE
None of the mentioned
Question 10: Which of the following code snippet demonstrates ALTER statement with STATISTICS_NORECOMPUTE in ONLINE state?
ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 100, SORT_IN_TEMPDB = ON, STATISTICS_RECOMPUTE = ON); ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON); ALTER INDEX ALL ON Production.Product BUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON);
All of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
