Consider the index information for the dept_emp table in the employee’s schema:Which two conclusions can be made based on the output of the query? (Choose two.)
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)
Which three allocate memory per thread in MySQL? (Choose three.)
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.What will happen when this occurs?
You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backupThe operation completed without error.What is the state of this backup and operation required before it is ready to be restored?
