waht is the difference between primary key and super key?

Answer Posted / avinash

primary key:
primary key could be any key which is able to identify
a specific row in data base in a unique manner.
super key;
different set of attributes which are able to identify
any row in the database is known as super key.

Is This Answer Correct ?    29 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the types of joins.

589


Explain the importance of .pll extension in oracle?

551


How to use "in out" parameter properly?

610


How to pass a cursor variable to a procedure?

554


What is a directory object?

587






How to run create database statement again?

618


Can we insert data in view oracle?

531


Can multiple columns be used in group by in oracle?

541


Define oracle database

594


Can a formula column referred to columns in higher group ?

2083


What is meant by raw datatype?

563


How to experiment a data lock in oracle?

593


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1524


What is the maximum number of triggers that can be applied to a single table?

552


What is parameterized cursor in oracle?

574