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 SQL keyword is used to create a new table?

INSERT

CREATE

SELECT

ALTER

2 / 20

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

DROP

DELETE

TRUNCATE

REMOVE

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

4 / 20

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

ADD

INSERT

APPEND

UPDATE

5 / 20

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

MAX()

COUNT()

SUM()

MIN()

6 / 20

What does SQL stand for?

Structured Query Language

Simple Query Language

Server Query Language

7 / 20

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

INSERT

UPDATE

DELETE

CREATE

8 / 20

Which command is used to retrieve data from a database?

INSERT

SELECT

UPDATE

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

10 / 20

What does the SQL DISTINCT keyword do?

Filters duplicate records from the results

Sorts the result set

Selects only numeric data

Deletes data

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 clause is used to sort the result set?

SORT BY

ORDER BY

FILTER

13 / 20

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

Operating Systems

Web Systems

Data Base Management Systems (DBMS)

14 / 20

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

ALTER

INSERT

UPDATE

15 / 20

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

LIMIT

FILTER

DISTINCT

16 / 20

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

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Correction Language (DCL)

17 / 20

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

CREATE DB

NEW DATABASE

CREATE DATABASE

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

19 / 20

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

MODIFY

UPDATE

ALTER

SELECT

20 / 20

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

WHERE

ORDER BY

FIND

Your score is

The average score is 90%