WAEC Data Processing 2021 Question 35

Question 35

Database Management

The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it

  1. A.retrieves the listed fields from student table.
  2. B.highlights the listed fields from student table.
  3. C.hides the selected fields from student table.
  4. D.deletes the listed fields from student table.
Show the answer and explanation

Answer: A (retrieves the listed fields from student table.)

Explanation

SELECT retrieves (displays) the named fields from the table.