8. How do you find the students who have not enrolled in any courses?

Select students with no corresponding entries in the enrollment table.

Count the total number of students enrolled in courses.

List all courses and their enrolled students.

Select students who have enrolled in at least one course.

9. What SQL command would you use to update the address of a specific student?

UPDATE students SET address = 'new address' WHERE student_id = 'specific_id';

INSERT INTO students SET address = 'new address' WHERE student_id = 'specific_id';

DELETE FROM students WHERE student_id = 'specific_id';

SELECT address FROM students WHERE student_id = 'specific_id';

10. Which query lists all courses along with the number of students enrolled in each?

SELECT courses.course_name, COUNT(enrollments.student_id) AS number_of_students FROM courses LEFT JOIN enrollments ON courses.id = enrollments.course_id GROUP BY courses.id;

SELECT course_name, SUM(enrollments.student_id) FROM courses GROUP BY course_name;

SELECT courses.course_name FROM courses WHERE enrollments.student_id IS NOT NULL;

SELECT courses.course_name, enrollments.student_id FROM courses JOIN enrollments ON courses.id = enrollments.course_id;

11. Which SQL statement would you use to find all students who have a grade above a certain threshold?

SELECT first_name, last_name FROM students JOIN grades ON students.id = grades.student_id WHERE grade > 'threshold';

SELECT * FROM students WHERE grade > 'threshold';

SELECT first_name, last_name, grade FROM students WHERE grade > 'threshold';

SELECT student_id FROM grades WHERE grade > 'threshold';

12. How can you retrieve the names of all courses that have not been taken by any students?

SELECT course_name FROM courses WHERE course_id NOT IN (SELECT course_id FROM enrollments);

SELECT course_name FROM courses WHERE course_id NOT EXISTS (SELECT course_id FROM enrollments);

SELECT course_name FROM courses WHERE course_id IS NULL;

SELECT course_name FROM courses WHERE course_id = 0;

13. What SQL command would you use to delete a specific course from the database?

DELETE FROM courses WHERE course_id = 'specific_id';

SELECT * FROM courses WHERE course_id = 'specific_id';

REMOVE FROM courses WHERE course_id = 'specific_id';

DROP course FROM courses WHERE course_id = 'specific_id';

14. How can you find the total number of courses offered in the database?

SELECT SUM(course_id) FROM courses;

SELECT total_courses FROM courses;

SELECT COUNT(course_id) FROM courses;

15. Which SQL statement retrieves the names of students who have enrolled in a specific course?

SELECT students.name FROM students JOIN enrollments ON students.id = enrollments.student_id WHERE enrollments.course_id = 'specific_course_id';

SELECT student_name FROM students WHERE course_id = 'specific_course_id';

SELECT * FROM students WHERE course_name = 'specific_course_name';

SELECT name FROM students WHERE enrolled_course = 'specific_course_id';

16. What SQL command would you use to count the number of instructors teaching more than one course?

SELECT COUNT(instructor_id) FROM courses GROUP BY instructor_id HAVING COUNT(course_id) > 1;

SELECT COUNT(instructor_id) FROM instructors WHERE courses_taught > 1;

SELECT instructor_id FROM instructors WHERE course_count > 1;

SELECT COUNT(*) FROM instructors WHERE course_count > 1;

17. How can you retrieve the names of instructors who have not taught any courses?

SELECT name FROM instructors WHERE instructor_id NOT IN (SELECT instructor_id FROM courses);

SELECT * FROM instructors WHERE instructor_id NOT EXISTS (SELECT instructor_id FROM courses);

SELECT name FROM instructors WHERE instructor_id IS NULL;

SELECT name FROM instructors WHERE courses_taught = 0;

18. Which SQL command would you use to find the total number of students in the database?

SELECT COUNT(student_id) FROM students WHERE student_id IS NOT NULL;

SELECT SUM(student_id) FROM students;

SELECT total_students FROM students;

19. What SQL statement would you use to update the grade of a specific student?

UPDATE grades SET grade = 'new_grade' WHERE student_id = 'specific_id';

INSERT INTO grades (student_id, grade) VALUES ('specific_id', 'new_grade');

SELECT grade FROM grades WHERE student_id = 'specific_id';

