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

Q. The language that is the core for APIs and communication in MySQL is ______________

View solution

Q. The most general purpose language is ______________

View solution

Q. The language in which image processing is least simple is ______________

View solution

Q. The option necessary to compile a C program havin math functions is ______________

View solution

Q. What is the option for specifying the executable name while compiling with gcc?

View solution

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