Preventive Maintenance Principles - MySQL Questions and Answers

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on ” Principles of Preventive Maintenance”.

1. The recovery of data changes made since a given point in time is called _____________
a) decremental
b) incremental
c) close
d) clear
View Answer

Answer: b
Explanation: Incremental recovery refers to the recovery of data changes made since a given point in time. It is performed after restoring a full backup that brings the server to its state as of the time the backup was made.

2. What performs a key distribution analysis and stores the distribution for the named table or tables?
a) ANALYZE TABLE
b) CHECK TABLE
c) CHECKSUM TABLE
d) OPTIMIZE TABLE
View Answer

Answer: a
Explanation: ‘ANALYZE TABLE’ performs a key distribution analysis and stores the distribution for the named table or tables. For the MyISAM tables, this statement is equivalent to using ‘myisamchk –analyze’.

3. Which of the following columns is not returned by ‘OPTIMIZE TABLE’?
a) Table
b) Op
c) Msg_type
d) Msg_txt
View Answer

Answer: d
Explanation: ‘OPTIMIZE TABLE’ table catches and throws any errors that occur while copying table statistics from the old file to the newly created file. It returns a result set of columns.

4. REPAIR TABLE does not work for _____________
a) MyISAM
b) ARCHIVE
c) InnoDB
d) CSV
View Answer

Answer: c
Explanation: ‘REPAIR TABLE’ works for MyISAM, ARCHIVE, and CSV tables. For MyISAM tables, it has the same effect as ‘myisamchk –recover’ tbl_name by default. This statement does not work with views.

5. The binary protocol is easy to use.
a) True
b) False
View Answer

Answer: b
Explanation: The binary protocol is more difficult to use because more setup is necessary for transmitting and receiving data values. The binary protocol does not support all statements like ‘USE’.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. What is a synonym for CHARACTER SET?
a) CSET
b) CHSET
c) CHARSET
d) CHCSET
View Answer

Answer: c
Explanation: ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.

7. The line which is written at the top of the script to write a Perl script using CGI.pm is ______________
a) use this CGI
b) put CGI
c) use CGI
d) include CGI
View Answer

Answer: c
Explanation: In order to write a Perl script that uses the ‘CGI.pm’ module, a ‘use CGI’ statement is included near the beginning of the script that imports the function names of the module.

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]

« Prev - MySQL Questions and Answers – Setting Up Secure Connections

» Next - MySQL Questions and Answers – Performing Database Maintenance with the Server Running

Related Posts:

Recommended Articles: