adplus-dvertising
frame-decoration

Question

Which collations does this MySQL statement list? 
SHOW COLLATION LIKE 'utf8%'

a.

names beginning with utf8

b.

names ending with utf8

c.

names containing utf8% anywhere

d.

names ending in utf8%

Posted under MySQL Database

Answer: (a).names beginning with utf8

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which collations does this MySQL statement list?
Add Comment

Similar Questions

Discover Related MCQs

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
View All MCQs on MySQL Database

Suggested Topics

Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...