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
- 6312 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar
Foreign key consider only the values. According to null value is not a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
I have student marks in a student table. I need second highest mark .Then what will the query for this?
37 Answers NetCore, Patni, SAP Labs, Temenos, Wipro,
How will you optimize a stored procedure optimization?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is the native system stored procedure to execute a command against all databases?
What triggers long term care?
What is an indexing technique?
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
What are the differences between char and varchar in ms sql server?
What is resource governor in sql server?
How can i Relate Tables in SSIS
What is the difference between count () and rowcount ()?
how to implement locking in sql server
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
