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

EXTRACT

GET

OPEN

2 / 17

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

SORT BY

GROUP TO

COLLECT BY

GROUP BY

3 / 17

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

CREATE

ADD NEW

INSERT INTO

ADD RECORD

4 / 17

What does the acronym SQL stand for?

Strong Query Language

Structured Query Language

Standard Query Language

Structured Question Language

5 / 17

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

DIST

VALUE

DISTINCT

UNIQUE

6 / 17

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

REMOVE

DROP

DELETE

TRUNCATE

7 / 17

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

SET INDEX

CREATE INDEX

BUILD INDEX

MAKE INDEX

8 / 17

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

COMBINE

UNION

CONCATENATE

JOIN

9 / 17

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

REMOVE TABLE

DROP TABLE

DELETE TABLE

TRUNCATE TABLE

10 / 17

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

MIN()

LOW()

SMALL()

LEAST()

11 / 17

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

FOREIGN KEY

NOT NULL

PRIMARY KEY

ADD

12 / 17

What is the result of the following SQL query?

SELECT 2 + 3 * 4;

20

14

12

10

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 search for a specified pattern in a column.

To perform arithmetic operations.

To join tables.

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 create a foreign key relationship.

To create an index.

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

16 / 17

What is the function of the SQL ROLLBACK statement?

To save all changes made during the current transaction.

To discard 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?

Creates a link between two tables based on a column.

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

None of the above.

Ensures all values in a column are unique.

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