Interested to Buy Any Domain ? << Click Here >> for more details...
"primary key=unique+null" is equal,reson?not,reason?
- 5 Answers
- 7085 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 |
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
How to sort the query output in oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What is a read only transaction in oracle?
What is recovery manager(rman) backup in Oracle?
What is the function of Optimizer ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Explain the difference between a procedure and a function?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
In which language oracle has been developed?
How to store pictures on to the database?
Oracle General 
