PrepAway - Latest Free Exam Questions & Answers

What is the cause of the error message?

You are changing the collation on an existing database. You receive the following error
message: “The CREATE UNIQUE INDEX statement terminated because a duplicate key
was found for the object name…”. What is the cause of the error message?

PrepAway - Latest Free Exam Questions & Answers

A.
There are duplicate primary keys in the original database.

B.
You are using Windows with Language for non-Unicode programs, which is not
compatible with the original collation.

C.
During the process, there are users active in the database who are trying to insert new
data into the database.

D.
The original collation is case sensitive and the target collation is case insensitive.


Leave a Reply