Q201
Which program performs logical backups?
A.
mysqlimport
B.
mysqldump
AnswerC.
myslqpit
D.
mysqllogic
Answer: Option B
Solution
Answer: Option B
Solution:
This question is asking about a program that creates a logical backup of a MySQL database. A logical backup means that the program creates a copy of the data itself, not the physical files on the server.
Here's a breakdown of the options:
* Option A: mysqlimport This program is used to import data into a MySQL database, not for backing up data.
* Option B: mysqldump This program is used to dump the data from a MySQL database into a file. This is a common method for creating logical backups.
* Option C: myslqpit This option is incorrect. There is no program called "myslqpit" in MySQL.
* Option D: mysqllogic This option is incorrect. There is no program called "mysqllogic" in MySQL.
Therefore, the correct answer is Option B: mysqldump