<div>
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.<br />
<br />
Please confirm if I understand right !
</div>


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 !

<div>
Correct. &nbsp;Candidate key is the classroom term, I'm told. &nbsp;Oracle does not use the term, but does use the concept.
</div>


Correct.  Candidate key is the classroom term, I'm told.  Oracle does not use the term, but does use the concept.

<div>
<div class="content wysiwyg-content">
This was the interview question I had :<br />
<br />
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?
</div>
</div>


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?

Candidate Keys - Primary keys in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.