We need transactions and tables that can easily be ported to another system. We should use
ISAM
MyISAM
InnoDB
BDB
We need to create a temporary table for fast lookups. We should use
MERGE
HEAP
We need to have extremely large tables. We should not use
any of the above
We need to perform a full-text search. We should use
Consider the following full-text search query:
select title from article where match (title,body) against ('+php +pdf pdflib >tutorial ~reference' IN BOOLEAN MODE);
Which of the following statements about this query is false ?
The importance of the search term 'tutorial' is increased.
The ranking of results containing 'reference' will be increased.
Search results must contain 'php' .
Search results that contain 'pdflib' will be ranked more highly than those that do not.
