Interested to Buy Any Domain ? << Click Here >> for more details...
Why foreign key column allowing null values even a parent
tables reference key column not having null value..
- 2 Answers
- 6298 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sureshramsing@gmail.com
Yes foreign key column allows null values, if it is not having either primary key or not null constraints.
Foreign key just reference to the particular parent column only not for restrcting the data while insert or update. It verifies dependency at the time of delete only.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What happens if null values are involved in arithmetic operations?
What is the difference between a unique key and primary key?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is a cursor, index in sql?
What are different types of views?
How to create “dependant” parameter “make, model, year”
What happens if you are trying to access a schema not owned by you?
write an SQL query to list the employees who joined in the month of January?
How to use clusters?
Where views are stored in sql server?
What is store procedure? How do they work?
Explain the cursor lock types?
What is trigger and different types of Triggers?
What are the three different part of rdl file explain them?
wat wil hapn if we give the both read and deny read permission to user?
