Difference between primary key and unique key ?
Answer Posted / sreesakthi
primary key will not allow null values whereas unique key
will allow null values.we have only one primary key per
table,but we can have more than one unique key per table
| Is This Answer Correct ? | 25 Yes | 8 No |
Post New Answer View All Answers
How are extents allocated to a segment?
How to open and close an explicit cursor in oracle?
How do I manually create a database in oracle?
What is the usage of control file in oracle?
Explain about your project and its relation to the current job position you are applying to?
Differentiate between translate and replace?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to define an oracle cursor variable?
What is oracle server autotrace in oracle?
How to define an external table with a text file?
Differentiate between function and procedure in oracle.
Difference between varchar and varchar2 data types?
How to get a list of all user accounts in the database?
What happens to the current transaction if the session is killed?
How do I use os authentication with weblogic jdriver for oracle and connection pools?