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


Please Help Members By Posting Answers For Below Questions

Explain what is meant by asymmetrical protocols?

485


What is the purpose of a database?

541


What the default privileges which get assigned ?

505


What is dbms pdf?

610


What do you understand by sub-queries in sql?

493






What is erd?

588


What is alternate key?

520


How do you rename a database?

475


How do you copy a database?

501


Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2549


What are five main functions of a database administrator?

456


What are stored-procedures? And what are the advantages of using them.

469


How to disconnect the user connection?

524


What are the advantages of database system?

484


What is write ahead logging in DBMS?

598