Give two examples of referential integrity constraints.
- 2 Answers
- 7577 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 do you understand by fine-grained auditing?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What happens on checkpoint? : sql server DBA
how can you find out if a table can be redefined?
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
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is a user-defined lock?
Why does Oracle not permit the use of PCTUSED with indexes?
how can a session indicate its interest in receiving alerts?
internal architecture
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
How can you control the amount of free space in your index pages? : sql server DBA
