A function-based index can be created based on which of the following?
A) UPPER(lastname)
B) (retail-cost)
C) UPPER(firstname)
D) all of the above

Question

A function-based index can be created based on which of the following?​
A) ​UPPER(lastname)
B) ​(retail-cost)
C) ​UPPER(firstname)
D) ​all of the above

Quizplus · Accepted Answer

Function-based indexes can be created on expressions involving table columns, which can include SQL functions like UPPER() or arithmetic operations. Therefore, all the options provided are valid expressions for creating a function-based index.

A Function-Based Index Can Be Created Based on Which of the Following?​

A Function-Based Index Can Be Created Based on Which of the Following?