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
How do I limit the number of oracle database connections generated by weblogic server?
How to rename a column in an existing table?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is pragma autonomous transaction in oracle?
What are the different types of modules in oracle forms?
How to import one table back from a dump file?
How can you use check constraints for self referential integrity?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to get the Installed Oracle Version Information ?
How to define a data field as not null?
How to create a new user account in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to change program global area (pga) in oracle?
What are the advantages of oracle 12c?