What is the purpose of the SQL RAND() function when used with a seed value?

A. Generates a random number without any seed value

B. Generates a random number based on a specified seed value

C. Generates a random string

D. Retrieves a random record from a table

Correct Answer is :

B. Generates a random number based on a specified seed value