Home > IT Support > Quizzes > Data Backup And Recovery
Data Backup And Recovery
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 12% • Most missed: “During text backups the _____ must be running because it must read the files tha…”
Data Backup And Recovery
Time left 00:00
25 Questions

1. mysqlhotcopy command to backup the world database to a directory named world /var/archive directory

2. A copy of the files in which database contents are stored; copying these files preserves the database in exactly the same format in which MySQL itself stores them on disk

3. What are the two backup formats?

4. A binary backup that makes a complete InnoDB backup (a backup of all tables in the InnoDB tablespace) is based on __________ of all files that InnoDB uses to manage the tablespace

5. Contains a record of data changes - make backups regularyly - enable this so you have a record of changes made after a given backup

6. If a binary backup is to be used to transfer databases to another machine - the backup must have ____________

7. During text backups the _____ must be running because it must read the files that are to be backed up

8. Text backup procedures are more general because they can be used for tables created by any __________

9. You can directly copy the tablespace files from a MySQL server on one machine to another server on a different machine and the second server will be able to access the tablespace

10. Backups can be made by copying files directly or by using programs such as __________ - mysqlhotcopy - and InnoDB Hot Backup

11. ______ from a binary backup: copy the files back to their original locations

12. A dump of database contents into text files

13. You can directly copy the files for a MyISAM table from one MySQL server to another on a different machine and the second server will be able to access the table

14. On Windows this influences file copying during a binary MyISAM backup - It is such that you might not be able to copy table files for tables that are locked by the server. In these cases - you must stop the server before copying the table files

15. Files that _________ when making a binary backup: .frm - .MYD - and .MYI files that MySQL uses to represent the table - stop the server while copying the tables - leave the server running - but be sure to use an appropriate locking protocol to preve

16. Allows you to take a binary backup that was made on one machine and use it on another machine that has a different architecture

17. What does mysqlhotcopy run on?

18. For a tab-delimited data file made with mysqldump using the --tab option - where does the server write the file?

19. What program can be used to make binary InnoDB backups

20. Binary portability means that binary backup files are ___________ and you can directly copy them from one MySQl server to another on a different and the second server will access them with no problems

21. Restoration from a __________: loading the file contents back into databases by processing them through the server

22. With binary backup methods - it is important to make sure that the server does not ________ the files while the backup is in progress

23. Binary backups are less general because they are dependent upon what storage engines was used to create the tables and generally can only be used for the local _______

24. It is faster to make binary backups because it involves only file copy operations that need not know the ________ of the file

25. For SQL-format dump files that contain CREATE TABLE and INSERT statements for re-creating the tables - server sends table contents to mysqldump which writes the files on the ___________

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Hardware and Network Maintenance Practice Test: Windows Server, Linux server, Internet and Web Browser Google IT Support Professional Certification - Course 2:- The Bits And Bytes Of Networking IT Operations / IT Support Skills Test ICTSM Practice Test: Computer Networks Testout Network Pro Review IT Support Exam Review Security + Certification Exam Computer Tech Support Practice Computer Hardware and Network Maintenance Practice Test: Introduction to Computers and Hardware Assembly Google IT Support - Course 4: System Administration and IT Infrastructure Services
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.