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?

SELECT

GET

EXTRACT

OPEN

2 / 17

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

COLLECT BY

GROUP TO

GROUP BY

SORT BY

3 / 17

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

INSERT INTO

ADD NEW

ADD RECORD

CREATE

4 / 17

What does the acronym SQL stand for?

Structured Question Language

Standard Query Language

Strong Query Language

Structured Query Language

5 / 17

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

DIST

DISTINCT

UNIQUE

VALUE

6 / 17

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

REMOVE

TRUNCATE

DROP

DELETE

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?

UNION

JOIN

COMBINE

CONCATENATE

9 / 17

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

TRUNCATE TABLE

DROP TABLE

DELETE TABLE

REMOVE TABLE

10 / 17

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

LOW()

LEAST()

MIN()

SMALL()

11 / 17

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

FOREIGN KEY

ADD

NOT NULL

PRIMARY KEY

12 / 17

What is the result of the following SQL query?

SELECT 2 + 3 * 4;

10

12

20

14

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 perform arithmetic operations.

To search for a specified pattern in a column.

To create indexes.

To join tables.

15 / 17

What is the purpose of the PRIMARY KEY constraint?

To create an index.

To create a foreign key relationship.

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

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

16 / 17

What is the function of the SQL ROLLBACK statement?

To discard all changes made during the current transaction.

To create a save point in the transaction.

To save all changes made during the current transaction.

To commit changes made to the database.

17 / 17

What does the SQL FOREIGN KEY constraint do?

Creates a link between two tables based on a column.

Ensures all values in a column are unique.

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

None of the above.

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