Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 209976 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 / omkar
In any table there can be one and only one primary key
(composite priamry key can have more than 1 column but
together conside one key only) but more than one unique
keys.
Primary key cannot accecpt null value.unique key accecpts
one or more than one null values.
primary key uniquly identifies the table but unique key is
used for uniquly identified of table as it contain one or
more than onee null.
Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How do we get field details of a table?
Write a syntax for update query in oracle?
How to use "if" statements on multiple conditions?
Give the constructs of a package, function or a procedure.
What are the extensions used by oracle reports?
What is a initialization parameter file in oracle?
Which is better Oracle or MS SQL? Why?
Explain the use of constraints option in exp command.
What is a table index?
Why do we need integrity constraints in a database?
How to use subqueries with the in operator using oracle?
What is a trigger oracle?
List out the components of logical database structure of oracle database.
