What statistical tests are used in a correlation study?

What statistical tests are used in a correlational study? Why are the tests appropriate?