Indexed view

procedures

triggers

views

Data types

Primary keys

Default values

All of the above.

DDL

DML

HTML

XML

LIKE only.

IN only.

NOT IN only.

Both IN and NOT IN.

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

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');

Normalization

Data Integrity

Materialized Views

All of the above

Tables contain one or more rows

Rows contain one or more database of information

Databases contain one or more tables

Tables

Columns

Rows

Databases