Q.1
To perform consistency checks on a MyISAM table the statement is _____________
  • a) CHECK TABLE
  • b) REPAIR TABLE
  • c) ANALYZE TABLE
  • d) OPTIMIZE TABLE
Q.2
The statement that performs key distribution analysis and stores the distribution for the named tables is _____________
  • a) CHECK TABLE
  • b) ANALYZE TABLE
  • c) CHECKSUM TABLE
  • d) OPTIMIZE TABLE
Q.3
The column not returned by ‘OPTIMIZE TABLE’ is _____________
  • a) Table
  • b) Msg_txt
  • c) Op
  • d) Msg_type
Q.4
For which table does ‘REPAIR TABLE’ not work?
  • a) MyISAM
  • b) ARCHIVE
  • c) CSV
  • d) InnoDB
Q.5
What is the Perl DBI?
  • a) database inheritance
  • b) database integrity
  • c) database interface
  • d) database isolation
Q.6
What is the default path to Perl in Unix?
  • a) /usr/bin/perl
  • b) /usr/bin
  • c) /usr/perl
  • d) /usr/perl/bin
Q.7
How is the output from PHP generated?
  • a) statically generated
  • b) dynamically generated
  • c) not generated
  • d) no output
0 h : 0 m : 1 s