waht is the difference between primary key and super key?
- 9 Answers
- 29533 Views
- I also Faced
- E-Mail Answers
Answer Posted / nilesh
Different set of attributes which are able to identify any
row in the database is known as super key. And minimal
super key is termed as candidate key i.e. among set of
super keys one with minimum number of attributes. Primary
key could be any key which is able to identify a specific
row in database in a unique manner.
| Is This Answer Correct ? | 56 Yes | 19 No |
Post New Answer View All Answers
Explain enable novalidate constraint.
What are the components of logical database structure in oracle database?
What is a select query statement in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to find the duplicate rows count from employees table in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How to turn on or off recycle bin for the instance?
What is a read only transaction in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is java oracle used for?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to assign values to variables?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to call a sub procedure?
Can we write insert statement in function in oracle?
