Q. The option that supplies the pathname to root directory of MySQL installation is _____________

View solution

Q. The log enabled by –relay-log-index is _____________

View solution

Q. What is the storage size in bytes required for the MEDIUMINT datatype?

View solution

Q. What is the size of the BIT type?

View solution

Q. What is the synonym for REAL?

View solution

Q. Execution on a time activated basis according to a schedule is done by _____________

View solution

Q. Stored programs degrade database security.

View solution

Q. The character that the MySQL client program recognizes as a statement delimiter is ______________

View solution

Q. Which upgrade involves exporting existing data using mysqldump?

View solution

Q. Which upgrade involves shutting down the old MySQL version and replacing the old binaries?

View solution

Q. Slow shutdown can be performed by setting innodb_fast_shutdown to _____________

View solution

Q. A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

View solution

Q. The command to see the warning messages is ______________

View solution

Q. What is the SQL mode to check for divide by zero error?

View solution

Q. The mode used to turn on strict mode and all of the additional restrictions is _____________

View solution

Q. The number of values returned from a stored procedure can be _______________

View solution

Q. How would a stored function named PI() written in the database ‘sampdb’ be called?

View solution

Q. The privilege that must be given to the database to create a stored function or procedure is ____________

View solution