SQL Mastery Quiz

Question 1

1/12

What does SQL stand for?

Structured Query Language

Answer

Standard Query Language

Answer

Simple Query Language

Answer

System Query Language

Question 2

2/12

Which keyword is used to retrieve data from a database in SQL?

GET

RETRIEVE

SELECT

FETCH

Answer

MAKE TABLE

Answer

GENERATE TABLE

Question 3

3/12

Which keyword is used to specify conditions in SQL queries?

WHERE

CONDITION

FILTER

LIMIT

Question 4

4/12

What command is used to insert new data into a SQL table?

UPDATE

INSERT

ADD

CREATE

Question 5

5/12

Which SQL function is used to count the number of rows in a table?

TOTAL

COUNT

SUM

AVERAGE

Question 6

6/12

What keyword is used to return unique rows in an SQL query?

DISTINCT

UNIQUE

SINGLE

REPEAT

Question 7

7/12

Which keyword is used to sort the result set in SQL?

ARRANGE

ORDER BY

SORT

GROUP BY

Question 8

8/12

What statement is used to update existing records in SQL?

UPDATE

MODIFY

CHANGE

ALTER

Question 9

9/12

Which SQL keyword is used to remove records from a table?

DELETE

REMOVE

ERASE

TRUNCATE

Question 10

10/12

What function is used to concatenate columns in SQL?

MERGE

CONCAT

JOIN

COMBINE

Question 11

11/12

What keyword is used to join multiple tables in SQL?

CONNECT

JOIN

MERGE

COMBINE

Question 12

12/12

Which statement is used to create a new table in SQL?

RECORD

CREATE TABLE