Home/ Questions/Q 352182
Next
In Process
Naina Faraz Barad
Asked: 2022-11-08T18:29:22+05:30 In:

Which statement is used to show the server’s current character set and collation settings?

(a) SHOW CONSTANTS

(b) SHOW CONSTRAINTS

(c) SHOW VARIABLES

(d) DISP VARIABLES

Which statement is used to show the server’s current character set and collation settings?

(a) SHOW CONSTANTS

(b) SHOW CONSTRAINTS

(c) SHOW VARIABLES

(d) DISP VARIABLES
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. Correct option is (c) SHOW VARIABLES

    Easy explanation: The statement ‘SHOW VARIABLES LIKE ‘character\_set\_%” displays a table consisting of two columns, ‘Variable_name’ and ‘Value’. Replacing characer\_set\_% with collation\_% shows the collation variables.

    • 0