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.
First CREATE MANAGER table with EMP-NO as the primary key. Then ALTER it to define the foreign key.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are the main components of Transaction-based Systems? 08.12.08
* Resource Manager * Transaction Manager and * Application Program....Give me a recent example of when you needed the assistance of your manager. 01.11.08
The interviewer wants to know if you handle issues that arise on your own and whether you exhaust every alternative before informing your manager of a poten...What is the function of a ODBC manager? 19.05.08
The ODBC Manager manages all the data sources that exists in the system....What is the function of the Data Manager ? 07.03.08
The Data Manager is a DB2 component that manager the physical databases. It invokes other system components, as necessary, to perform detailed functions such as...What are the check tables and value tables? 26.03.07
Check Table: The ABAP Dictionary allows you to define relationships between tables using foreign keys . A dependent table is called a foreign key table, and the...What is a layout manager and what are different types of layout managers available in java AWT? 01.02.07
A layout manager is an object that is used to organize components in a container. The different layouts are available are FlowLayout, BorderLayout, CardLayout,...A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? 06.08.06
Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint....What testing roles are standard on most testing projects? 13.07.06
Depending on the organization, the following roles are more or less standard on most testing projects: Testers, Test Engineers, Test/QA Team Lead, Test/QA Manag...What is a layout manager? 16.03.06
A layout manager is an object that is used to organize components in a container....What is resource manager 11.03.06
Provides access to a set of shared resources. A resource manager participates in transactions that are externally controlled and coordinated by a transaction ma...