|
What RDMS objects are crested with the SQL CREATE statements?
COBOL SQL Interview Questions
What RDMS objects are crested with the SQL CREATE statements?
The SQL CREATE statements are used tp create the following objects:
STOGROUP A storage group
DATABASE A logical collection of tables
TABLESSPACE An area that stores tables
TABLE A data structure organized by a specified colunms
INDEX An alternate path to a table data
VIEW An alternate representation of one or more tables
SYNONYM An alternate name for local table or view
ALIAS An alternate name for a table definition which may be local or remote, existence or nonexistent
(Continued on next question...)
Other Interview Questions
| 