Getting Started with SQL and Relational Databases/

...

/

Quiz on Indexing

Quiz on Indexing

Test your knowledge about indexes and add new columns.

We'll cover the following...
Technical Quiz
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);
1 / 4
...