Difference between primary key and unique key ?
Answer Posted / rubiya george
Primary Key Vs Unique key
1.Each table having 1. contain many UNIQUE KEYS.
only one PRIMARY KEY.
2.Primary key not accepts 2.Unique Key accepts null
null values values
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the set operators union, union all, minus & intersect meant to do?
What are the built-in functions used for sending Parameters to forms ?
What are transaction isolation levels supported by oracle?
How to get execution path reports on query statements?
What are the system predefined user roles?
Explain joins in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain overloading. Can functions be overloaded?
How to work with data objects interactively?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to use attributes of the implicit cursor in oracle?
What happens if the imported table already exists?
How to use an explicit cursor without open statements?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to insert a new row into a table in oracle?