Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8727 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
What is transparent data encryption? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what are the benefits of flashback feature?
Why does Oracle not permit the use of PCTUSED with indexes?
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 do you understand by flashback feature of oracle?
What are the recovery models for a database? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is asm?
how can you communicate with operating system files from oracle?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Query processing is slow(eg select query)how will u solve that
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the role of dip user in our database?
