Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8465 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what functionality does oracle provide to secure sensitive information?
what is the role of dip user in our database?
How do you open a cluster administrator? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What authentication modes does sql server support? : sql server DBA
how can you implement fine-grained auditing?
how does an oracle clusterware manage crs resources?
What purpose does the model database server? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the differences of where and if in SAS?
How would you extract DDL of a table without using a GUI tool?
