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 convert csv to table in oracle?
What do you mean by group by clause?
How to execute a stored procedure in oracle?
What is sequence?
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.
i want department wise maxmum salary and empolyee name
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
How to do paging with oracle?
What is a data segment ?
how to find out second largest value in the table
What is an oracle table?
What is the maximum limit on the number of columns in a table?