SQLXML Interview Questions

Q: Which of the following is not a xml data type method ?

The correct answer is None of the Mentioned

Q: Which of the following indexes can be created on XML columns?

The correct answer is All of the Mentioned

Q: What is the purpose of primary XML index ?

The correct answer is None of of the Mentioned

Q: Statement for dropping XML index is :

The correct answer is DROP INDEX

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is not a xml data type method ?

A. query()

B. value()

C. nodes()

D. None of the Mentioned

Correct Answer is : None of the Mentioned

2. Which of the following indexes can be created on XML columns?

A. Primary

B. Secondary

C. Full-text

D. All of the Mentioned

Correct Answer is : All of the Mentioned

3. SQL Server lets you define how many types of secondary XML indexes?

A. 3

B. 4

C. 5

D. 6

Correct Answer is : 3

4. What is the purpose of primary XML index ?

A. Persisted representation of data

B. Shredded representation of data

C. Structured representation of data

D. None of of the Mentioned

Correct Answer is : None of of the Mentioned

5. Statement for dropping XML index is :

A. DROP INDEX

B. DELETE INDEX

C. REMOVE INDEX

D. None of the Mentioned

Correct Answer is : DROP INDEX

SQLXML interview questions