How To Check Active Validation Rules Based On Selected Object Using SOQL

If You want to Check Active Validation Rules on selected Object.
Use Below Simple SOQL Query, This Query Fetch the Active Validation Rule on a Your Select-Object.
SOQL Query:

Select id,Active,Description,EntityDefinition.DeveloperName,ErrorDisplayField,ErrorMessage From ValidationRule where EntityDefinition.DeveloperName='<Object Name>' and active = true

Note: Use Tooling API while Querying.
If You are Using Developer Console

Check the Screen Shot For More Information

Let Us Know If  You Have Any Queries.

Happy Learning!!