Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers

What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));

Creates a non-write-locking index
Modifies an index in place to be lowercase
Creates a new index with a special operator class 'lower' for case insensitive comparisons.
Creates an index for efficient case-insensitive searches on the titles column within the books table
Nothing, it's invalid SQL
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon