consider the following table definition create table table1 column1 int column2..., MySQL, Databases

Test
- Model Test
Index

Question:Consider the following table definition:CREATE TABLE table1 ( 
        column1 INT, 
        column2 INT, 
        column3 INT, 
        column4 INT
)
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?

A ALTER TABLE table1 ADD column2a INT AFTER column2 
B MODIFY TABLE table1 ADD column2a AFTER column2 
C INSERT INTO table1 column2a AS INT AFTER column2 
D ALTER TABLE table1 INSERT column2a INT AFTER column2 
E CHANGE TABLE table1 INSERT column2a BEFORE column3 
F Columns are always added after the last column

/71

+ AnswerA

+ Report

Descriptive on MySQL Ebook

Total Preview: 682

Question:Consider the following table definition:CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT ) Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?

A ALTER TABLE table1 ADD column2a INT AFTER column2

B MODIFY TABLE table1 ADD column2a AFTER column2

C INSERT INTO table1 column2a AS INT AFTER column2

D ALTER TABLE table1 INSERT column2a INT AFTER column2

E CHANGE TABLE table1 INSERT column2a BEFORE column3

F Columns are always added after the last column

A

Question:Consider the following table definition:
CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT )
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?