this question from MYSQL book What program can be run instead of using the CHECK

ID: 3786977 • Letter: T

Question

this question from MYSQL book

What program can be run instead of using the CHECK TABLE and REPAIR TABLE statements?

Two files are needed to do a PITR: the last full backup and the _______ ____.

Common options for the backup program begin with what symbols?

What command is used in a backup script to prevent other users from writing to a table while the script is running?

What command is used in a backup script to permit other users to update a table while the script is running?

What is enabled to create incremental backups?

What command is used to check if tables have been corrupted during an unexpected server shutdown?

Script code which is specific only to MySQL (and is ignored by another type of database server) begins with what three symbols?

What command is used to fix a MyISAM table?

What must be running when repairing an MyISAM table with the REPAIR TABLE statement?

Script code which is specific only to MySQL (and is ignored by another type of database server) ends with what two symbols?

What program is used to create a full backup?

The program to create a full backup is run using the __________ __________.

The REPAIR TABLE statement also checks to see if an __________ is required.

The full backups are stored in what type of file? SQL

Mysqlcheck and Myisamchk program is used instead of check and repair table

Two files are needed for PITR: the backup file and archived log

Common option for backup program begins with / symbol

LOCK TABLE and UNLOCK TABLE are used in backup command to prevent write process while backup process

Only read lock permits the other user while running backup script.

Hot backup must be enabled during the incremental

Backup

MYISAM table can be fix using the normal SQLstatements

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.