Which three are properties of the MyISAM storage engine?

Correct Answer for the Question – Which three are properties of the MyISAM storage engine? is given below Which three are properties of the MyISAM storage engine? Transaction support FULLTEXT indexing for text matching Table and page level locking support Foreign key support Geospatial indexing HASH index support Table level locking only Correct Answer The Correct … Read more

Which three commands that are valid on either Windows or Linux will achieve this?

Correct Answer for the Question – Which three commands that are valid on either Windows or Linux will achieve this? is given below You want to shutdown a running Mysql Server cleanly.Which three commands that are valid on either Windows or Linux will achieve this? Shell> pkill -u mysql mysqld_safe Shell> service mysql safe_exit Shell> /etc/init.d/mysql … Read more

Which three statements are true about clustered indexes as used in InnoDB?

Correct Answer for the Question – Which three statements are true about clustered indexes as used in InnoDB? is given below The InnoDB engine has a feature known as clustered indexes.Which three statements are true about clustered indexes as used in InnoDB?Reference: http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html A primary key must exist for creation of a clustered index. A primary … Read more