adplus-dvertising
frame-decoration

Question

Point out the correct statement.

a.

If ALTER INDEX ALL is specified, it applies to both non-XML and XML indexes

b.

The rebuild and set option IGNORE_DUP_KEY is not valid for XML indexes

c.

The option DROP_EXISTING is permitted in the ALTER INDEX statement

d.

The modifications of the primary key constraint in the user table are not automatically propagated to XML indexes

Posted under SQL Server

Answer: (c).The option DROP_EXISTING is permitted in the ALTER INDEX statement

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Point out the correct statement.
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following function returns an instance of the XML data type?

View solution

Q. SQL Server provides how many Xquery methods?

View solution

Q. Point out the correct statement.

View solution

Q. What is every identifier in an XQuery called?

View solution

Q. Every database you create has which collection by default?

View solution

Q. Different types of errors raised during Xquery operation are ______________

View solution

Q. Functions on numerical values in Xquery are ___________

View solution

Q. Atomization is process of extracting ________ value of an item.

View solution

Q. With XML DML, which of the operations can be performed on nodes?

View solution

Q. Why do we use exist methods in Xquery?

View solution

Q. Full-Text Search in SQL Server lets users and applications run _________ queries.

View solution

Q. Point out the correct statement.

View solution

Q. Full-text search is an ________ component of the SQL Server Database Engine.

View solution

Q. We can create a full-text index on _____________

View solution

Q. Point out the wrong statement.

View solution

Q. Full text indexing is a great feature that solves a database problem, the searching of _________ columns for specific words and phrases in SQL Server databases.

View solution

Q. Which of the following predicates is used for full text search?

View solution

Q. FREETEXTTABLE is a full text _____________

View solution

Q. The CONTAINS and FREETEXT predicates return a _________ value.

View solution

Q. CONTAINS and CONTAINSTABLE look for a _______ match for the phrase.

View solution
View All MCQs on SQL Server

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!

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Computer Architecture

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

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...