SQL Multiple choice

A group of fields related to one item in a table

Record

Refer to the Primary key field used in another column

Foreign Key

An association between Entities

Relationship

Duplication of data or storing the same data in more than one location

Redundancy

A structure that can store information about multiple types of entities, the attributes of those entities and the relationship among the entities

Database

Person, place, object, event or idea for which you want to store and process data

Entity

A characteristic or property of an entity called a column in a database system

Attribute

A relationship between entities and attributes

Entity

Uniquely identifies a given row in a table

Primary Key

Spreadsheets, word documents and other computer information sources are stored in files

Datafile

A clause that sorts data by column

ORDER BY

A comparison operator

>

Finds unique rows

DISTINCT

Finds a range of values in columns

BETWEEN

Returns a certain number of rows in a query

LIMIT

A clause used for search conditions/criteria

WHERE

Returns true if both conditions are true

AND

Returns true if at least one condition is true

OR

Used to find patterns which uses the % sign

LIKE

Finds a list of values in columns

IN

Clause that identifies column names

SELECT

Clause that identifies a table

FROM

A clause that does grouping

GROUP BY

A function that returns the number of rows

COUNT

A function that finds the total of a column in a table and/or grouping

SUM

A function that returns the average of a table and/or grouping

AVG

A function that finds the lowest value in a table and/or grouping

MIN

Returns rows that match and rows that don’t match when you have two or more tables

LEFT

Similar to the WHERE clause used in a GROUP BY

HAVING

A function that finds the highest value in a table and/or grouping

MAX

Returns rows that match only when you have two or more tables

INNER

Allows you to enter data into specific columns, enter a full row of data or copy all data from a table to another table

INSERT

Keyword that changes data in columns on specific rows

UPDATE

Keyword that allows you make to make changes to a table such as adding a new column

ALTER

Keyword that creates the Data Definition Language of your table

CREATE

Indicates a column that must have values when inserting

NOT NULL

Column definition where the column can only hold numbers

INTEGERS

Column definition where the column can hold ASCII characters

VARCHAR

Use to specify rules for your data on your table

CONSTRAINT

Ensures that all values in a column are different

UNIQUE

A combination of NOT NULL and UNIQUE, uniquely identifies each row in a table

PRIMARY KEY

Uniquely identifies a row/record by referencing another table

FOREIGN KEY