Oracle Exam 1Z0-920 Topic 1 Question 44 Discussion

Actual exam question for Oracle's 1Z0-920 exam

Question #: 44
Topic #: 1

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

AOn the Master server, disable binlog by removing the --log-bin option.

BSet the expire_logs_days system variable to expire binary log files automatically after a given number of days.

CTo safely purge binary log files, perform these steps:
1. On each slave server, use show slave status to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with show binary logs.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file by using the purge binary logs statement

DExecute the purge binary logs statement without argument.

EDelete all binlog files manually on the file system to release storage spaces.

Show Suggested Answer

Suggested Answer: B, C

by James at May 03, 2022, 03:52 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-920 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!