Clauses, Queries, And Syntax

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

True or False: SQL is a programming language.

Answer 2

False

Question 3

What is the purpose of the SELECT statement in SQL?

Answer 3

To retrieve data from a database.

Question 4

Fill in the blank: The SQL clause that specifies the table to query is called ____.

Answer 4

FROM

Question 5

Which SQL clause is used to filter records?

Answer 5

WHERE

Question 6

What keyword is used to sort the result set in SQL?

Answer 6

ORDER BY

Question 7

True or False: The GROUP BY clause is used to arrange identical data into groups.

Answer 7

True

Question 8

What does the HAVING clause do in SQL?

Answer 8

It filters records after grouping.

Question 9

What is the default sorting order of the ORDER BY clause?

Answer 9

Ascending

Question 10

Which SQL function is used to count the number of rows?

Answer 10

COUNT()

Question 11

What keyword is used to add new records to a table?

Answer 11

INSERT INTO

Question 12

Fill in the blank: To modify existing records in a table, you use the ____ statement.

Answer 12

UPDATE

Question 13

What does the DELETE statement do in SQL?

Answer 13

Removes records from a table.

Question 14

True or False: The SQL statement ‘SELECT * FROM table_name’ retrieves all columns from a table.

Answer 14

True

Question 15

What is the purpose of the DISTINCT keyword in SQL?

Answer 15

To return only unique values.

Question 16

Fill in the blank: In SQL, a ____ is a set of data stored in a table.

Answer 16

record

Question 17

What is the primary key in a database?

Answer 17

A unique identifier for a record in a table.

Question 18

What SQL clause is used to combine records from two or more tables?

Answer 18

JOIN

Question 19

Which type of JOIN returns all records from both tables, with matches where available?

Answer 19

FULL OUTER JOIN

Question 20

What is the purpose of the LIMIT clause in SQL?

Answer 20

To specify the maximum number of records to return.

Question 21

True or False: SQL supports both single-line and multi-line comments.

Answer 21

True

Question 22

What is the syntax to create a new table in MySQL?

Answer 22

CREATE TABLE table_name (column1 datatype, column2 datatype, …);

Question 23

Fill in the blank: The SQL function ____ is used to find the highest value in a column.

Answer 23

MAX()

Question 24

What does the SQL command ‘ALTER TABLE’ do?

Answer 24

Modifies an existing table structure.

Question 25

Which SQL clause is used to specify a condition for an aggregate function?

Answer 25

HAVING

Question 26

What is the syntax to drop a table in MySQL?

Answer 26

DROP TABLE table_name;

Question 27

True or False: The LIKE operator is used for pattern matching in SQL.

Answer 27

True

Question 28

What does the SQL function SUM() do?

Answer 28

Calculates the total sum of a numeric column.

Question 29

Fill in the blank: The ____ operator is used to filter records based on multiple conditions.

Answer 29

AND

Question 30

What is the purpose of the UNION operator in SQL?

Answer 30

To combine the results of two or more SELECT statements.

Question 31

Which SQL clause is used to specify the columns to be returned?

Answer 31

SELECT

Question 32

What does the COUNT(DISTINCT column_name) function do?

Answer 32

Counts the number of unique values in a column.

Question 33

True or False: An SQL view is a virtual table based on the result of a SELECT query.

Answer 33

True

Question 34

What is the purpose of the CASE statement in SQL?

Answer 34

To create conditional logic within queries.

Question 35

Fill in the blank: The SQL command to rename a column is ____.

Answer 35

ALTER TABLE ... CHANGE

Question 36

What does the INNER JOIN do?

Answer 36

Returns records that have matching values in both tables.

Question 37

Which clause is used to remove duplicates from the result set?

Answer 37

DISTINCT

Question 38

What is a foreign key?

Answer 38

A field in one table that uniquely identifies a row of another table.

Question 39

True or False: The SQL command 'SELECT NULL' retrieves records with null values.

Answer 39

False

Question 40

What is the purpose of the AUTO_INCREMENT attribute in MySQL?

Answer 40

To automatically generate a unique value for a new record.

Question 41

Fill in the blank: The SQL function ____ is used to find the smallest value in a column.

Answer 41

MIN()

Question 42

Which SQL function can be used to concatenate strings?

Answer 42

CONCAT()

Question 43

What is the purpose of the TRUNCATE TABLE command?

Answer 43

To delete all records in a table without removing the table itself.

Question 44

True or False: SQL can only be used with relational databases.

Answer 44

False

Question 45

What does the SQL command 'EXPLAIN' do?

Answer 45

Provides information about how MySQL executes a statement.

Question 46

Fill in the blank: The SQL statement to create an index is ____.

Answer 46

CREATE INDEX

Question 47

What is the purpose of the COALESCE function in SQL?

Answer 47

To return the first non-null value in a list.