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 is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to assign a table row to a record variable?
When do we use group by clause in a sql query?
What is open database communication (odbc) in oracle?
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.
What is background process in Oracle?
How to build data dictionary view an new database?
Is oracle an open source?
How does Oracle guarantee data integrity of data changes?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to connect to a remote server?
What are the various oracle database objects?
What is a snapshot in oracle database?
How to create a table interactively?
How many categories of data types?