How is an action query is different from select query?

Select queries do not change the data. They will show lists of data and various statistics and other requirements. Action queries do things like update records or delete records, which is changing the data. That is the difference.