exam questions

Exam 1z0-908 All Questions

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

Exam 1z0-908 topic 1 question 84 discussion

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

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)

  • A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
  • B. Set binlog_expire_logs_seconds in my.cnf.
  • C. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
  • D. Use SET PERSIST binlog_expire_logs_seconds=<value>.
  • E. Use PURGE BINARY LOGS to <binlog_name>.
  • F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

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
marklv
5 months ago
EF, the other two don't make sense. You don't to restart the server, and the other just sets a variable but doesn't do anything.
upvoted 1 times
...
Dhanushka
6 months ago
Selected Answer: EF
E and F
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago