SQL Quiz

Question 1

Which command deletes records?

Accepted Answer

DELETE

Question 2

Which SQL statement is used to create a table?

Accepted Answer

CREATE TABLE

Question 3

What is a foreign key?

Accepted Answer

Links tables

Question 4

True or false: SQL stands for Structured Query Language.

Accepted Answer

True

Question 5

True or false: SQL can handle large datasets efficiently.

Accepted Answer

True

Question 6

What is a primary key?

Accepted Answer

Unique identifier

Question 7

True or false: SQL is only used for relational databases.

Accepted Answer

False

Question 8

True or false: SQL can be used for data analysis.

Accepted Answer

True

Question 9

True or false: SQL can be used for web development.

Accepted Answer

True

Question 10

True or false: SQL can only read data, not write it.

Accepted Answer

False

Question 11

What does 'HAVING' do in SQL?

Accepted Answer

Filters groups

Question 12

What does 'JOIN' do in SQL?

Accepted Answer

Combines tables

Question 13

Which command creates an index?

Accepted Answer

CREATE INDEX

Question 14

True or false: SQL is a programming language.

Accepted Answer

False

Question 15

Which command retrieves data from a database?

Accepted Answer

SELECT

Question 16

Which SQL function counts records?

Accepted Answer

COUNT()

Question 17

What does 'GROUP BY' do?

Accepted Answer

Aggregates data

Question 18

What does 'DISTINCT' do in SQL?

Accepted Answer

Removes duplicates

Question 19

What does the 'WHERE' clause do?

Accepted Answer

Filters records

Question 20

Which command updates existing records?

Accepted Answer

UPDATE

Question 21

True or false: SQL is case-sensitive.

Accepted Answer

False

Question 22

True or false: SQL can only be used with MySQL.

Accepted Answer

False

Question 23

Which SQL statement is used to modify a table?

Accepted Answer

ALTER TABLE

SQL Quiz

Questions 23

SQL Quiz

Questions 23