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
How to use select statement to count the number of rows in oracle?
Which is better Oracle or MS SQL? Why?
What is oracle and what are its different editions?
What is the data pump export utility?
How to find out what oracle odbc drivers are installed?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is a sub query? Describe its types?
11. Display the client number and name and the client number and name of the person who referred that client.
What is oracle analytical function?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Name the various constraints used in oracle?
How to put more than 1000 values into an oracle in clause?
What are the different types of synonyms?
how to join query for one source type is oracle another source type is sql server ?
Explain the use of inctype option in exp command.