Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData Definition Language

Consistency constraints

Cars

Report a typo

Select all the correct statements about a table that was created with the following SQL query:

CREATE TABLE cars (
 car_num INT NOT NULL UNIQUE,
 owner_surname VARCHAR(20) NOT NULL,
 country VARCHAR(30) DEFAULT 'Finland'
)

Select one or more options from the list

You can insert two cars with car_num 56786

The car_num must be unique for each row

The country column has a default value

The car_num can be NULL

___

Create a free account to access the full topic