单选题 Examine this command, which executes successfully:$mysqlbackup --user= dba --password --port=3306 --with-timestamp --only-know-file-types --backu p-dir= /exprot/backups backup
Which statement is true？
A、
Only tables stored in their own tablespaces are backed up
B、
Only non-encrypted files are backed up
C、
The backup incl udes only data files and their metadata
D、
Only lnnoDB data and log files are backed up
E、
Only fil es for MySQL or its built-in storage engines are backed up
单选题 You issue this command: SHOW SLAVE STATUS\GIn the output, there is a value for Seconds_ behind_ master.
How is this time calculated?
A、
It is the time between the I/0 thread receiving details of the maste r's last transaction o n and the time it was written to the relay log on the slave.
B、
It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master
C、
It is the time between the most recent transaction written to the relay logs and the time it was committed on the master
D、
It is the time between the 1/0 thread receiving details of the master's last transaction and the time it was applied by the SQL thread
单选题 Your MySQL instance is capturing a huge amount of financial transactions every day in the finance databaseCompany policy is to create a backup every day
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month
mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*"backup
Which optimization process best describes what happens with the redo logs?
A、
The redo logs are backed up only if there are changes showing for the transactions tables
B、
The transaction tables are backed up first, then the archive tab les and redo logs
C、
The redo logs are backed up first then the transaction and archive ta bles
D、
The redo logs are not backed up at all
E、
The archive tables are backed up first, then the transaction tables and redo logs
单选题 Exam ine the full path name of the backup image from MySQL Enterprise Backup with the -- compress option/backup/ful 1/mybacku p/myimage.img
mysqlbackup.cnf contains this data
[mysq I backup]
backup-d ir= /backup/ful 1/myresto re
backup-image=/backup/full/mybackup/myimag e.1mg
uncompress
You must perform a d ata base restore to a new ma chine.
which command can provision the new d atabase in datadir as /data/MEB?
A、
mysqlbackup --default s-file =mysq lbackup.cnf --datadir=/data/M EB restore-and-apply-log
B、
mysql backup --defaul ts-file =mysq lbacku p.cnf --datadir=/data/MEB image-to-dir-and-apply-log
C、
mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB apply-log-and-copy-back
D、
mysqlbackup --defaults -file=mysq lbackup.cnf --datadir=/data/MEB copy-back-and-apply-log
E、
mysql backup --defaults -file =mysq lbackup.cnf --datadir=/data/M EB image-to-dir
单选题 Examine this command, which executes successfully:mysqlbackup --user=dba --password --port =3306 --with-timestamp -- backup -dir/export/backups backup-and-apply-log
Which statement is true?
A、
The backup accesses the MySQL server files by using a pre-existing connection
B、
The database server is put into a read-only state for the duration of the backup
C、
An offline backup of lnnoDB tables is taken
D、
The backup can be impacted when DDL operations run during the backup
单选题 A developer accidentally dropped the lnnoDB table Customers from the Company d atabase.There is a datadir copy from two days ago in the dbbackup directory
Which set of steps would restore only the missing table?
A、
Stop the MySQL Server process, and execute
mysqlbackup --datadir=/var/l ib/mysql --backup-dir=/dbbackup --incl ud e-ta bles= 'Company\.Customers'copy-back
Start the mysqld process
B、
Stop the MySQL Server process and restart it with the command
mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql
Run mysqldump on this table and restore the dump file
C、
Stop the MySQL Server process and restart it with the command
mysqld --basedir =/usr/local/mysql --datadir=/dbbackup
Run mysqldump on this table and restore the dump file
D、
Stop the MySQL Server process, copy the Customers.ibd file from the dbbackup directory, and start the mysqld process
单选题 Your MySQL environment has asynchronous position-based replication with one master and one slave.The slave instance had a disk I/0 problem, so it was stopped
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged
You restart MySQL Server.
How can replication be restored?
A、
The relay logs from the master should be used to replace the corrupted relay logs
B、
The slave relay logs should be deleted; then execute START SLAVE;
C、
The slave needs to be restored from backup
D、
The slave relay logs should be deleted; execute CHANGE MASTER to a adjust the replication relay log file name,
then issue START SLAVE;
单选题 What does the slave I/O th read do?
A、
monito and schedules I/O calls to the subsystem for the relay logs
B、
connects to the master and requests it to send updates recorded in its binary logs
C、
acquires a lock on the binary log for reading each event to be sent to the slave
D、
reads the relay log and executes the events contained in them
2023-01-10
共198道
