Quiz on Indexing

Test your knowledge about indexes and add new columns.

1

Assuming that we have the students table, what is the command to add a new column named address of the varchar(255) type and that can’t be null?

A)
alter students add column (address varchar(255));
B)
alter table students add column (address varchar(255) not null);
C)
alter table students insert column (address varchar(255) not null);
D)
alter table students add one column (address varchar(255) not null);
Question 1 of 40 attempted

Get hands-on with 1200+ tech skills courses.