SQL Quiz

SQL Quiz: Test Your Business Intelligence Skills!

Check your SQL knowledge with this quiz and brush up your skills.

Please provide your information

1 / 17

Which SQL statement is used to extract data from a database?

GET

OPEN

EXTRACT

SELECT

2 / 17

Which SQL clause is used to group rows that have the same values?

SORT BY

GROUP BY

GROUP TO

COLLECT BY

3 / 17

Which SQL statement is used to insert new data into a database?

ADD RECORD

CREATE

ADD NEW

INSERT INTO

4 / 17

What does the acronym SQL stand for?

Structured Question Language

Structured Query Language

Strong Query Language

Standard Query Language

5 / 17

Which of the following SQL keywords is used to retrieve a unique value?

DISTINCT

VALUE

DIST

UNIQUE

6 / 17

What command is used to remove all rows from a table without removing the table itself?

TRUNCATE

REMOVE

DROP

DELETE

7 / 17

Which of the following SQL statements is used to create an index?

BUILD INDEX

MAKE INDEX

CREATE INDEX

SET INDEX

8 / 17

Which SQL command is used to combine the results of two or more SELECT statements?

UNION

CONCATENATE

JOIN

COMBINE

9 / 17

Which SQL statement is used to remove a table from a database?

REMOVE TABLE

TRUNCATE TABLE

DROP TABLE

DELETE TABLE

10 / 17

Which SQL function is used to return the smallest value of a numeric column?

MIN()

LEAST()

LOW()

SMALL()

11 / 17

Which of the following is not a type of SQL constraint?

FOREIGN KEY

PRIMARY KEY

NOT NULL

ADD

12 / 17

What is the result of the following SQL query?

SELECT 2 + 3 * 4;

12

14

10

20

13 / 17

Which of the following will select all the records where the "City" column starts with the letter "A"?

SELECT * FROM Customers WHERE City LIKE 'A%';

SELECT * FROM Customers WHERE City LIKE '_A%';

SELECT * FROM Customers WHERE City LIKE '%A%';

SELECT * FROM Customers WHERE City LIKE '%A';

14 / 17

What is the purpose of the SQL LIKE operator?

To search for a specified pattern in a column.

To join tables.

To perform arithmetic operations.

To create indexes.

15 / 17

What is the purpose of the PRIMARY KEY constraint?

To ensure that all values in a column are unique and not null.

To ensure that all values in a column are not null.

To create an index.

To create a foreign key relationship.

16 / 17

What is the function of the SQL ROLLBACK statement?

To commit changes made to the database.

To discard all changes made during the current transaction.

To save all changes made during the current transaction.

To create a save point in the transaction.

17 / 17

What does the SQL FOREIGN KEY constraint do?

None of the above.

Restricts values in a column to a predefined list of values.

Ensures all values in a column are unique.

Creates a link between two tables based on a column.

Your score is

0%

Which SQL statement is used to extract data from a database?

Share this:

Leave a Reply Cancel reply

Discover more from Power BI Docs