Give two examples of referential integrity constraints.

Question Posted / guest

2 Answers
8631 Views
I also Faced
E-Mail Answers

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

any body know about orawaves do they really provide placements in their unique placement program

1 Answers TCS,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

What is the dataguard background process??

1 Answers iGate,

What is transparent data encryption? : sql server DBA

0 Answers

Oracle 11g new features?

2 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

what is the role of dip user in our database?

0 Answers

what r the types of backup?

5 Answers CSC,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

How can you rebuild an index?

6 Answers

For more DB Administration Interview Questions Click Here