What is candidate key and primary key, explain different between these two?
Submitted by: Administratorcandidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
Submitted by: Administrator
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.
Submitted by: Administrator
Read Online Database Management Job Interview Questions And Answers
Top Database Management Questions
☺ | What is ORACLE CLINICAL? |
☺ | What is the difference between oracle CPU and PSU? |
☺ | Explain What are the uses of Oracle clinical? |
☺ | What is the difference between inline query and corelated subquery? |
☺ | How to store space between two strings in database i.e |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |