Function that check's file type based on certain keywords
Regarding your naming:

I'd rename:


validationTypeOfSQL() to isSQL() 
createSourceCodeTokens to sourceCodeTokens
createSourceCodeTokens() to sourceCodeTokens()
x to token
tokenToSmallerToken() to smallerTokens()
smallerTOkenValue to smallerToken
result to containsComma (It's better, of course, to remove it completely according to Robert Snyder's answer.)
tokenSplit to splitTokens
ts to st or splitToken
t to k or keyword
uniqueKeyword to keyword


I'd change String smallerTokens[] to String[] .... as you write it 4 lines later anyway.

I' d use replaceAll(String regex, String replacement) with replaceAll("[(,)\t]", "") instead of the replace() chain.