Tables

Columns

Rows

Databases

Tables contain one or more rows

Rows contain one or more database of information

Databases contain one or more tables

Normalization

Data Integrity

Materialized Views

All of the above

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V'

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

LIKE only.

IN only.

NOT IN only.

Both IN and NOT IN.

DDL

DML

HTML

XML

Data types

Primary keys

Default values

All of the above.

Indexed view

procedures

triggers

views