What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
Answer Posted / kiran
if unique then it can have null
but if column has primary then it cannot have null values
and duplicate values
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to find out what oracle odbc drivers are installed?
How to turn on or off recycle bin for the instance?
What is a proxy class?
How do I reset a sequence in oracle?
What is literal?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Is it possible to insert comments into sql statements return in the data model editor ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to speed up webrick?
What privilege is needed for a user to create tables in oracle?
What is the difference between post-database commit and post-form commit?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Compare and contrast between sql and sql server and explain its various functions?
What is not equal to in oracle?