Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Give two examples of referential integrity constraints.

Question Posted / guest

Answers were Sorted based on User's Feedback



Give two examples of referential integrity constraints...

Answer / monal

RELATIONSHIP BETWEEN CUSTOMERS AND ORDERS &
RELATIONSHIP BETWEEN ORDERS AND ORDERDETAILS

Is This Answer Correct ?    7 Yes 0 No

Give two examples of referential integrity constraints...

Answer / kalyan maddipati

Emp and Dept tables is the good example fro referential integrity as DeptNo in Dept table refers DeptNO of Emp table.

ie. You have a PK(Primary key) on Deptno of Dept table and FK(Foreign key) on Deptno of EMP Table

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB Administration Interview Questions

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

Can we take incremental backups in datapump?

1 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

what is the use of ocr?

0 Answers   Oracle,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

What is the difference between Datapump & export/import?

2 Answers  

how can you schedule a job in database?

0 Answers   Oracle,

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

why we use cursors

1 Answers  

Can you redefine a table online?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories