Q. What performs a key distribution analysis and stores the distribution for the named table or tables?

View solution

Q. Which of the following columns is not returned by ‘OPTIMIZE TABLE’?

View solution

Q. REPAIR TABLE does not work for _____________

View solution

Q. The binary protocol is easy to use.

View solution

Q. What is a synonym for CHARACTER SET?

View solution

Q. The line which is written at the top of the script to write a Perl script using CGI.pm is ______________

View solution

Q. To perform consistency checks on a MyISAM table the statement is _____________

View solution

Q. The statement that performs key distribution analysis and stores the distribution for the named tables is _____________

View solution

Q. The column not returned by ‘OPTIMIZE TABLE’ is _____________

View solution

Q. For which table does ‘REPAIR TABLE’ not work?

View solution

Q. What is the Perl DBI?

View solution

Q. What is the default path to Perl in Unix?

View solution

Q. How is the output from PHP generated?

View solution

Q. What attempts auto recovery based on the contents of its serial log?

View solution

Q. How many of these can replace ‘level’ in ‘–myisam-recover = level’?

BACKUP, FORCE, QUICK

View solution

Q. Under which option are index changes not flushed until tables close?

View solution

Q. Which option suppresses output unless there are errors in the table?

View solution

Q. What is the variable that is a handle to a database object?

View solution

Q. The variable that returns code from operations that return true or false is _____________

View solution

Q. In PHP, how is the first element accessed if $a represents an array with numeric indices?

View solution