To make this article complete, it worth mentioning that provisioners can be executed during creation as well as destruction of a resource.

Also there is an additional provisioner called "file" other than local and remote. So in total there are 3 - "file", "local-exec" and "remote-exec".