Define candidate key, alternate key, composite key?

Answer Posted / rajneesh

primary key: should be unique and Not Null
Unique Key: accept 1 null value and unique

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about the storage and physical database design?

533


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1585


How to use online Backups?

1728


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

592


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1674






What are the three types of database design?

543


Explain about network model?

585


What are the three basic rules which are to be followed for the relational model of the database?

563


How to combine two function together?

1661


How to generate OIDS

1662


In which database can extended stored procedures be added?

530


What is the database development process?

689


What are the main phases of database development?

540


Why does this query return 0?

623


State the acid rules?

682