Q. What causes a replication master server to delete all the binary log files even if they are still in use?

View solution

Q. What does ‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, result in?

View solution

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

View solution

Q. REGEXP does not take collation into account.

View solution

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

View solution

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

View solution

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

View solution

Q. How many files does each end of a client/server connection including SSL support use to set up secure communications?

View solution

Q. The TLS protocol is _____________

View solution

Q. The grant table scope columns that is case insensitive is _____________

View solution

Q. Which variable checks for the availability of SSL support?

View solution

Q. MySQL does not provide a date type that has an optional time part.

View solution

Q. What is the best datatype for a column that is expected to store values up to 2 million?

View solution

Q. The datatype that stores the longest length of strings is ______________

View solution

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

View solution