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

Which of the following is NOT a part of SQL’s Data Manipulation Language (DML)?

INSERT

UPDATE

DELETE

CREATE

2 / 20

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

ALTER

INSERT

UPDATE

3 / 20

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

MODIFY

UPDATE

ALTER

SELECT

4 / 20

Which command is used to retrieve data from a database?

INSERT

SELECT

UPDATE

5 / 20

Which SQL clause is used to sort the result set?

SORT BY

ORDER BY

FILTER

6 / 20

What does SQL stand for?

Structured Query Language

Simple Query Language

Server Query Language

7 / 20

In SQL, which of the following is used to filter the results returned by a query?

WHERE

ORDER BY

FIND

8 / 20

What is a table in a database?

A set of programming instructions

A single data point

A set of data elements organized in rows and columns

9 / 20

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

ADD

INSERT

APPEND

UPDATE

10 / 20

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

REMOVE

TRUNCATE

DELETE

11 / 20

Which of the following is a valid SQL keyword?

FETCH

FIND

GET

12 / 20

Which symbol is used to terminate an SQL statement?

; (semicolon)

: (colon)

. (period)

13 / 20

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

MAX()

COUNT()

SUM()

MIN()

14 / 20

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

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Correction Language (DCL)

15 / 20

SQL is a standard language used to communicate with what type of system?

Operating Systems

Web Systems

Data Base Management Systems (DBMS)

16 / 20

What does the WHERE clause do in SQL?

Limits the number of rows returned

Orders the output in ascending order

Specifies the condition for selecting records

17 / 20

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

HAVING

WHERE

ORDER BY

SELECT

18 / 20

What does the SQL DISTINCT keyword do?

Filters duplicate records from the results

Sorts the result set

Selects only numeric data

Deletes data

19 / 20

Which of the following is NOT a relational database?

MySQL

MongoDB

Oracle

20 / 20

Which SQL keyword is used to create a new table?

INSERT

CREATE

SELECT

ALTER

Your score is

The average score is 90%