Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 6102 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
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
What is variable dbms?
What are different partitioning techniques in database?
What is metadata and why should I use it?
What is structure of dbms?
How do I create a database in open office?
What are the two types of database?
What are indexes? What are b-trees?
State at least four kinds of indexing?
How do you notify dbpak about stored procedure?
Tell me about view, sequence and index in DBMS.
how to restore particular schema from rman full backup?
What is data model in database?
What is the default '-sort' order for a sql?
Explain data dictionary.
