DBA > Job Interview Questions > COBOL SQL Interview Questions

What RDMS objects are crested with the SQL CREAT

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