SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
Search
Test your basic knowledge |
Data Backup And Recovery
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 38 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A Perl script that copies tables to a backup directory; requires the DBI module to be installed
mysqlhotcopy
InnoDB Hot Backup
binary portability for InnoDB
Unix and Netware
2. 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
binary log
binary portability for MyISAM
file-locking behavior
copy command (cp or tar)
3. With binary backup methods - it is important to make sure that the server does not ________ the files while the backup is in progress
modify
mysqlhotcopy world./Country/ /var/archiv
binary portability for MyISAM
tablespace
4. It is faster to make binary backups because it involves only file copy operations that need not know the ________ of the file
internal structure
dumping table contents to text format (using mysqldump)
binary portability for InnoDB
SELECT ... INTO OUTFILE
5. It is ________ to make a text backup because the server must read tables(which involves the overhead of interpreting their contents) and then either write the contents out to disk files itself or send the contents to a client program that writes the
portable
modify
slower
mysqlhotcopy world./Country/ /var/archiv
6. 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
binary portability for InnoDB
modify
file-locking behavior
exact copies
7. 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
binary backup
SELECT...INTO OUTFILE SQL statement or mysqldump
portable
client host
8. Backups can be made by copying files directly or by using programs such as __________ - mysqlhotcopy - and InnoDB Hot Backup
binary portability for InnoDB
dumping table contents to text format (using mysqldump)
binary portability
mysqldump
9. mysqlhotcopy command to backup only the tables in the world database who name contains Country
binary portability for InnoDB
Unix and Netware
mysqlhotcopy world./Country/ /var/archiv
portable
10. This statement writes the contents of an arbitrary result set to a disk file on the server host
Restoration
binary portability
SELECT ... INTO OUTFILE
MyISAM
11. To force the use of lowercase database and table names what option can you set and what value specifically must you give it?
textual backup
lower_case_table_names=1
slower
binary portability for MyISAM
12. 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
exact copies
mysqlhotcopy
file-locking behavior
machine independent
13. What table types does mysqlhotcopy work for?
storage engine
MyISAM
mysqldump
dumping table contents to text format (using mysqldump)
14. 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
tablespace
must be copied
mysqlhotcopy world./Country/ /var/archiv
exact copies
15. Restoration from a __________: loading the file contents back into databases by processing them through the server
portable
textual backup
text backup
binary backup
16. mysqlhotcopy command to backup the world database to a directory named world /var/archive directory
mysqlhotcopy world /var/archive
must be copied
internal structure
binary portability for InnoDB
17. A dump of database contents into text files
text backup
mysqlhotcopy
MyISAM
server
18. For a tab-delimited data file made with mysqldump using the --tab option - where does the server write the file?
modify
machine independent
binary backup
server host
19. Text backup procedures are more general because they can be used for tables created by any __________
binary portability for InnoDB
mysqlhotcopy
dumping table contents to text format (using mysqldump)
storage engine
20. 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 _______
destination server
MySQL server
portable
binary portability
21. Text backups are _____ so the text backup made on one machine can be reloaded into the MySQl server on another machine - regardless of architecture
binary log
portable
file-locking behavior
mysqlhotcopy
22. If conditions for binary portability are not satisfied - you can copy MyISAM and InnoDB table from one server to another: dump them using some text format(can use mysqldump) and reloading them into the ____________
destination server
mysqlhotcopy
client host
SELECT...INTO OUTFILE SQL statement or mysqldump
23. If a binary backup is to be used to transfer databases to another machine - the backup must have ____________
client host
mysqlhotcopy
binary backup
binary portability
24. ______ from a binary backup: copy the files back to their original locations
mysqlhotcopy world./Country/ /var/archiv
text backup
Restoration
internal structure
25. During text backups the _____ must be running because it must read the files that are to be backed up
dumping table contents to text format (using mysqldump)
server
server host
binary log
26. What mysql client program allows you to make binary MyISAM backups by doing the locking and flushing for you?
textual backup
mysqlhotcopy
server host
modify
27. To make a binary backup: using the ______________ - mysqlhotcopy - or InnoDB Hot Backup
copy command (cp or tar)
client host
binary portability
SELECT ... INTO OUTFILE
28. An alternative to making a binary backup - can be useful for copying individual InnoDB tables from one server to another or if conditions for binary portability are not satisfied. also can be used to add tables from one tablespace to another
slower
machine independent
dumping table contents to text format (using mysqldump)
mysqlhotcopy
29. 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 ___________
lower_case_table_names=1
client host
internal structure
mysqlhotcopy world./Country/ /var/archiv
30. Allows you to take a binary backup that was made on one machine and use it on another machine that has a different architecture
binary backup
MySQL server
binary portability
mysqlhotcopy world /var/archive
31. What are the two backup formats?
binary and textual
dumping table contents to text format (using mysqldump)
mysqlhotcopy
file-locking behavior
32. 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
SELECT...INTO OUTFILE SQL statement or mysqldump
textual backup
binary portability for InnoDB
slower
33. What program can be used to make binary InnoDB backups
binary portability
dumping table contents to text format (using mysqldump)
storage engine
InnoDB Hot Backup
34. Contains a record of data changes - make backups regularyly - enable this so you have a record of changes made after a given backup
binary log
text backup
binary portability for MyISAM
exact copies
35. What does mysqlhotcopy run on?
server
destination server
mysqlhotcopy world /var/archive
Unix and Netware
36. What techniques are used for making text backups?
binary portability for MyISAM
mysqlhotcopy
dumping table contents to text format (using mysqldump)
SELECT...INTO OUTFILE SQL statement or mysqldump
37. Portability of an InnoDB tablespace is dependent upon all individual InnoDB tables within the ________ must be portable; If one isn't - the entire tablespace is not binary portable
tablespace
Unix and Netware
client host
textual backup
38. 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
binary portability for MyISAM
textual backup
binary portability for InnoDB
machine independent