Q. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________

View solution

Q. To reload a delimited text data file use ______________

View solution

Q. Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.

View solution

Q. SBR replication is ______________

View solution

Q. The library file that contains various portability macros and definitions is ______________

View solution

Q. The header that should be included first is ______________

View solution

Q. What is the general statement-issuing routine?

View solution

Q. The option that specifies the data directory location at server startup is ______________

View solution

Q. The datadir variable value can be seen using ______________

View solution

Q. Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.

View solution

Q. Which data directory subdirectory corresponds to the nbdinfo database?

View solution

Q. Encrypted connections can be established using ______________

View solution

Q. What is exec_stmt_ssl written in?

View solution

Q. What is the embedded server library containing the MySQL server linkable into applications?

View solution

Q. What is the embedded server library when building from source enabled by?

View solution

Q. Multiple statement execution is not enabled by default.

View solution

Q. An embedded application includes the server side and client side.

View solution

Q. Each database has a data directory located under database directory.

View solution

Q. In the database directory of the database each view and trigger object is associated with how many files?

View solution

Q. What is the maximum number of characters allowed for a database name to have?

View solution