Give two examples of referential integrity constraints.

Question Posted / guest

2 Answers
7573 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

How can you enable a trace for a session?

1 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers

What is the default port no on which sql server listens? : sql server DBA

0 Answers

What is dbcc? : sql server DBA

0 Answers

Describe what redo logs are.

1 Answers

internal architecture

0 Answers CSC,

what is ora 600?

1 Answers

Why does Oracle not permit the use of PCTUSED with indexes?