Point Out The Correct Statement #220
Point out the correct statement.
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 SQL Server Beyond Relational - Working With XML Data - Quiz No.3.
Point out the correct statement.
If ALTER INDEX ALL is specified, it applies to both non-XML and XML indexes
The rebuild and set option IGNORE_DUP_KEY is not valid for XML indexes
The option DROP_EXISTING is permitted in the ALTER INDEX statement
The modifications of the primary key constraint in the user table are not automatically propagated to XML indexes
Similar question(s) are as followings:
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
