Unit 4c

Question 1

Provides ability to define, alter, and remove object definitions from database

Answer 1

Data Definition

Question 2

Refers to modification of database data

Answer 2

Data Manipulation

Question 3

Command based way to ask a database a question

Answer 3

Database Query

Question 4

Each command or SQL statement begins with keyword such as INSERT or SELECT

Answer 4

SQL Query Syntax

Question 5

Primary purpose to retrieve information from database

Answer 5

SELECT Command

Question 6

Function works on all rows not filtered out by query

Answer 6

GROUP BY

Question 7

Clause specifies conditions for groups similar to way WHERE clause specifies conditions for rows

Answer 7

HAVING

Question 8

Clause allows sorting on names of columns

Answer 8

ORDER BY

Question 9

Counts rows in a column

Answer 9

COUNT ( )

Question 10

Returns largest value in column

Answer 10

MAX ( )

Question 11

Returns the smallest value within column

Answer 11

MIN ( )

Question 12

Accumulates all the values within column

Answer 12

SUM ( )

Question 13

Returns average of set of values

Answer 13

AVG ( )

Question 14

Provides capability of forming sub-groups of query

Answer 14

SELECT using GROUP BY

Question 15

Provides ability to pull data from two or more tables

Answer 15

SELECT using Table Joins