Can one add columns to a table after it has been

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is a join?
• In what RDMS object does one first list column names ?
• Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• How would you retrieve row from a DB2 table in embedded SQL?
• When do you use a LINK statement ?
• What is the difference between static and dynamic SQL?
• Why SELECT * is not preferred in embedded SQL programs ?
• What does the term "grant privileges" mean?
• What is the use of VALUE function?
• More...