Consider the table given below:

Table : STUDENT

ADMNO NAME CLASS SCORE
A001 Amit 12A 90
A002 Amit 12B 91
A003 Bhavana 12A 90
A004 Yamini 12A 89
A005 Ashok 12B 95

Using the STUDENT table, you want to select all records where the CLASS is either '12A' or '12B'. Which of the following SQL commands correctly achieves this?

A. SELECT * FROM STUDENT WHERE CLASS = '12A' OR CLASS = '12B';

B. SELECT * FROM STUDENT WHERE CLASS IN ('12A', '12C');

C. SELECT * FROM STUDENT WHERE CLASS IN ('12A', '12B');

D. SELECT * FROM STUDENT WHERE CLASS = '12A' AND '12B';

1
Only A and D
2
Only B and C
3
Only A and C
4
All of the above

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation