Multiple choice

SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE STUDENT_ID = 119

What will be the output of the above query?
Assume STUDENT_ID to be a primary key column.

  1. There is a syntax error in the query.

  2. It may return one row if the STUDENT_ID 119 is present in the table else it will return zero rows.

  3. It always returns zero rows.

  4. It returns n number of rows, where n is the number of students whose STUDENT_ID is 119.

  5. It returns all the rows in the table irrespective of the data.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Yes, it is true.

Keep practicing — related questions