Microsoft
MB5-700 · Question #44
MB5-700 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock MB5-700 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
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.
Unlock MB5-700 to see the answer
You've previewed enough free MB5-700 questions. Unlock MB5-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.