what is candidate key & super key
Answer / 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 |
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
WHAT IS ecc 6.0
How to write an inner join with the where clause in oracle?
What is oracle used for?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is an oracle tablespace?
How to manage transaction isolation level?
How to rollback the current transaction in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How do I recompile a procedure in oracle?