Oracle
1Z0-883 · Question #58
Mysqldump was used to create a single schema backup; Shell> mysqldump u root p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running…
The correct answer is D. Shell> mysql u root -p e `use sakila; source sakila2013.sql' E. Shell> mysql u root p silent < sakila2013.sql. See the full explanation below for the reasoning.
Question
Mysqldump was used to create a single schema backup; Shell> mysqldump u root p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?
Options
- AMysql> USE sakila; LOAD DATA INFILE `sakila2013.sql';
- BShell> mysql u root p sakila sakila2013.sql
- CShell> mysql import u root p sakila sakila2013.sql
- DShell> mysql u root -p e `use sakila; source sakila2013.sql'
- EShell> mysql u root p silent < sakila2013.sql
How the community answered
(39 responses)- A13% (5)
- B8% (3)
- C5% (2)
- D74% (29)
Community Discussion
No community discussion yet for this question.