Which step do you perform to create the contents of the data directory?

You have installed MySQL Server for the first time on your system. However, the data directory along withthe tables in the mysql system database are missing. Which step do you perform to create the contents ofthe data directory? A. Run the create_system_tables.sql file B. Run the mysql_unpack.sql file C. Invoke mysqld with the –initialize option. […]

Read More

Which are three facts about backups with mysqldump?

Which are three facts about backups with mysqldump? A. will lock all storage engines for duration of backup B. can back up a remote database server C. allow a consistent backup to be taken D. are able to back up specific items within a database E. create automatically compressed backups F. are always faster to […]

Read More

Which two statements are true about this feature?

Consider the key buffer in a MySQL server. Which two statements are true about this feature? A. It caches index blocks for MyISAM tables only. B. It caches index blocks for all storage engine tables. C. It is a global buffer. D. It is set on a per-connection basis. E. It caches index blocks for […]

Read More

Which statement is true?

You have a MySQL instance with the following variables in the /etc/my.cnf file: You issue these statements: USE prices; UPDATE sales.january SET amount=amount+1000; An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again. Which statement is true? […]

Read More

What is the order of tables shown in an EXPLAIN output?

What is the order of tables shown in an EXPLAIN output? A. It lists tables from the smallest to the largest. B. It lists tables in the order in which their data will be read. C. It lists tables from the most optimized to the least optimized. D. It lists tables in the order in […]

Read More

What could explain this error?

A master-slave replication setup has the slave showing this error: On the master server, the binary logs show: What could explain this error? (Choose two.) A. binlog_cache_size=1024 is too small and transactions are lost. B. binlog_format=STATEMENT and a non-deterministic query was executed. C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave. D. […]

Read More

What are two possible causes for this error to occur?

A MySQL replication slave is set up as follows: Uses all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find these entries: What are two possible causes for this error to occur? A. The applications […]

Read More