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 |
How to delete all rows a table in oracle?
What are the different types of synonyms?
what is the bitmap index?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
What is an oracle transaction?
What is a Segment ?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
How to define a specific record type?
what is the difference between first normal form & second normal form?