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

What is the normal procedure followed by a java client to access the db?

434


Define scalar functions.

536


What are the examples of database?

472


Define atomicity and aggregation.

544


How to migrate paradox, dbase or foxpro database to firebird?

532






Explain a checkpoint and when does it occur?

514


How do you create a report in a database?

446


Define union all operator and union.

522


What do you understand by the terms entity, entity type, and entity set in dbms?

509


What is a Federated Query ?

583


What is like operator for and what are wild cards?

480


Which database is best for storing large data?

451


Why do we need database management?

482


What is the rdbms concept in sql?

460


What is cold backup (in case of oracle)?

510