SQL Quiz
Authored by An Bình
Computers
Professional Development
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
34 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
What is SQL Query Optimization
The way to write SQL query shorter
The way to write SQL query prettier
The way to write SQL run faster
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is execution plan
The step when database check syntax and validation your query
The blueprint your administrator uses to create a database
The tool to monitor query run time
The detailed step-by-step analysis of how to execute a SQL query
The tool which database engine uses to cache most used queries
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Table "product" have these columns below. Which one should be indexed ?
bar_code
title
price
date
brand_name
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which query below should efficient than others ?
SELECT * FROM product WHERE bar_code LIKE '%91%'
SELECT * FROM product WHERE bar_code LIKE '91%'
SELECT title, date, price FROM product WHERE bar_code LIKE '91%'
SELECT title, date, price FROM product WHERE bar_code LIKE '%91'
SELECT title, date, price FROM product WHERE bar_code LIKE '%91%'
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which query below should efficient than other ?
SELECT e.employee_id, e.first_name, e.last_name
FROM employees e
WHERE NOT EXISTS (
SELECT 1
FROM managers m
WHERE m.manager_id = e.employee_id
);
SELECT e.employee_id, e.first_name, e.last_name
FROM employees e
WHERE e.employee_id NOT IN (
SELECT m.manager_id
FROM managers m
);
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which query below should efficient than other ?
SELECT product_id, sales_amount, 2023 AS year
FROM sales_2023
UNION ALL
SELECT product_id, sales_amount, 2024 AS year
FROM sales_2024
SELECT product_id, sales_amount, 2023 AS year
FROM sales_2023
UNION
SELECT product_id, sales_amount, 2024 AS year
FROM sales_2024
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Partitioning is..
The process of dividing a table into smaller, more manageable pieces
The act of creating a new database
The method of storing data on multiple hard drives.
A way to improve query performance by indexing data.
The method of migration database to cloud
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?
