Q. Which statement is used to check how MySQL would execute a SELECT query?

View solution

Q. What is used to perform an analysis of key values by the server?

View solution

Q. The function used to convert an int to string is ______________

View solution

Q. The function used to convert a string to an int is ______________

View solution

Q. Which of the following is more efficient?

LOAD DATA, INSERT

View solution

Q. The MySQL server is highly configurable.

View solution

Q. Multiple MySQL servers cannot be run on the same machine.

View solution

Q. The log in which data changes received from a replication master server are written are ______________

View solution

Q. Which of these is the metadata log?

View solution

Q. The max_binlog_cache_size system variable has default size ______________

View solution

Q. What has a higher priority?

writes, reads

View solution

Q. The default scheduling property of MySQL is implemented by how many of these?

MyISAM, MERGE, MEMORY

View solution

Q. Which of these is faster when accessing data?

memory, disk

View solution

Q. The system variable controls the size of the table cache _________________

View solution

Q. Which of these exports table definitions and contents?

View solution

Q. MySQL uses security based on ACL which stands for ______________

View solution

Q. The mysql client writes a record of executed statements to a history file on Unix.

View solution

Q. A password applies globally to an account.

View solution

Q. The context in which the privilege ‘CREATE TABLESPACE’ applies is ______________

View solution

Q. The number of languages that have interfaces to bind to the C API of MySQL among these is ______________

Perl, PHP, Python

View solution