Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Why foreign key column allowing null values even a parent
tables reference key column not having null value..

Question Posted / shakeer

Answers were Sorted based on User's Feedback



Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / rajkumar

Foreign key consider only the values. According to null value is not a value.

Is This Answer Correct ?    1 Yes 0 No

Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / 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

More SQL Server Interview Questions

What the class forname () does?

0 Answers  

What purpose does the model database server?

0 Answers  

What is it unwise to create wide clustered index keys?

0 Answers  

What are the different types of lock modes in sql server 2000?

0 Answers  

How do I start sql server?

0 Answers  

How to set a database state to offline in ms sql server?

0 Answers  

What is @@error in sql?

0 Answers  

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

Why olap is used?

0 Answers  

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

Explain what are sparse columns?

0 Answers  

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories