Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the difference between candidate
key and primary key
- 4 Answers
- 8278 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vani
A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / arijit
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prasad
There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pooja
A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.
candidate key:All that fields which can be selected as
primary key are called candidate keys.
| Is This Answer Correct ? | 0 Yes | 1 No |
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
How to get the definition of a user defined function back?
What xml support does the sql server extend?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
A trigger can reference objects outside the current database? State true or false.
How to disable stored procedure sql server?
How is table type constraint applied to a table?
Why do we use functions?
How would you choose between a clustered and a non-clustered index?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
-
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)
