what is unique key?
Answer Posted / ambresh pratap srivastava
primary key is combination of column which uniquely specify a row.A table have at most one primary key. primary key creates Clustered Index.A primary key column allows no row having null value
Unique key can uniquely identify each row in a table and is closely related to super key concept.A unique key comprises a single column or a group of column.A unique key column allows only one row having null value.Unique key creates unclustered Index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to add another datafile to a tablespace?
Explain what are clusters?
What are the execution control statements in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
Difference between the “verify” and “feedback” command?
How to define a record variable to store a table row?
How can we find out the duplicate values in an oracle table?
Explain index?
What is meant by recursive hints in oracle?
Give syntax for SQL and ORACLE joins.
What happens to the current transaction if the session is killed?
What is set verify off in oracle?
How to return top 5 rows in oracle?
What are the types of trigger in oracle?