Q. How can the value of recently generated sequence number be obtained?

View solution

Q. What does LAST_INSERT_ID() return when no AUTO_INCREMENT value has been generated during the current connection?

View solution

Q. Triggers are not supported for _____________

View solution

Q. Triggers and events are not invoked automatically by the server.

View solution

Q. How is a stored procedure invoked?

View solution

Q. Which table lists the accounts and the databases for which the privileges are provided?

View solution

Q. The table that lists the column level privileges is _____________

View solution

Q. Which of these grant table scope columns is case insensitive?

View solution

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