"primary key=unique+null" is equal,reson?not,reason?
- 5 Answers
- 6215 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
Primary Key = unique + Not null
Because primary key is used to uniquely identify each row
of the table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / karunakar reddy s
primary key = unique and not null in a table
because primary key act as foreign key in other table, and
we can identify the records using this key. If pk has null
value how can we identify the records in the first table
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / devaraja.m
Primary key should be Unique + not null. hence
Primary key = unique+ Not null.
primary having the best role in al table, without PK we
cont identify the table itself. because it should be only
one & should not be zero.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sajeda
primary key = unique+ null
Because the primary key identyfi uniqe value that does not
contain nll values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s.rama devi
if we create pk for any column in table. That column dont
allow the duplicate values and also not null values
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between translate and replace in oracle?
how to find the second highest salary in a given table????
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Respected sir, Please send me technical questions related to oracle apps..
What is the best way to do multi-row insert in oracle?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
How to see the table columns used in an index?
What is the use of aggregate functions in oracle?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
Can you tell me how to add new column in existing views?how?How is possible?
what are pseudocolumns?
Does a Before form trigger fire when the parameter form is suppressed ?
Oracle General 
