Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8522 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 asm?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Why does Oracle not permit the use of PCTUSED with indexes?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how to restore files with rman?
Why would you call update statistics? : sql server DBA
how can you record information about current session?
What is replication? : sql server DBA
What is the default fill factor value? : 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
how can you find out if a table can be redefined?
how can you communicate with operating system files from oracle?
how can a session indicate its interest in receiving alerts?
