Can someone provide me the list of SOQL exceptions? a URL link which has all the exceptions and explanations. Thanks in advance
The Enterprise WSDL generated in any organization lists the exceptions that the platform might throw at you. You can find it under Setup > Integrations > API. The file is pretty big, so one might want to save it and open in a text editor.
Search for the tag
simpleType with the "name" parameter
As for the SOQL exceptions, you won't find any with "SOQL" in the name, but you get some when searching using "QUERY":