Tchs final

What is a group of fields related to one item in a table?

Record

What refers to the Primary key field used in another column?

Foreign Key

What is an association between entities?

Relationship

What is duplication of data or storing data in more than one location?

Redundancy

What is a structure to store multiple types of entities and their relationships?

Database

What is a person

place

What is a characteristic of an entity

also known as a column?

What describes a relationship between entities and attributes?

Entity-Relationship

What uniquely identifies a given row in a table?

Primary Key

Where are spreadsheets and docs stored?

Datafile

Which clause sorts data by column?

ORDER BY

What is a comparison operator?

>

Which operator finds unique rows?

DISTINCT

Which operator finds a range of values in columns?

BETWEEN

Which clause returns a certain number of rows?

LIMIT

Which clause is used for search criteria?

WHERE

Which operator returns true if both conditions are true?

AND

Which operator returns true if at least one condition is true?

OR

Which keyword finds patterns with the % symbol?

LIKE

Which operator finds a list of values?

IN

Which clause identifies column names?

SELECT

Which clause identifies the table?

FROM

Which clause does grouping?

GROUP BY

Which function returns number of rows?

COUNT

Which function finds the total of a column?

SUM

Which function returns the average?

AVG

Which function finds the lowest value?

MIN

Which join returns matching and non-matching rows from the left table?

LEFT

Which clause is like WHERE but for GROUP BY?

HAVING

Which function finds the highest value?

MAX

Which join returns rows that match only?

INNER

Which keyword inserts data?

INSERT

Which keyword changes data?

UPDATE

Which keyword adds or modifies a table?

ALTER

Which keyword creates the table structure?

CREATE

Which constraint requires a value to be entered?

NOT NULL

What column type holds numbers?

INTEGERS

What column type holds ASCII characters?

VARCHAR

What defines rules for a table?

CONSTRAINT

What ensures column values are unique?

UNIQUE

Which constraint is a combo of NOT NULL and UNIQUE?

PRIMARY KEY

Which key references another table’s row?

FOREIGN KEY