Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 26328 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 |
Who developed oracle & when?
When system tablespace is created?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
candidate key is subset of super key but not vice-verse explain
What are internal user account in oracle?
Explain implicit cursor.
How translate command is different from replace?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
what is a cartition product?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
1. what is a single procedure? 2. suppose a view constructed on a query... after that in the master table a column was dropped, then what will be the status of that view? will it be invalid or something else? 3. what is mutating table error? how can you solve that problem? 4. suppose "select * from emp where empno=7788;" is running slow because of what ever the cause it is.. how can you fix it and make the execution faster? 5. will the snapshot of data will be stored in the RAM , where will ir be stored exactly. 6. how to delete 100 tables or 100000 tables' data from the schema without writing delete statement for no.of times. write an sql statement to do that job. 7. suppose a package contains so many cursors, procedures and all.. and we are using such types of procedures so many in a program. so the execution is to be stored all those packages and all to the RAM. utimately it is using many resources for each time execution. how can you reduce the time and using of resources for each execution because the query need to be run many times. how can you tune that? 8. suppose a procudere is there with specs as (a,b,c,d), all of these are IN mode only then while calling them should we pass all the 4 arguments? how to pass (b,c) only.. how ever the specs are wrote in the same order displayed in the above? 9. a function is returning a table type, how to access that function in a select statement? 10. i have a table in database A and another table in database B, how can you access the data of these two tables? write a query for that with dblinks. 11. i have two tables might have 15/20 columns in that.. i wanna send these columns(table) to the front end application for example you are using asp.net by writing a procedure. write that to perform the above job. 12. shall we create a table in the package? 13. shall we create a table in the procedure? 14. suppose i have 10 records, in that i want to select 7th record. write a query for that. cant you use rownum for this? 15. suppose my procedure has got around 20 select statements, in that some three select statements are running very slow. what will you write to detect which queries are running slowly? 16. what fields you use frequently in plan_table? 17. what is pipeline function? explain me with an example. 18. does a unique column can contain more than one null? 19. how many hints are there provided by oracle?
Explain oracle instance.
Oracle General 
