MySQL Questions and Answers – Making Database Backups

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Making Database Backups”.

1. How is the binary log rotated?
a) FLUSH LOGS
b) ROTATE LOGS
c) FLUSH BINLOG
d) ROTATE BINLOG
View Answer

Answer: a
Explanation: MySQL supports incremental backups. The server should be started with the ‘–log-bin’ option to enable binary logging. The binary log files provide information to replicate changes to the database.

2. How is a delimited-text data file reloaded?
a) mysqlexport
b) mysqlimport
c) mysqlexpand
d) mysqltransfer
View Answer

Answer: b
Explanation: In order to reload a delimited-text data file, use ‘LOAD DATA INFILE’ or ‘mysqlimport’. MySQL supports the incremental backups when the server is started with the ‘–log-bin’ option.

3. Which program performs logical backups?
a) mysqlimport
b) mysqldump
c) myslqpit
d) mysqllogic
View Answer

Answer: b
Explanation: The ‘mysqldump’ performs logical backups. It produces a set of SQL statements that are executed to reproduce the original database object definitions. It dumps one or more MySQL databases for backup.
advertisement
advertisement

4. The option that suppresses output unless there are errors in the table is _____________
a) –silent
b) –wild
c) –suppress
d) –noout
View Answer

Answer: a
Explanation: In MySQL, the ‘–silent’ option suppresses the output unless there are errors in the tables. The ‘cron’ jobs typically generate a mail message if a job produces any output at all.

5. What is the return value from operations returning a row count?
a) $rc
b) $rv
c) $rows
d) $ary
View Answer

Answer: c
Explanation: The Perl Non-handle variable ‘$ary’ is an array or list representing a row of values returned by a query. ‘$rc’ returns code from operations that return true or false. ‘$rv’ returns value from operations that return an integer. ‘$rows’ returns value from operations that return a row count.
Note: Join free Sanfoundry classes at Telegram or Youtube

6. Functions are called and pointers to structures are used while using DBI API.
a) True
b) False
View Answer

Answer: a
Explanation: While using the DBI API functions are called and pointers to structures are used. The functions are called “methods,” pointers are called “references,” pointer variables are called “handles”.

7. The mode of search in which the search string is parsed into words and the search looks for rows is ________________
a) Boolean mode
b) Natural language
c) Query expansion
d) Cross mode
View Answer

Answer: b
Explanation: In MySQL, a full text search capability is provided, which enables to look for words or phrases without using pattern-matching operations. There are three kinds of full text searches.
advertisement

8. What is the hub of a MySQL installation?
a) mysqla
b) mysqlb
c) mysqlc
d) mysqld
View Answer

Answer: d
Explanation: The server, mysqld is the hub of a MySQL installation; it performs all manipulation of databases and tables. On Unix, several related scripts are available to assist in server startup.

9. The place where the server stores its databases and status files are called the data directory.
a) True
b) False
View Answer

Answer: a
Explanation: The MySQL data directory is the place where the server stores its databases and status files. It is crucial to understand all the structures and contents of the data directory.
advertisement

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.