Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Go to Exam

Exam 98-364 topic 1 question 13 discussion

Actual exam question from Microsoft's 98-364

Question #: 13
Topic #: 1

[All 98-364 Questions]

Which statement will result in the creation of an index?

A. Option A
B. Option B
C. Option C
D. Option D

Show Suggested Answer

Suggested Answer: A 🗳️

by drx at Aug. 26, 2020, 5:32 p.m.

Comments

Submit Cancel

elkreationZ

3 years, 11 months ago

Answer is A

upvoted 1 times

...

AEscajeda

4 years, 1 month ago

In SQL Server when a Primary Key is created, a unique index is also created to reinforced uniqueness.

upvoted 4 times

...

CristianCruz

4 years, 7 months ago

I don't understand the answer

upvoted 1 times

...

Naga01

4 years, 8 months ago

Answer A is correct for creatig a table index

upvoted 1 times

...

bulat

4 years, 9 months ago

It should be A, because creating Primary Key automatically creates Index.

upvoted 2 times

Pink_Dreams

4 years, 9 months ago

I think too

upvoted 1 times

...

drx

4 years, 9 months ago

CREATE TABLE table_name (col_name column_definition, col_name column_definition, ... INDEX index_name (index_col_name, ... )

upvoted 1 times

...

drx

4 years, 9 months ago

I'm pretty sure these are all wrong. CREATE INDEX index_name ON table_name (column1, column2, ...);

upvoted 3 times

ming9213

4 years, 8 months ago

CREATE INDEX is correct but A is correct in this case because PK is automatically created as index

upvoted 3 times

...