Mysql Interview Question and Answers

11. What are ENUMs used for in MySQL?
  You can limit the possible values that go into the table.
CREATE TABLE months (month ENUM ’January’, ’February’, ’March’,); INSERT months VALUES (’April’).
12. What are the advantages of Mysql comparing with oracle?
  MySql is Open source, which can be available any time. Provides Gui with Command Prompt. Supports the administration using MySQL Admin,MySQL Query Browser.Oracle is best database ever in Software development.
13. What is the difference between CHAR_LENGTH and LENGTH?
  The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
14. How are ENUMs and SETs represented internally?
  As unique integers representing the powers of two, due to storage optimizations.
15. How do you change a password for an existing user via mysqladmin?
  mysqladmin -u root -p password "newpassword"
12345678910 Page 3 of 10