CAML Queries are generally used in
Consuming Sharepoint Web Services
Sharepoint Designer Workflows
Sharepoint Object Model
Writing Sql Queries using Sharepoint Web Services