SQL Quiz

SQL Quiz

Professional Development

34 Qs

quiz-placeholder

Similar activities

A+ 1102 Study Quiz 5

A+ 1102 Study Quiz 5

Professional Development

29 Qs

A+ Core 1 - 1101 - Quiz 1

A+ Core 1 - 1101 - Quiz 1

Professional Development

32 Qs

Power Query & Power Bi Essential

Power Query & Power Bi Essential

Professional Development

30 Qs

Module 3 Quiz Simulation

Module 3 Quiz Simulation

Professional Development

35 Qs

Introduction_to_AI

Introduction_to_AI

Professional Development

30 Qs

Информатика 6-нұсқа

Информатика 6-нұсқа

Professional Development

35 Qs

Seleksi Pelatihan Computer Operator Assistant

Seleksi Pelatihan Computer Operator Assistant

Professional Development

30 Qs

IT Support

IT Support

Professional Development

33 Qs

SQL Quiz

SQL Quiz

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

An Bình

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?