Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
Answer / uma
Yes, it is possible to allow NULL values in a foreign key,
this property has a relation with the another property "ON
UPDATE/DELETE SET NULL".
It is also possible to define multiple constraints on a
single column.
| Is This Answer Correct ? | 10 Yes | 4 No |
write sql program to get the detail of student in a class?
Why do we partition data?
Do you know what are pages and extents? : SQL Server Architecture
How to create a scrollable cursor with the scroll option?
Distinguish between commit and rollback?
how many joins we can write if at all we have n no of tables
5 Answers Tanla Solutions, TS,
How can we delete Duplicate row in table?
Is Sql non procedural query language?
 Explain what is sql override for a source taLle in a mapping?
What is collation sensitivity? Explain different types.
Can you explain what is indexed view? How to create it?
What are the different sql server versions?
Oracle (3259)
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)