You have a database dev that contains 15 tables, all of which use the CHARACTER SET utfs and the COLLATION utfs_general_ci. You perform the command: ALTER DATABASE dev CHARACTER SET =latin COLLATION=latin1_swedish_ci What is the result?
A.
You get an error because database are not allowed to have CHARACTER SET or COLLATION attributes.
B.
You get an error because the settings for CHARACTER SET and COLLATION attributes do not match the settings for the tables inside the database.
C.
You get an error while trying to change from a more inclusive CHARACTER SET like ‘utfs to a less’ inclusive CHARACTER SET like ‘latin’.
D.
You get an error because changes to the CHARACTER SET or COLLATION attribute can happen only for empty databases.
E.
The statement succeeds and new tables created in this database use the new settings as their default values.
F.
The statement succeeds and all of the tables inside the database are converted to user the new settings.
Error Code: 1115. Unknown character set: 'latin' 0.000 sec
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-882 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chehin
2 years, 11 months ago