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

SELECT

OPEN

EXTRACT

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

INSERT INTO

CREATE

4 / 17

What does the acronym SQL stand for?

Strong Query Language

Structured Question Language

Standard Query Language

Structured Query Language

5 / 17

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

VALUE

UNIQUE

DISTINCT

DIST

6 / 17

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

DROP

DELETE

TRUNCATE

REMOVE

7 / 17

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

BUILD INDEX

SET INDEX

MAKE INDEX

CREATE 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?

REMOVE TABLE

DROP TABLE

TRUNCATE TABLE

DELETE TABLE

10 / 17

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

LEAST()

LOW()

MIN()

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;

14

12

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

To join tables.

To search for a specified pattern in a column.

To perform arithmetic operations.

15 / 17

What is the purpose of the PRIMARY KEY constraint?

To create a foreign key relationship.

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

To create an index.

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 commit changes made to the database.

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.

17 / 17

What does the SQL FOREIGN KEY constraint do?

Ensures all values in a column are unique.

None of the above.

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

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