> > >

LAMP MCQs

Indexes are known to speed up the search but they have some limitations also. Which of the following queries take much time despite having indexes on table?

select * from articles (body) match against ('database')

select * from pages where page_text like "%buffy%"

select last_name from phone_book where last_name rlike "(son|ith)$"

select * from articles where body = "%database%"

All of the above

Answer

Correct Answer: select * from pages where page_text like "%buffy%"

Explanation:

Note: This Question is unanswered, help us to find answer for this one

LAMP Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it