Multiple choice

Write a query to display students details whose STUDENT_ID is 119 OR COURSE_ID is 301.

  1. SELECT * FROM STUDENTS WHERE STUDENT_ID = 119 OR COURSE_ID = 301

  2. SELECT ALL FROM STUDENTS WHERE STUDENT_ID = 119 OR COURSE_ID = 301

  3. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE STUDENT_ID = 119 OR COURSE_ID = 301

  4. SELECT ALL STUDENT_ID FROM STUDENTS WHERE STUDENT_ID = 119 OR COURSE_ID = 301

  5. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Yes, this is the correct syntax.

Keep practicing — related questions