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?

EXTRACT

OPEN

SELECT

GET

2 / 17

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

SORT BY

GROUP TO

GROUP BY

COLLECT BY

3 / 17

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

ADD RECORD

ADD NEW

CREATE

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?

VALUE

DISTINCT

UNIQUE

DIST

6 / 17

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

DROP

REMOVE

DELETE

TRUNCATE

7 / 17

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

BUILD INDEX

CREATE INDEX

MAKE INDEX

SET INDEX

8 / 17

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

COMBINE

CONCATENATE

JOIN

UNION

9 / 17

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

REMOVE TABLE

DROP TABLE

TRUNCATE TABLE

DELETE TABLE

10 / 17

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

SMALL()

LOW()

LEAST()

MIN()

11 / 17

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

NOT NULL

ADD

FOREIGN KEY

PRIMARY KEY

12 / 17

What is the result of the following SQL query?

SELECT 2 + 3 * 4;

10

14

20

12

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 create indexes.

To perform arithmetic operations.

To search for a specified pattern in a column.

To join tables.

15 / 17

What is the purpose of the PRIMARY KEY constraint?

To create an index.

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

To create a foreign key relationship.

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

16 / 17

What is the function of the SQL ROLLBACK statement?

To discard all changes made during the current transaction.

To save all changes made during the current transaction.

To commit changes made to the database.

To create a save point in the transaction.

17 / 17

What does the SQL FOREIGN KEY constraint do?

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

Ensures all values in a column are unique.

None of the above.

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 ReplyCancel reply

Discover more from Power BI Docs