SQL MCQs - Class 12

SQL MCQs - Class 12

12th Grade

•

55 Qs

quiz-placeholder

Similar activities

Search Skills

Search Skills

8th - 12th Grade

•

57 Qs

UH App inventor Kelas XI

UH App inventor Kelas XI

12th Grade

•

50 Qs

Komputer Akuntansi XII AK1

Komputer Akuntansi XII AK1

KG - 12th Grade

•

50 Qs

Latihan Soal Multimedia

Latihan Soal Multimedia

12th Grade

•

50 Qs

Penilain Harian 2

Penilain Harian 2

9th Grade - University

•

50 Qs

ALGORITHM AND FLOWCHART

ALGORITHM AND FLOWCHART

12th Grade - University

•

51 Qs

IT Essentials Review 3

IT Essentials Review 3

12th Grade

•

50 Qs

array review

array review

9th - 12th Grade

•

60 Qs

SQL MCQs - Class 12

SQL MCQs - Class 12

Assessment

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Easy

Created by

Dread Angel

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

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

55 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of an INNER JOIN in SQL?

To update records in a table.

To create a new table from existing tables.

To delete records from a table.

To retrieve matching records from two or more tables.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MAX()

COUNT()

AVG()

SUM()

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What data type would you use for a column that stores dates?

INTEGER

DATE or DATETIME

BOOLEAN

STRING

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you select all columns from a table named 'employees'?

GET * FROM employees;

FETCH * FROM employees;

SELECT * FROM employees;

SELECT ALL FROM employees;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of the WHERE clause in an SQL statement?

To filter records based on specified conditions.

To create new records in the database.

To sort records in ascending order.

To join multiple tables together.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

FULL OUTER JOIN

LEFT JOIN

RIGHT JOIN

INNER JOIN

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL function is used to find the maximum value in a column?

COUNT()

MIN()

SUM()

MAX()

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?