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 WHERE clause do in SQL?

Limits the number of rows returned

Orders the output in ascending order

Specifies the condition for selecting records

2 / 20

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

INSERT

UPDATE

DELETE

CREATE

3 / 20

What is SQL primarily used for?

Designing websites

Managing and querying databases

Designing user interfaces

4 / 20

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

Operating Systems

Web Systems

Data Base Management Systems (DBMS)

5 / 20

What does the SQL DISTINCT keyword do?

Filters duplicate records from the results

Sorts the result set

Selects only numeric data

Deletes data

6 / 20

Which of the following is a valid SQL keyword?

FETCH

FIND

GET

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

8 / 20

What does the SELECT statement do in SQL?

Selects a database

Modifies records in a table

Retrieves data from a database

Deletes data from a table

9 / 20

Which symbol is used to terminate an SQL statement?

; (semicolon)

: (colon)

. (period)

10 / 20

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

CREATE DB

NEW DATABASE

CREATE DATABASE

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

12 / 20

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

MODIFY

UPDATE

ALTER

SELECT

13 / 20

Which SQL keyword is used to create a new table?

INSERT

CREATE

SELECT

ALTER

14 / 20

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

MAX()

COUNT()

SUM()

MIN()

15 / 20

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

REMOVE

TRUNCATE

DELETE

16 / 20

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

LIMIT

FILTER

DISTINCT

17 / 20

Which of the following can be used to limit the number of rows returned in a SQL query?

LIMIT

SUM

COUNT

18 / 20

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

WHERE

ORDER BY

FIND

19 / 20

What kind of database does SQL typically work with?

Hierarchical Databases

Relational Databases

Graph Databases

20 / 20

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

HAVING

WHERE

ORDER BY

SELECT

Your score is

The average score is 90%