Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 26937 Views
- Amazon, Cap Gemini, Infosys, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / romee
Unique Key is a candidate key to uniquely identify each
row in a table.
| Is This Answer Correct ? | 38 Yes | 7 No |
Answer / guest
It is a constraint used to avoid duplication of values
within the row of a specified column or set of columns in a
table. It can also allow null values
| Is This Answer Correct ? | 20 Yes | 5 No |
Answer / jai
UNIQUE key is a constraint which can be applied on a data
base table column for uniquely identifying the values in
that column but the column can contain NULL values.
without duplicates but with NULL values
| Is This Answer Correct ? | 16 Yes | 5 No |
Answer / koteswara rao.k
suppose you have landline and through the landline you have
taken net connection .
so at the end of the month you will get two bills on the
landline which is subject to one means
primary key is landline which is parent one ( customer
code available)
broadband and landline ( two bills generation ) are the
unique keys called child keys .(contract ids available)
so in this scenario contract ids can be null but cannot be
duplicate .
One more You cannot remove the primary key until and unless
remove the branched ones.
I have good knowledge on GSM /broadband/pstn technologies .
Any wrong ping with me pls koteswara.9.rao@gmail.com
| Is This Answer Correct ? | 10 Yes | 5 No |
a sort of primary key..just it allows NULL values
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / vital reddy
suppose you have landline and through the landline you have
taken net connection .
so at the end of the month you will get two bills on the
landline which is subject to one means
primary key is landline which is parent one ( customer
code available)
broadband and landline ( two bills generation ) are the
unique keys called child keys .(contract ids available)
so in this scenario contract ids can be null but cannot be
duplicate .
One more You cannot remove the primary key until and unless
remove the branched ones.
I have good knowledge on GSM /broadband/pstn technologies .
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / neo devan
Any key may/maynot satisfy 2 conditions :
* Not Null
* Unique
Unique key is tne one which satifies the second condition
but it can have null values.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / gyana ranjan behera
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to increment dates by 1 in oracle?
can u call user defined functions in select statements
Is insert autocommit in oracle?
Calculate difference between 2 date / times in oracle sql?
How can we find out the current date and time in oracle?
What is the difference between an Oracle Schema and an Oracle Instance?
How to create a testing table in oracle?
What is oracle and what are its different editions?
What is a nested table?
1.display list of all users from ur data base.what is the query?
Can we store pictures in the database and if so, how it can be done?
what r tyhe major differences between oracle 9i & 10g?
Oracle General 
