Mastering SQL: A Comprehensive Quiz

Mastering SQL: A Comprehensive Quiz

12th Grade

10 Qs

quiz-placeholder

Similar activities

Cloud Storage

Cloud Storage

8th Grade - University

10 Qs

DKJKT

DKJKT

12th Grade

10 Qs

ASK FORM 3 MICROSOFT ACCESS

ASK FORM 3 MICROSOFT ACCESS

KG - University

10 Qs

Remidi TLJ

Remidi TLJ

12th Grade

12 Qs

ERDs and DFDs

ERDs and DFDs

9th - 12th Grade

15 Qs

BTEC National ICT U2 - Microsoft Access

BTEC National ICT U2 - Microsoft Access

12th Grade

10 Qs

Share Hosting Server

Share Hosting Server

12th Grade

15 Qs

Aplikasi dan Tipe Data/File

Aplikasi dan Tipe Data/File

11th Grade - University

15 Qs

Mastering SQL: A Comprehensive Quiz

Mastering SQL: A Comprehensive Quiz

Assessment

Quiz

Computers

12th Grade

Practice Problem

Easy

Created by

Craig Harrison

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the `SELECT` statement in SQL?

To delete data from a database

To retrieve data from a database

To update data in a database

To create a new table in a database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct order of database normalisation forms?

1NF, 2NF, 3NF, BCNF

2NF, 1NF, 3NF, BCNF

3NF, 2NF, 1NF, BCNF

BCNF, 3NF, 2NF, 1NF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL clause is used to filter records?

ORDER BY

GROUP BY

WHERE

HAVING

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of join returns all records from the left table and the matched records from the right table?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL function is used to count the number of rows in a table?

SUM()

AVG()

COUNT()

MAX()

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SQL command `INSERT INTO` do?

It updates existing data in a table

It deletes data from a table

It adds new data into a table

It creates a new table

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a characteristic of a table in 1NF (First Normal Form)?

It has no repeating groups

It has no partial dependencies

It has no transitive dependencies

It has a single candidate key

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?