SQL Query and Constraint Quiz

Which query inserts a new student into the semestermarks table with all columns?

• INSERT INTO semestermarks VALUES ('Ali', 101, 89, 3);

• INSERT semestermarks (Ali, 101, 89, 3);

• INSERT INTO semestermarks (Ali, 101, 89);

• PUT INTO semestermarks VALUES ('Ali', 101, 89, 3);

Which of these updates the semester of rollnumber 202540 to 4?

• UPDATE semestermarks SET 4 TO semester WHERE rollnumber = 202540;

• UPDATE semestermarks SET semester = 4 WHERE rollnumber = 202540;

• MODIFY semester = 4 FROM semestermarks WHERE rollnumber = 202540;

• CHANGE semestermarks SET semester TO 4 WHERE rollnumber = 202540;

Which constraint prevents null entries in a column?

• DEFAULT

• UNIQUE

• NOT NULL

• PRIMARY

Which query will fetch records where marks are above 70?

• SELECT * FROM semestermarks WHERE marks > 70;

• SELECT * FROM semestermarks HAVING marks > 70;

• SELECT marks FROM semestermarks IF marks > 70;

• GET * FROM semestermarks WHERE marks > 70;

Which function returns total marks in the semestermarks table?

• COUNT(marks)

• AVG(marks)

• SUM(marks)

• MAX(marks)

Which query groups the employees by department and returns average salary?

• GROUP BY employee SELECT dept, AVG(salary);

• SELECT AVG(salary), dept FROM employee;

• SELECT dept, AVG(salary) FROM employee GROUP BY dept;

• SELECT dept FROM employee GROUP salary BY;

Which keyword allows you to check if a column value exists in a list?

• IN

• EXISTS

• WHERE

• ANY

Which clause restricts data based on a condition?

• GROUP BY

• FROM

• WHERE

• SELECT

Which query checks if age is between 20 and 30?

• WHERE age = 20 AND 30

• WHERE age BETWEEN 20 TO 30

• WHERE age BETWEEN 20 AND 30

• WHERE age IN (20 - 30)

What does this query do? SELECT dept, COUNT(*) FROM employee GROUP BY dept;

• Lists all departments

• Counts employees in each department

• Shows employee names by department

• Returns total salary by department