How do I create a table 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 ...

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

AN:
First CREATE MANAGER table with EMP-NO as the primary key. Then ALTER it to define the foreign key.

(Continued on next question...)

Other Job Interview Questions

• What is the size of a data page ?
• What is the significance of DB2 free space and what parameters control it?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• Once you create a view, where would information about the view be stored?
• How many buffer pools are there in DB2?
• What is meant by isolation level?
• What is an alias and how does it differ from a synonym?
• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• Explain the use of the WHERE clause?
• More...