SQL

Question 1

SQL Term

Answer 1

Description

Question 2

SELECT

Answer 2

Used to select specific columns from a table.

Question 3

FROM

Answer 3

Specifies the table to retrieve data from.

Question 4

WHERE

Answer 4

Filters records based on specified conditions.

Question 5

GROUP BY

Answer 5

Groups rows that share a property to apply aggregate functions.

Question 6

HAVING

Answer 6

Filters groups based on aggregate results (used with GROUP BY).

Question 7

LIMIT

Answer 7

Limits the number of rows returned by a query.

Question 8

ORDER BY

Answer 8

Sorts the result set by one or more columns.

Question 9

JOIN

Answer 9

Combines rows from two or more tables based on a related column.

Question 10

INNER JOIN

Answer 10

Returns records that have matching values in both tables.

Question 11

LEFT JOIN

Answer 11

Returns all records from the left table and matched records from the right table.

Question 12

RIGHT JOIN

Answer 12

Returns all records from the right table and matched records from the left table.

Question 13

FULL JOIN

Answer 13

Returns all records when there is a match in either left or right table.

Question 14

INSERT INTO

Answer 14

Inserts new rows into a table.

Question 15

UPDATE

Answer 15

Updates existing records in a table.

Question 16

DELETE

Answer 16

Deletes records from a table.

Question 17

DISTINCT

Answer 17

Selects distinct (unique) values in a column.

Question 18

BETWEEN

Answer 18

Filters values within a specific range.

Question 19

IN

Answer 19

Filters values that match any value in a list.

Question 20

LIKE

Answer 20

Filters values using pattern matching (e.g., wildcards).

Question 21

IS NULL

Answer 21

Checks for NULL (missing) values.

Question 22

IS NOT NULL

Answer 22

Checks for non-NULL values.

Question 23

UNION

Answer 23

Combines the result sets of two or more SELECT statements.

Question 24

EXISTS

Answer 24

Checks if a subquery returns any records.

Question 25

ALTER TABLE

Answer 25

Modifies an existing table (e.g., add or drop columns).

Question 26

DROP TABLE

Answer 26

Deletes a table from the database.

Question 27

CREATE TABLE

Answer 27

Creates a new table in the database.

Question 28

TRUNCATE

Answer 28

Empties all records from a table without deleting the table.

Question 29

COUNT()

Answer 29

Counts the number of rows in a table.

Question 30

SUM()

Answer 30

Returns the total sum of a numeric column.

Question 31

AVG()

Answer 31

Returns the average value of a numeric column.

Question 32

MIN()

Answer 32

Returns the minimum value in a column.

Question 33

MAX()

Answer 33

Returns the maximum value in a column.

Question 34

ROUND()

Answer 34

Rounds a numeric value to a specified number of decimal places.