What does the following statement do?

YasminRadwan26

Save to bookmark

2022-06-04

206

CREATE INDEX lower_title_idx ON books ((lower(title)));

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
Creates a non-write-locking index

Postgre SQL, MCQ Questions, Postgre SQL MCQ-questions,

YasminRadwan26

2022-06-04

need an explanation for this answer? contact us directly to get an explanation for this answer

Correct Answer:

C.Creates an index for efficient case-insensitive searches on the titles column within the books table

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)