waht is the difference between primary key and super key?
Answer Posted / sweety singh
superkey is a set of attributes that can uniquely identify
individual tuples whereas a key or a primary key is a
minimal super key that can identify individual tuples.
ex..eno pno hrs
1 1 2
2 4 7
i.e...here eno,pno,hrs together are a superkey but eno,pno
is primary key and hence eno,pno cant hav null values and
repeated enteries....
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is oracle rowcount?
What are the major difference between truncate and delete?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How do I know if oracle is installed on windows?
What are the different editions of oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What happens to the current transaction if the session is killed?
What is a dead lock in oracle?
What is the usage of merge statement?
What is an oracle user account?
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.
How do I manually uninstall oracle client?
Can group functions be used in the order by clause in oracle?
Can we connect to ORACLE db using Windows Authentication?
How many types of tables supported by oracle?