Studied by 0 people
Looks like no one added any tags here yet for you.
What is a composite primary key in database design?
A composite primary key consists of multiple columns that together uniquely identify a row, ensuring it is not null and minimal.
How are composite keys represented in SQL?
Composite keys are enclosed in parentheses.
What does the CREATE TABLE statement ensure regarding a primary key?
It ensures that a column or group of columns is always unique and non-null.
What is the purpose of the AUTO INCREMENT keyword in SQL?
It defines a column that automatically receives an incrementing value when a new row is inserted.
Where does the AUTO INCREMENT keyword appear in a CREATE TABLE statement?
It follows the column's data type.
