what is candidate key & super key

Answer Posted / naresh

Cnadidate Key:
A Candidate Key (CK) is a column or group of columns that
uniquely describe every row in a table. The difficult thing
with this is that there may be exceptions in almost every
case. For instance, it is possible to have two people who
share the same name and birthdate but are really two
different people.

Super Key:
a superkey is a set of composite columns forming a key that
may be used to uniquely identify a row in a table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1444


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1670


What are named parameters?

610


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1203


How does oracle handle read consistency?

674






What are the tools for Oracle ?

602


What is a snapshot log?

564


what is the dual table in oracle?

549


What are internal user account in oracle?

567


11. Display the client number and name and the client number and name of the person who referred that client.

1918


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2886


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1587


Respected sir, Please send me technical questions related to oracle apps..

1377


Is a rollback possible to any savepoint?

556


Can multiple columns be used in group by in oracle?

541