DELETE FROM grades WHERE student_id = 'specific_id';

20. How can you find the names of students who have not received any grades?

SELECT name FROM students WHERE student_id NOT IN (SELECT student_id FROM grades);

SELECT name FROM students WHERE student_id NOT EXISTS (SELECT student_id FROM grades);

SELECT name FROM students WHERE grades_received = 0;

SELECT * FROM students WHERE grade IS NULL;

21. Which SQL statement retrieves the average duration of all courses?

SELECT AVG(duration) FROM courses;

SELECT COUNT(duration) FROM courses;

SELECT SUM(duration) FROM courses;

SELECT MAX(duration) FROM courses;

22. How can you list all students along with their corresponding grades?

SELECT students.name, grades.grade FROM students JOIN grades ON students.id = grades.student_id;

SELECT students.name, grades.grade FROM students LEFT JOIN grades ON students.id = grades.student_id;

SELECT * FROM students, grades WHERE students.id = grades.student_id;

SELECT students.name, grades.grade FROM grades JOIN students ON grades.student_id = students.id;

Database Query Practice

Authored by Nabin Chaudhary

Other

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

22 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Which SQL statement retrieves first name, last name, and address of students sorted by address?

SELECT * FROM students ORDER BY first_name;

SELECT first_name, last_name FROM students;

SELECT address FROM students WHERE last_name = 'Smith';

SELECT first_name, last_name, address FROM students ORDER BY address;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2. How do you list instructors' first name, last name, and designation sorted by last name in descending order?

SELECT last_name, first_name, designation FROM instructors ORDER BY first_name ASC.

SELECT first_name, last_name, designation FROM instructors ORDER BY last_name DESC.

SELECT first_name, last_name, designation FROM instructors ORDER BY designation DESC.

SELECT first_name, last_name FROM instructors ORDER BY last_name;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

3. What SQL command would you use to find the most expensive course?

SELECT * FROM courses ORDER BY price DESC LIMIT 1;

SELECT * FROM courses ORDER BY price ASC LIMIT 1;

SELECT course_name FROM courses WHERE price = MAX(price);

SELECT * FROM courses WHERE price > 1000;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

4. Which query would return the total number of students enrolled in each course?

SELECT course_id, COUNT(student_id) AS total_students FROM enrollments GROUP BY course_id;

SELECT course_id FROM enrollments GROUP BY student_id;

SELECT COUNT(*) FROM enrollments;

SELECT student_id, course_id FROM enrollments;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

5. How can you select all courses that have a duration greater than 30 days?

SELECT * FROM courses WHERE duration < 30;

SELECT * FROM courses WHERE duration = 30;

SELECT * FROM courses WHERE duration >= 30;

SELECT * FROM courses WHERE duration > 30;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

6. What SQL statement lists all instructors who teach a specific course?

SELECT * FROM instructors WHERE course_name = 'specific_course_name';

SELECT instructors.name FROM instructors LEFT JOIN courses ON instructors.id = courses.instructor_id;

SELECT instructors.name FROM instructors JOIN courses ON instructors.id = courses.instructor_id WHERE courses.course_name = 'specific_course_name';

SELECT instructors.name FROM courses WHERE instructor_id = instructors.id;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7. Which query retrieves the average grade of students in a particular course?

SELECT COUNT(grade) FROM grades WHERE course_id = 'specific_course_id';

SELECT SUM(grade) FROM grades WHERE course_id = 'specific_course_id';

SELECT AVG(grade) FROM grades WHERE course_id = 'specific_course_id';

SELECT MAX(grade) FROM grades WHERE course_id = 'specific_course_id';

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

FINAL REVIEW

Quiz

•

University

20 questions

Front Desk

Quiz

•

KG - Professional Dev...

17 questions

POPULATION and SAMPLING

Quiz

•

University

20 questions

Environmental Day Quiz

Quiz

•

11th Grade - University

20 questions

Pasar Modal Syariah bersama MOST Syariah

Quiz

•

University

22 questions

FED311 400 Level

Quiz

•

University

20 questions

Technology for Teaching and Learning

Quiz

•

University

20 questions

UDL3612 1910 ONLINE QUIZ 1

Quiz

•

University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade