How do I create a table MANAGER ( EMP#, MANAGER)

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.

First CREATE MANAGER table with EMP# as the primary key. Then ALTER it to define the foreign key.

(Continued on next question...)

Other Job Interview Questions

• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• When do you use a LIKE statement?–
• What is a collection?
• What is the COBOL picture clause of the following DB2 data types:
• What are the various locks available?
• What is a precompiler?
• Can I use LOCK TABLE on a view?
• Where is the output of EXPLAIN stored? –
• Where is the output of EXPLAIN stored? –
• What is auditing?
• More...