CIS407 Quiz 2

Data Definition Language

Limited to DB admins

Data Manipulation Language

used by programmers/developers to maintain and query the database

Data Control Language

limited to DB admins - used to keep the database secure

CREATE TABLE

creates a new table by specifying the table name, column names, and column data types.

DROP TABLE

The DROP TABLE statement deletes a table, along with all the table's rows, from a database.

ALTER TABLE

The ALTER TABLE statement adds, deletes, or modifies columns on an existing table.

ADD

adds a column

CHANGE

modifies a column

DROP

Deletes a column

Data type

a named set of values from which column values are drawn

Spatial data

stores geometric info, such as lines, polygons, and map coordinates

Document

data types that contain textual data in a structured format such as XML or JSON

UPDATE statement

modifies existing rows in a table

SET

the UPDATE system uses this clause to specify the new column.

Primary keys

a column, or group of columns, used to identify a row. To ensure that each value identifies exactly one row, a primary key must be unique and not NULL.