Which RDMS objects can you change with the SQL ALTER statements?

COBOL SQL Interview Questions

(Continued from previous question...)

Which RDMS objects can you change with the SQL ALTER statements?

The SQL ALTER statements can change a table index, a table, tablespace, or a STOGROUP.

(Continued on next question...)

Other Interview Questions

• What RDMS objects are required before you can create a table ?
• What is an index key?
• What are some SQL aggregates and other built-in functions?
• What is the use of VALUE function?
• How do you find the maximum value in a column?
• How would you find out the total number of row in a table?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is a cursor? Why should it be used ?
• 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 the difference between static and dynamic SQL?
• More...