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 can be used to limit the number of rows returned in a SQL query?

LIMIT

SUM

COUNT

2 / 20

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

Operating Systems

Web Systems

Data Base Management Systems (DBMS)

3 / 20

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

MODIFY

UPDATE

ALTER

SELECT

4 / 20

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

WHERE

ORDER BY

FIND

5 / 20

Which of the following is NOT a relational database?

MySQL

MongoDB

Oracle

6 / 20

What kind of database does SQL typically work with?

Hierarchical Databases

Relational Databases

Graph Databases

7 / 20

Which SQL clause is used to sort the result set?

SORT BY

ORDER BY

FILTER

8 / 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

9 / 20

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

ALTER

INSERT

UPDATE

10 / 20

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

DROP

DELETE

TRUNCATE

REMOVE

11 / 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

12 / 20

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

LIMIT

FILTER

DISTINCT

13 / 20

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

INSERT

UPDATE

DELETE

CREATE

14 / 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

15 / 20

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

HAVING

WHERE

ORDER BY

SELECT

16 / 20

Which of the following is a valid SQL keyword?

FETCH

FIND

GET

17 / 20

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

ADD

INSERT

APPEND

UPDATE

18 / 20

Which SQL keyword is used to create a new table?

INSERT

CREATE

SELECT

ALTER

19 / 20

What does SQL stand for?

Structured Query Language

Simple Query Language

Server Query Language

20 / 20

What is SQL primarily used for?

Designing websites

Managing and querying databases

Designing user interfaces

Your score is

The average score is 90%