Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 5707 Views
- I also Faced
- E-Mail Answers
Answer Posted / uday shankar dokku
candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is drivermanager getconnection?
Where is data stored in database?
Explain the difference between dbms and rdbms?
What are the lock types?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
Is declare cursor executable?
State some commands of ddl in dbms?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What are the different stages in 'data warehousing'?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What is field in database give an example?
What is ddl in dbms?
Explain what is meant by asymmetrical protocols?
What is the main purpose of triggers in database?
What is difference between database and schema?
