You create a new,empty database called ‘test’. You want to change the database ‘s
CHARACTER SET to “latin1” and the database ‘sCOLLATION to ‘latin_german_ci’.
Which statement is true?
A.
You can do this one command:
ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci
B.
You can only do this with two separate commands:
ALTER DATABASE ‘test’ CHARACTER SET latin1
ALTER DATABASE ‘test’ COLLATE latin_german1_ci
C.
You cannot change the CHARACTER set or COLLATION value on an existing database.
D.
Databases do not have CHARACTER SET or COLLATION attributes.
A
A
choose A because it is a new,empty database, otherwise is C
You can change character set and collation on a existing database.
It will be changed for the new created tables.
The old tables wont be converted.