Client/Server Concepts
23 important questions on Client/Server Concepts
What is the default socket file location?
What are the 2 possible actions to connect to a MySQL server on localhost but not via a socket?
2. Use --protocol=tcp
What is the default mysql user name on windows and what on linux?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is the default password for a MySQL account?
What are the two differences of the --password option compared to the rest of the shared MySQL client options?
2. In short form there is no space allowed between -p and the password
How do you connect with an empty password?
What does the option --compress do?
What is the purpose of the [group_names] in MySQL configuration files?
What is the general group name in a MySQL configuration file specifying all clients?
What are the default locations for MySQL configurations files on Windows?
What are the default locations for MySQL configuration files on Unix?
What are the 3 options for specifying alternate or no configuration files?
--defaults-extra-file (use also this configuration file)
--no-defaults (use no configuration files)
What 2 commands can be used in configuration files to reference other configuration files?
!includedir <directory>
What is the advantage of selecting a default database?
What command clears the sql_mode?
How do you set both sql_mode ANSI_QUOTES and IGNORE_SPACE?
What are 2 composite sql_modes?
2. TRADITIONAL
What does the sql_mode TRADITIONAL do?
What does the sql_mode ANSI do?
What do sql modes STRICT_ALL_TABLES AND STRICT_TRANS_TABLES do?
What does the sql mode ERROR_FOR_DIVISION_BY_ZERO do?
What does the sql mode IGNORE_SPACE do?
What does the sql mode ANSI_QUOTES do?
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding