Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 5939 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naz
A Candidate Key can be any column or a combination of
columns that can qualify as unique key in database. There
can be multiple Candidate Keys in one table. Each Candidate
Key can qualify as Primary Key.
A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
Answer / parijatha
there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the ACID Properties in a Database and Why are They Important?
What are the characteristics of database?
i need query for displaying the eno,ename in a table from row 2 to row 5
What is write ahead logging in DBMS?
What are the types of database users?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What is the use of PARFILE option in EXP command ?
Explain what are triggers and rules?
What is data model in database?
What is the difference between oracle CPU and PSU?
What restrictions can you apply when you are creating views?
What is unique key in dbms?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
