Oracle
1Z0-908 · Question #29
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?
The correct answer is D. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql. https://mysqlserverteam.com/introducing-mysqlpump/
Backup and Recovery
Question
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?
Options
- Amysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- Bmysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- Cmysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
- Dmysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
How the community answered
(26 responses)- A8% (2)
- B4% (1)
- C19% (5)
- D69% (18)
Explanation
Topics
#mysqlpump#parallel backup#ndbinfo database#sys database
Community Discussion
No community discussion yet for this question.