Question

The variable used to set table alias names as non case sensitive is ______________

a.

lower_case_table_names

b.

lower_case_all

c.

lower_case_alias

d.

lower_case_aliases

Posted under MySQL Database

Answer: (a).lower_case_table_names

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The variable used to set table alias names as non case sensitive is ______________

Add Comment

Similar Questions

Discover Related MCQs

Q. The clause that can be used to sort string values according to a specific collation is ______________

View solution

Q. The statement used to find out which character sets are available is ______________

View solution

Q. The error log file has a suffix ______________

View solution

Q. The option which finds the startup options supported by the server through mysqld is ______________

View solution

Q. Server startup can also be done by the ______________

View solution

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

View solution

Q. The keyword used to create a database is __________

View solution

Q. Which file is created by the server to store the database attributes?

View solution

Q. What is the default storage engine?

View solution

Q. The name of the format file for a table named my_tbl is __________

View solution

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

View solution

Q. The server listens on a network port for TCP/IP connections unless started with the option ______________

View solution

Q. Which option is used to specify to the server the IP number of the server host on which the server should listen?

View solution

Q. The option used to specify the socket file pathname is ______________

View solution

Q. MySQL supports shared-memory connections on Windows.

View solution

Q. INFORMATION_SCHEMA is not based on the SQL standard.

View solution

Q. The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________

View solution

Q. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

View solution

Q. What is the join where all possible row combinations are produced?

View solution

Q. What is the clause that filters JOIN results called?

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!

Artificial Intelligence

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

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Compiler Design

Unravel the process of translating source code into executable programs with our...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...