logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • Explain foreign key constraint.


  • Correct Answer
  • A foreign key is a reference to another table It is used to establish relationships between tables For example, relationship between employee and professor table One employee can have multiple professors The Primary key of employee becomes foreign key of professor Example: create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) ); 


  • More questions

    • 1. How will u send data from a cobol file to db2 table?
    • Discuss
    • 2. What is buying forward?
    • Discuss
    • 3. What is Benchmarking?
    • Discuss
    • 4. In a DB2-CICS program which acts as co-ordinator and which is the participant?
    • Discuss
    • 5. Market survey means...........

    • Options
    • A. Market Research
    • B. Market Planning
    • C. Marketing Strategies
    • D. Market Monitoring
    • Discuss
    • 6. The relationship between quantity supplied and price is

    • Options
    • A. Directly proportional
    • B. Inverselyproportional
    • C. Can't be determined
    • D. None of the above
    • Discuss
    • 7. How would you resolve an ASRA abend?
    • Discuss
    • 8. What does in transit to destination mean?

    • Options
    • A. on the way for delivery
    • B. delay in delivery
    • C. booking processed but not shipped
    • D. None of the above
    • Discuss
    • 9. In contrast to investment, consumption is

    • Options
    • A. relatively unstable
    • B. measurable
    • C. unmeasurable
    • D. relatively stable
    • Discuss
    • 10. The EIB field which gives the last CICS command executed is?
    • Discuss


    Comments

    There are no comments.

Enter a new Comment