Introduction to SQL – Quiz

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

2 / 20

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

3 / 20

In SQL, what does DML stand for?

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

4 / 20

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

5 / 20

Which symbol is used to terminate an SQL statement?

6 / 20

Which SQL keyword is used to create a new table?

7 / 20

What is a table in a database?

8 / 20

Which command is used to retrieve data from a database?

9 / 20

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

10 / 20

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

11 / 20

What does the SQL DISTINCT keyword do?

12 / 20

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

13 / 20

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

14 / 20

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

15 / 20

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

16 / 20

What does the SELECT statement do in SQL?

17 / 20

What is SQL primarily used for?

18 / 20

What does the WHERE clause do in SQL?

19 / 20

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

20 / 20

What is a primary key in a SQL table?

Your score is

The average score is 90%

0%

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.