Are the field names and the object name used in the object's SOQL query case sensitive?
The fields names used in an object's SOQL select statements are case insensitive. So the query: "SELECT id, NAme FROM Account" should be correct as well.
The object names used in a SOQL are case sensitive. So the query: "SELECT id, Name FROM ACCOUNT" should not be handled correctly.
Despite this, there are several exceptions when case of SOQL fields is important: