
SQL Query and Constraint Quiz
Quiz
•
Engineering
•
University
•
Practice Problem
•
Easy
mohammed ahmed
Used 3+ times
FREE Resource
Enhance your content in a minute
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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);
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which constraint prevents null entries in a column?
DEFAULT
UNIQUE
NOT NULL
PRIMARY
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns total marks in the semestermarks table?
COUNT(marks)
AVG(marks)
SUM(marks)
MAX(marks)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyword allows you to check if a column value exists in a list?
IN
EXISTS
WHERE
ANY
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
T7_T11
Quiz
•
University
20 questions
SENA BD CIA
Quiz
•
3rd Grade - University
20 questions
National Youth Day Celebration Focusing on SDG 4 & 8
Quiz
•
University
20 questions
Preguntas sobre SQL y C#
Quiz
•
University
25 questions
Unmanned Aircraft System Quiz
Quiz
•
9th Grade - University
30 questions
22ME503_BPLM_Activity
Quiz
•
University
20 questions
Software Reuse Quiz
Quiz
•
University
20 questions
Database Management System Quiz
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Engineering
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University
