Can one add columns to a table after it has been defined?

COBOL SQL Interview Questions

(Continued from previous question...)

Can one add columns to a table after it has been defined?

Yes. one can add column to a table after it has been defined by using the SQL ALTER TABLE statement.

(Continued on next question...)

Other Interview Questions

• What is minimum authority required for one to create a tablespace?
• What is the retriction on using UNION in embedded SQL?
• In what RDMS object does one first list column names ?
• What is UNION, UNION ALL?
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?
• What is a foreign key?
• What keyword does an SQL SELECT statement use for a string search?
• What RDMS objects are required before you can create a table ?
• Can one add columns to a table after it has been defined?
• Describe referential integrity?
• More...