Microsoft
MB5-700 · Question #44
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…
The correct answer is D. The original collation is case sensitive and the target collation is case insensitive. See the full explanation below for the reasoning.
Question
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?
Options
- AThere are duplicate primary keys in the original database.
- BYou are using Windows with Language for non-Unicode programs, which is not compatible
- CDuring the process, there are users active in the database who are trying to insert new data
- DThe original collation is case sensitive and the target collation is case insensitive.
How the community answered
(18 responses)- A6% (1)
- B6% (1)
- C11% (2)
- D78% (14)
Community Discussion
No community discussion yet for this question.