Solved

Candidate Keys - Primary keys in Oracle

Posted on 2013-12-10
5
439 Views
Last Modified: 2013-12-10
This was the interview question I had :

What are candidate keys? Suppose three candidate keys have been identified. Which one will become the primary key? Can all three candidate keys be made into composite primary key?
0
Comment
Question by:d27m11y
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 23

Assisted Solution

by:David
David earned 250 total points
ID: 39708999
Second question, yes, provided the concatenated string that results is unique.

You answered the first question:  candidates are potential primary key fields.  Between the business requirements, and the architect, a selection must be made on what's the best choice.

An Internet search will yield you examples and specifics.

HTH
0
 

Author Comment

by:d27m11y
ID: 39709090
Can I say that candidate key is the key column that uniquely identifies the data in a row and the candidate key could be composite primary key provided it is unique.

Please confirm if I understand right !
0
 
LVL 23

Expert Comment

by:David
ID: 39709170
Correct.  Candidate key is the classroom term, I'm told.  Oracle does not use the term, but does use the concept.
0
 
LVL 32

Accepted Solution

by:
awking00 earned 250 total points
ID: 39709412
>>Can I say that candidate key is the key column that uniquely identifies the data in a row<<
I would say it slightly differently -
A candidate key is a column or combination of columns that will always define a unique row.
Assume table x has cola, colb, and colc with the following values:
a1, b1, c1
a2, b2, c2
a3, b3, c3
In this case uniqueness can be defined by [cola], [colb], [colc], [cola,colb], [cola,colc], [colb,colc), or [cola,colb,colc]
However, if table x could have a row such as a1, b2, c3, the only candidate key would be [cola,colb,colc]

>>and the candidate key could be composite primary key provided it is unique.<<
Correct as demonstrated above
0
 

Author Closing Comment

by:d27m11y
ID: 39709430
Understood.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question