You create a new,empty database called test. You want to change the database sCHARACTER SET to latin1 and the database s
Posted: Sun Jun 11, 2023 4:01 pm
You create a new,empty database called test. You want to change the database sCHARACTER 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. 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.