what is unique key?
Answers were Sorted based on User's Feedback
Answer / mapuka mueller
A unique key in sql signifies an attribute of an entity in a
table with the unique constraint, which simply implies that,
that a record(value) of that attribute can not be entered
more than once in that column (except null).
A further assignment of the primary key constraint to that
attribute (or a composite of two or more attributes(columns)
from values on the same row) makes it the unique identifier
of the record(row) in that table.
"It's sometimes hard to express what's in your mind but i
hope i tried"
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shreekumar nair
unique key will only allow unique values in that particular column ...but it allows multiple NULL values ...since null values are not equal to an another null value...
whereas in a primary key column we can't have that ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / laya lombi
Is the key which is commonly call as password .
| Is This Answer Correct ? | 4 Yes | 14 No |
What is a cluster?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to add another datafile to a tablespace?
How can we delete duplicate rows in a table?
How to name query output columns in oracle?
Can a parameter be passed to a cursor?
How to revoke create session privilege from a user in oracle?
How do I uninstall oracle client from windows?
Why we use bulk collect in oracle?
How do we create privileges in oracle?
What is oracle join syntax?
What is oracle host variable?