Question 4 (1 point) Why should you add the “add-drop-table” to the mysqldump ut
ID: 3911021 • Letter: Q
Question
Question 4 (1 point)
Why should you add the “add-drop-table” to the mysqldump utility?
a
It will remove all MySQL tables before creating the restored tables.
b
It will set the table permissions so the administrator can drop the table at a later date.
c
It will remove table relationships so that inserts can take place.
d
It will remove table indexes to promote faster database restoration.
a
It will remove all MySQL tables before creating the restored tables.
b
It will set the table permissions so the administrator can drop the table at a later date.
c
It will remove table relationships so that inserts can take place.
d
It will remove table indexes to promote faster database restoration.
Explanation / Answer
The result of add-drop-table is that if a table exists it will still let you drop the table. Hence the correct option b. It will set the table permissions so the administrator can drop the table at a later date.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.