What authority is required to create a table?

COBOL SQL Interview Questions

(Continued from previous question...)

What authority is required to create a table?

In order to create tables, one needs CREATETAB privileges.

(Continued on next question...)

Other Interview Questions

• Describe the elements of the SELECT query syntax?
• What is the difference between IN subselects and EXISTS subselect?
• What is the retriction on using UNION in embedded SQL?
• How is the SUBSTR keyword used in SQL?
• What is minimum authority required for one to create a tablespace?
• Describe a primary key?
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?
• Is BETWEEN inclusive of the range values specified?
• What is minimum authority required for one to create a tablespace?
• Can one add columns to a table after it has been defined?
• More...