MySQL Access Control and Security


  1. The value of event_scheduler that enables checking status but not changing it at runtime is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, if the event_scheduler is set to ‘DISABLED’ at startup, its status cannot be changed but can be checked at runtime. The events can be created but they will not execute.


  1. The statement that is used to check the status of the event scheduler at runtime is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    In MySQL, in order to check the status of the event scheduler at runtime, the statement: SHOW VARIABLES LIKE ‘event_scheduler’; is used. The event_scheduler is a system variable.



  1. The line that is not used to turn on the event scheduler is _________________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The line ‘event_scheduler = ON’ is put in the option file that the server reads. The event scheduler does not run by default. It must be turned on if events are to used in the database.


  1. REGEXP does not take collation into account.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    MySQL provides pattern matching based on the ‘REGEXP’ operator and regular expressions that are similar to those used in Unix programs, namely, grep, sed and vi. REGEXP does not take collation into account.



  1. What does the expression ‘2 BETWEEN 2 AND 5’ result in?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The ‘BETWEEN ……. AND’ clause is used to return a boolean value, if the given operand value lies between the values specified by the ‘AND’ clause. The range endpoints are inclusive.