SQL Schema and Query Quiz

Specifies a new base relation by defining its name, attributes, and data types (correct)

Deletes an entire table and its definition from the database

Modifies the existing table structure by adding new columns

Alters the table by changing the data types of its columns

To specify a unique constraint on a column

To ensure that a column does not contain any NULL values

To define a foreign key constraint between two tables

To specify the attribute(s) that uniquely identify each tuple in the table (correct)

Drops all the constraints associated with a table

Alters the table structure by removing columns

Deletes all the data from a table

Removes a relation and its definition from the database (correct)

<p>To enforce uniqueness on a column or a combination of columns</p> Signup and view all the answers

<p>Specifies a referential integrity constraint between two tables</p> Signup and view all the answers