ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam
Go to Exam

Exam 1z0-908 topic 1 question 67 discussion

Actual exam question from Oracle's 1z0-908
Question #: 67
Topic #: 1
[All 1z0-908 Questions]

Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

  • A. All databases are backed up to the output file.
  • B. All non-active binary logs are removed from the master.
  • C. All binary logs are deleted from the master.
  • D. All binary logs are backed up and then deleted.
  • E. All databases, excluding master metadata, are backed up to the output file.
  • F. All details regarding deleted logs and master metadata are captured in the output file.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by FelipeK at April 19, 2023, 9:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dmees
11 months, 2 weeks ago
AC. D. All binary logs are backed up and then deleted (FALSE): The mysqldump command doesn't have the capability to back up binary logs. It only deals with backing up database schemas and data.
upvoted 1 times
...
LrnsTgh
1 year ago
Selected Answer: AC
AC. >8.0.26 use --delete-source-logs
upvoted 1 times
...
FelipeK
1 year, 3 months ago
Selected Answer: AC
A-All databases are backed up to the output file. This is true because the --all-databases option tells mysqldump to dump all databases. C-All binary logs are deleted from the master. This is true because the --delete-master-logs option tells mysqldump to delete all binary logs on the master server2. However, it’s important to note that deleting the MySQL binary logs with mysqldump --delete-master-logs can be dangerous if your server is a replication source server, because replicas might not yet fully have processed the contents of the binary log
upvoted 1 times
...
marklv
1 year, 5 months ago
incorrect not D, it doesn't backup them up
upvoted 1 times
marklv
1 year, 3 months ago
B, non active logs i think, there is always one active log, after mysqldump it rotates the log and will purge the old ones
upvoted 1 times
marklv
6 months, 3 weeks ago
sorry me again, A. All databases are backed up to the output file. No, sys, information_schema, performance_schema are not backed up. But I think they mean yes to this. B. All non-active binary logs are removed from the master. Yes, the last binlog is active and does not get deleted. C. All binary logs are deleted from the master. No, last one is not. Tested this. D. All binary logs are backed up and then deleted. No, they are not backed up. E. All databases, excluding master metadata, are backed up to the output file. Maybe, if sys, performance_schema, information_schema are all meta, then yes, otherwise no. My guess is no. Performance_schema is not meta. F. All details regarding deleted logs and master metadata are captured in the output file. No.
upvoted 1 times
...
...
...
FelipeK
1 year, 9 months ago
Selected Answer: AD
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_delete-master-logs
upvoted 1 times
marklv
1 year, 1 month ago
A. yes, all databases are backedup. Not D, it doesn't backup binary logs. B or C, probably B, because there might logs made after the dump is started. So you are not deleting all logs.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago