Commands 1

Question 1

extracts data from a database

Answer 1

SELECT

Question 2

updates data in a database

Answer 2

UPDATE

Question 3

Deletes data from the database

Answer 3

DELETE

Question 4

inserts new data into a database

Answer 4

INSERT INTO

Question 5

creates a new database

Answer 5

CREATE DATABASE

Question 6

modifes a database

Answer 6

ALTER DATABASE

Question 7

creates a new table

Answer 7

CREATE TABLE

Question 8

modifies a table

Answer 8

ALTER TABLE

Question 9

deletes a table

Answer 9

DROP TABLE

Question 10

creates an index (search key)

Answer 10

CREATE INDEX

Question 11

Deletes an Index

Answer 11

DROP INDEX

Question 12

used to sort the result-set in ascending or descending order.

Answer 12

ORDER BY

Question 13

clause that lets you specify the maximum number of rows the result set will have.

Answer 13

LIMIT

Question 14

specifies where to start from.

Answer 14

OFFSET

Question 15

Used to select values within a range

Answer 15

BETWEEN

Values must be separated by the and keyword

Question 16

used to specify a range of conditions, any of which can be matched

Answer 16

IN

Question 17

Special operator used with the WHERE clause to search for a specific pattern in a column.

Answer 17

LIKE

LIKE is a predicate

Question 18

used to specify a set of characters, any one of which must match a character in the specified position

Answer 18

The wildcard bracket [ ]

Question 19

keyword in SQL that allows you to rename a column or table using an alias.

Answer 19

AS

Question 20

aggregate function that returns the average value for a numeric column.

Answer 20

AVG()

Question 21

function that takes the name of a column as an argument and counts the number of rows where the column is notNULL.

Answer 21

COUNT()

Question 22

clause that indicates you want to filter the result set to include only rows where the followingconditionis true.

Answer 22

WHERE

Question 23

function that takes the name of a column as an argument and returns the smallest value in that column.

Answer 23

MIN()

Question 24

function that takes the name of a column as an argument and returns the largest value in that column.

Answer 24

MAX()

Question 25

One or more values in adatabase tablethat identifyrecordsin another table.

Answer 25

Foreign key

Question 26

One or morefieldsin adatabase tablewhose values are guaranteed to be unique for eachrecord, i.e., whose values uniquely identify the entry.

Answer 26

Primary key

Question 27

What clause gives you the month name?

Answer 27

MONTHNAME()

Question 28

Used to combine results that appear from multiple SELECT statements and filter duplicates.

Answer 28

Union

Question 29

Clause that stores the result of a query in a temporary table using an alias

Answer 29

With