Which of the following correctly describes the between predicate in the where clause?

• A. It is used to check whether a value is in between two specified values
• B. It is used to check whether a value is exactly in the center of the relation alphabetically
• C. It is used to check whether a value is in between any two other values in the database
• D. None of the mentioned