Question

When a column is added to a table, it is the _____ column in the table. (Points : 2) first

last
second
third

Answer 1

The correct answer for the given question is "last ".

Explanation:

When we add a column into the table so the column will add in the last of the table .We can use alter command in SQL to added the column in the table.

The syntax for adding new column into the table is given below .

ALTER TABLE table_name

ADD column_name datatype;

For example

Suppose we have to add the address column into the student table.

ALTER TABLE student

ADD address varchar (50);

This query will add the column in last of the table .

Answer 2

last

Step-by-step explanation:

When a column is added to a table, it gets appended at the end of the table. For example, suppose we have a table called Student with a column 'Name'. Now suppose we want to add another column called class to the table, then the new column will be added at the end of the table. So the new table structure will consist of <Name,Class>.The same procedure will apply for any other added column.