
Special DB Exam
Quiz
•
Computers
•
University
•
Practice Problem
•
Medium
ELLAINE CERVANTES
Used 1+ times
FREE Resource
Enhance your content in a minute
75 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is the correct MySQL command to create a database?
CREATE TABLE database_name;
CREATE DATABASE database_name;
NEW DATABASE database_name;
CREATE SCHEMA database_name;
2.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
Which of the following queries will return employees who have a salary greater than the average salary of all employees?
SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);
SELECT * FROM employees WHERE salary = AVG(salary);
SELECT * FROM employees WHERE salary > (SELECT MAX(salary) FROM employees);
SELECT * FROM employees WHERE salary > 5000;
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following SQL commands is used to prevent new records from being inserted into a table?
DISABLE INSERT INTO table_name;
ALTER TABLE table_name ADD DISABLE_INSERT;
LOCKS TABLES table_name WRITE;
ALTER TABLE table_name SET INSERT RESTRICT;
NO ANSWER
4.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
What is the result of the following query?
SELECT employee_id, salary FROM employees ORDER BY salary DESC LIMIT 3 OFFSET 2;
The query will return the 3rd, 4th, and 5th highest salaries.
The query will return the top 3 highest salaries.
The query will return the 2nd, 3rd, and 4th highest salaries.
The query will return the top 2 highest salaries starting from the 3rd highest.
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the following SQL statement do?
SELECT COUNT(*) FROM employees WHERE department_id IS NULL;
Counts the number of employees in the employees table.
Counts the number of employees with no department.
Counts the number of NULL values in the department_id column
Counts the total number of rows in the employees table.
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following queries will return the second highest salary from the employees table?
SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
SELECT MIN(salary) FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
SELECT salary FROM employees ORDER BY salary LIMIT 1 OFFSET 2;
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which statement will return the count of employees per department, including departments with zero employees?
SELECT department_id, COUNT(employee_id) FROM employees GROUP BY department_id;
SELECT d.department_id, COUNT(e.employee_id) FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_id;
SELECT department_id, COUNT(*) FROM employees WHERE department_id IS NOT NULL GROUP BY department_id;
SELECT department_id, COUNT(*) FROM employees GROUP BY department_id WITH NULLS;
Create a free account and access millions of resources
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
80 questions
preTEST Pranata Komputer Terampil Part 1
Quiz
•
10th Grade - Professi...
70 questions
C Programming
Quiz
•
University
70 questions
UJI NYALI BDTI
Quiz
•
University
74 questions
Firewalls and Network Security Study Guide Midterm
Quiz
•
University
78 questions
Active Directory Quiz
Quiz
•
University
75 questions
OCR L3 Cam Tech Unit 1 Fundamentals of IT
Quiz
•
University
70 questions
INTEVENSI PPC
Quiz
•
5th Grade - University
75 questions
Đề 33 E3 HT 23.24
Quiz
•
University
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
7 questions
Different Types of Energy
Interactive video
•
4th Grade - University
7 questions
Transition Words and Phrases
Interactive video
•
4th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
7 questions
Biomolecules (Updated)
Interactive video
•
11th Grade - University
34 questions
Unit 5 Review - The Middle Ages in Europe-B
Quiz
•
9th Grade - University
26 questions
Day2 classwork: Permutation and combination
Quiz
•
2nd Grade - University
5 questions
Using Context Clues
Interactive video
•
4th Grade - University
