WAEC Data Processing 2020 Question 23

Question 23

Database Management

The DBMS statement, select* from Marksheet in table Marksheet will display all records in the fields:

Diagram for this question
  1. A.ID and Name only.
  2. B.ID, Score and Grade only.
  3. C.Score and Grade only.
  4. D.ID, Name, Score and Grade.
Show the answer and explanation

Answer: D (ID, Name, Score and Grade.)

Explanation

The asterisk (*) in SELECT * means all fields, so ID, Name, Score and Grade are shown.