In MySQL, the SHOW VARIABLES statement is used to display the current system variables, including the character set and collation settings.

To check the current character set and collation for the server, you can run:

SHOW VARIABLES LIKE 'character_set%';

SHOW VARIABLES LIKE 'collation%';

This will return the character set and collation settings for various components like the server, client, connection, and database.

Why the other options are incorrect:

• (A) DISP VARIABLES: This is not a valid MySQL command.
• (B) SHOW CONSTRAINTS: This command is used to display constraints in the database, not character set or collation.
• (C) SHOW CONSTANTS: There is no SHOW CONSTANTS command in MySQL. It’s not valid.

Therefore, the correct statement to show the server’s current character set and collation settings is (D) SHOW VARIABLES.