Introduction to SQL

This quiz will test your basic understanding of SQL (Structured Query Language). The questions cover fundamental concepts such as SQL syntax, the purpose of SQL, databases, and how SQL operates. The goal is to ensure a solid foundation before diving into more advanced topics.

1 / 20

What does the SQL DISTINCT keyword do?

Filters duplicate records from the results

Sorts the result set

Selects only numeric data

Deletes data

2 / 20

Which SQL statement is used to change data in a table?

MODIFY

UPDATE

ALTER

SELECT

3 / 20

Which SQL statement is used to delete data from a table?

REMOVE

TRUNCATE

DELETE

4 / 20

Which of the following is used to add a new record into a table?

ADD

INSERT

APPEND

UPDATE

5 / 20

Which of the following is NOT a type of SQL statement?

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Correction Language (DCL)

6 / 20

Which of the following is a valid SQL command to create a new database?

CREATE DB

NEW DATABASE

CREATE DATABASE

7 / 20

What kind of database does SQL typically work with?

Hierarchical Databases

Relational Databases

Graph Databases

8 / 20

Which of the following is NOT a relational database?

MySQL

MongoDB

Oracle

9 / 20

Which SQL keyword is used to remove duplicate records in a result set?

LIMIT

FILTER

DISTINCT

10 / 20

Which SQL keyword is used to create a new table?

INSERT

CREATE

SELECT

ALTER

11 / 20

Which of the following is a valid SQL keyword?

FETCH

FIND

GET

12 / 20

What is a primary key in a SQL table?

A unique identifier for each record

A way to relate tables

A query that retrieves data

13 / 20

In SQL, what does DML stand for?

a) Data Markup Language
b) Data Modification Language
c) Data Manipulation Language
d) Data Management Language

Data Markup Language

Data Modification Language

Data Manipulation Language

Data Management Language

14 / 20

Which SQL command is used to remove all rows from a table without deleting the table itself?

DROP

DELETE

TRUNCATE

REMOVE

15 / 20

What does SQL stand for?

Structured Query Language

Simple Query Language

Server Query Language

16 / 20

Which SQL command is used to modify existing data in a table?

ALTER

INSERT

UPDATE

17 / 20

Which command is used to retrieve data from a database?

INSERT

SELECT

UPDATE

18 / 20

Which symbol is used to terminate an SQL statement?

; (semicolon)

: (colon)

. (period)

19 / 20

Which SQL clause is used to specify conditions in a query?

HAVING

WHERE

ORDER BY

SELECT

20 / 20

Which SQL function is used to return the smallest value in a set of records?

MAX()

COUNT()

SUM()

MIN()

Your score is

The average score is 90%