Which of the following statements is true about select queries? Choose all that are correct