SQL Quiz: 25 MCQs on the Student Table

Which SQL statement retrieves all columns from the students table?

• • GET FROM students;
    

• • 
    SELECT FROM students;

• • 
    FETCH FROM students;
    

• • SHOW FROM students;

How can you retrieve only the names of all students?

• SELECT Name FROM students;

• SHOW Name FROM students;

• EXTRACT Name FROM students;

• DISPLAY Name FROM students;

Which clause is used to filter records based on a condition?

• ORDER BY

• WHERE

• GROUP BY

• HAVING

What will the following query return?

SELECT DISTINCT Department FROM students;

• Number of departments

• List of all unique departments

• All student names

• Count of students

Which query fetches students older than 21?

• SELECT FROM students WHERE Age > 21;

• SELECT FROM students WHERE Age >= 21;

• SELECT FROM students HAVING Age > 21;

• SELECT FROM students FILTER Age > 21;

How can you find students enrolled before 2023?

• SELECT FROM students WHERE EnrollmentDate < '2023-01-01';

• SELECT FROM students WHERE EnrollmentDate > '2023-01-01';

• SELECT FROM students WHERE EnrollmentDate BETWEEN '2023-01-01' AND '2024-01-01';

• SELECT FROM students ORDER BY EnrollmentDate;

Which SQL function counts the total number of students?

• SUM(*)

• COUNT(*)

• TOTAL(*)

• NUMBER(*)

Which query finds the youngest student?

• SELECT MIN(Age) FROM students;

• SELECT FROM students ORDER BY Age DESC LIMIT 1;

• SELECT FROM students WHERE Age < 19;

• SELECT Age FROM students GROUP BY MIN(Age);

How do you find students in the ‘Electronics’ department?

• SELECT FROM students WHERE Department = 'Electronics';

• SELECT FROM students WHERE Department LIKE 'Electronics';

• SELECT FROM students HAVING Department = 'Electronics';

• SELECT FROM students WHERE Department IN ('Electronics');

1. Which operator is used to filter students in multiple departments?
   

• 1. SELECT FROM students WHERE Department = 'Computer Science' AND 'Mechanical';

• 1. SELECT FROM students WHERE Department IN ('Computer Science', 'Mechanical');

• 1. SELECT FROM students WHERE Department OR 'Computer Science', 'Mechanical';

• 1. SELECT FROM students WHERE Department LIKE 'Computer Science', 'Mechanical';