Explain the key constraints and constraints on Null Values
with examples?
Answers were Sorted based on User's Feedback
Answer / amit
hi ,
key constraits i.e. referential integerity means
all values in foreign key must be in primary key , but it
may happnes that NULL values may be in foreign key , but
not in primary key .
this is done to cater some of the exception conditions.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / navin kumar
because the key constraints can contains NULL value
but constrains not.
navin south delhi
| Is This Answer Correct ? | 0 Yes | 0 No |
Define join types.
How do you handle your own transaction?
What is cold backup (in case of oracle)?
What is the Result of the following 'VIK'||NULL||'RAM' ?
1 Answers HP, Manthan Solutions,
Explain by listing some of dbms major advantages.
What is the main purpose of a database?
What is the structure of a database?
What is primary key in database?
Which database is used by google?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
Explain types of indexing in dbms?
Define and explain about progress?
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)