Absolute Free 1Z0-006 Exam Practice for Comprehensive Preparation 

To define the relationships between tables

To define the data types for each column

To optimize database performance

To ensure data integrity

To establish primary and foreign key relationships

To enforce data integrity

To improve data retrieval performance

To eliminate all redundancy in the database

ORDER BY

GROUP BY

WHERE

A primary key from another table

A key used to establish relationships between tables

A key that can have duplicate values

A constraint that ensures data integrity