Interested to Buy Any Domain ? << Click Here >> for more details...
When can an insert of a new primary key value threaten
referential integrity?
- 2 Answers
- 7637 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen
When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.
RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pawan
when the value violates the rule of primary key....new
insert value must be unique.
| Is This Answer Correct ? | 1 Yes | 3 No |
Why do chiropractors use drop table?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is pagespace?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is lock escalation?
When Can you be sure that a query will return only one row?
What are the abend codes occour in ur latest PROJECT in DB2
What is the max length of sqlca?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is the reason behind not using select * in embedded sql programs?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
COBOL 
