Explain the key constraints and constraints on Null Values
with examples?
Answer Posted / 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 |
Post New Answer View All Answers
Should database table names be capitalized?
Explain dml (data manipulation language)?
How is rdbms different from dbms?
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?
What is a distributed database system?
How can you perform pattern matching in sql?
How do you create a database for an organization?
What is flag in database?
Explain the types of database normalization?
what is scan listener.
What do you understand by correlated subqueries in dbms?
What are the two types of database?
What is a key in database?
Is database a data structure?
What are stored-procedures? And what are the advantages of using them.