The logging option to enable binary log index file is _______?

Review the verified answer and explanation for this SPSC – Sindh Public Service Commission past-paper question on CampusFin.

The logging option to enable binary log index file is _______? Answer: –log-bin-index

The logging option to enable binary log index files in MySQL is the log_bin system variable, which is set in the server's configuration file (like my.cnf or my.ini) to a base name for the binary log files. When enabled, MySQL automatically creates a binary log file with an associated .index file to keep track of their locations.

Question context

This question is part of 🪟 SQL Server within the broader 🖥️ Software Engineering subject and appears in the SPSC – Sindh Public Service Commission preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.