Fill the blanks with suitable options? BETWEEN . . . . . . . . AND . . . . . . . .

Answer: Option B

In MySQL, the BETWEEN keyword is used to select values within a specific range.

The BETWEEN operator needs two values: a lower limit and an upper limit.

Therefore, the correct answer is Option B: Lower and upper limit.

For example, if you want to select all rows where the age is between 18 and 30, you would use:

SELECT * FROM users WHERE age BETWEEN 18 AND 30;