Which of the following index options are added by CREATE INDEX statement ?
A. XML INDEX
B. INCLUDED (column)
C. PARTITION SCHEME
D. ONLINE
Answer:A
Which of the following index options are added by CREATE INDEX statement ?
A. XML INDEX B. INCLUDED (column) C. PARTITION SCHEME D. ONLINE
Explanation:CREATE INDEX includes the following new syntax elements:XML INDEX,INCLUDED and PARTITION SCHEME.