Difference between primary key and unique key ?
- 77 Answers
- 198300 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
What is oracle open database communication (odbc)?
Please explain joins in oracle?
What is the maximum limit on the number of columns in a table?
What is merge statement used for?
What is a tns service name?
What is clustered table in Oracle?
How to delete multiple rows from a table in oracle?
What is oracle used for?
How remove data files before opening a database?
Is there a function to split a string in plsql?
How do I limit the number of oracle database connections generated by weblogic server?
Can objects of the same schema reside in different tablespace?
How to start a new transaction in oracle?
Is a rollback possible to any savepoint?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
