You create a new,empty database called test. You want to change the database sCHARACTER SET to latin1 and the database s

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You create a new,empty database called test. You want to change the database sCHARACTER SET to latin1 and the database s

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply