Q. Which statement is used to show the server’s current character set and collation settings?

View solution

Q. What does UTF stand for int utf8?

View solution

Q. Prior to MySQL 6.0, utf8 was ___________

View solution

Q. Post MySQL 6.0, utf8 was ___________

View solution

Q. What is generally used as a synonym for CHARACTER SET?

View solution

Q. Which statement is used to select a default database?

View solution

Q. Which keyword is the synonym for DATABASE?

View solution

Q. It is not required to have an access privilege for a database before selecting it with ‘USE’.

View solution

Q. Which keyword is used to create a database?

View solution

Q. The file created by the server to store the database attributes is __________

View solution

Q. To create a database only if it doesn’t already exist, which clause is used?

View solution

Q. If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

View solution

Q. MySQL stores the database character set and collation attributes in the file _________

View solution

Q. Which statement is used to see the definition for an existing database?

View solution

Q. Which statement makes changes to the database’s global attributes?

View solution

Q. Which statement is used to remove indexes on tables?

View solution

Q. Which storage engine is not available in MySQL 5.0?

View solution

Q. The default storage engine used is ____________

View solution

Q. What is the name of the format file for a table named my_tbl?

View solution

Q. In the CREATE TABLE statement, the engine name specified is case sensitive.

View solution