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

Q. Arrays can have associative indices in PHP.

View solution

Q. Which operator is used to access property of an object in PHP?

View solution

Q. How is the binary log rotated?

View solution

Q. How is a delimited-text data file reloaded?

View solution

Q. Which program performs logical backups?

View solution

Q. The option that suppresses output unless there are errors in the table is _____________

View solution

Q. What is the return value from operations returning a row count?

View solution