Question

Consider the table 'STUDENT': 

Name	Class	DOB	Gender	City	Marks
Rohan	XI	2008	M	Delhi	85
Priya	XII	2006	F	Mumbai	92
Ankit	XI	2007	M	Delhi	88
Nidhi	XII	2006	F	Mumbai	90
Aarav	IX	2009	M	Kolkata	78
Simran	XI	2007	F	Chandigarh	94
Rahul	XII	2006	M	Pune	80

From the above table 'STUDENT', which query will return all the students from class 'XI'? 
 

• A. SELECT * FROM STUDENT WHERE Class ='XI';
• B. SELECT * FROM STUDENT WHERE LIKE 'XI';
• C. SELECT Name, DOB FROM STUDENT WHERE Class $>$ 'XI';
• D. SELECT * FROM STUDENT WHERE Class IN ='XI';

Hint:

In SQL:
1. Use SELECT * to project all attributes.
2. Use WHERE column = 'value' for strict string equality matching.
3. IN expects a parenthesized list like WHERE column IN ('A', 'B').

Answer 1

The Correct Option is A

Concept:
SQL data retrieval uses the SELECT statement combined with the WHERE clause to filter tuples that satisfy a given conditional predicate.
The asterisk symbol (*) denotes that all columns of the matching tuples must be projected in the result set.

Step 1: Analysis of the Requirement:
The task is to retrieve all information (all columns) for students studying in class 'XI'.
To specify equality with a string literal in standard SQL, the equality comparison operator (=) is employed along with single quotes surrounding the string.
Hence, the correct syntax is:
SELECT * FROM STUDENT WHERE Class = 'XI';

Step 2: Error Analysis in Other Options:
Option (B) omits the attribute name before the operator and uses LIKE incorrectly without a column specification.
Option (C) only projects Name and DOB, failing to return all student details, and uses the inequality operator ($>$) instead of checking for equality.
Option (D) incorrectly combines the set operator IN with the equality operator =, which creates a syntax error in SQL.
Final Answer:
The correct and syntactically valid query is option (A).