DDL(DATA DEFINITION LANGUAGE)

Which of the following command is used to create a table or database

• Alter

• Delete

• Modify

• Create

Which of the folling command is used to add new column name in table created

• Alter with drop

• Alter with add

• Alter with rename

• Alter with modify

Which of the following command is used to change the data type or size of column name in table

• Alter with modify

• Alter with rename

• Alter with change

• Alter with drop

• Alter with add

Which of the following command is used to remove a column name in table created

• Alter with delete

• Alter with rename

• Alter with remove

• Alter with drop

Which of the following command is used remove a whole table in database

• Drop

• Update

• Delete

• Remove

Which of the following command is used to rename the column name table

• Alter with add

• Alter with modify

• Alter with change

• Alter with drop

Syntax of creating table is:

• create[table_name](column_name)

• create[table_name](column_name datatype size)

• create table [table_name](datatype size column_name)

• create table [table name](column_name datatype size)

Syntax of adding new column name is:

• Alter [table name] add [datatype size column_name]

• Alter table [table name] add [new_column_name datatype size]

• Alter table [table name] add [size datatype new_column_name]

• Alter table [table name] add [datatype new_column_name]

Syntax of changing datatype or size of column_name is:

• Alter [table_name] modify [new_datatype new_size]

• Alter table [table_name] modify [column_name new_datatype new_size]

• Alter table [table_name] modify [new_datatype new_size columname]

• Alter[table name] modify [column_name new_datatype new_size]

Syntax of changing the name of column name in table

• Alter [table_name] change [old_column_name][new_column_name]

• Alter table [table_name] change [new_column_name] [old_column_name]

• Alter [table_name] change [new_column_name][old_column_name]

• Alter table [table_name] change [old_column_name][new_column_name]