Difference between primary key and unique key ?
Answer Posted / niraj pratap singh
primary key has no null values whereas unique accepts null
values and in a table only one primary key is declared
whereas unique key is multiple in a table.
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to shutdown your 10g xe server from command line?
11. Display the client number and name and the client number and name of the person who referred that client.
is there a tool to trace queries, like profiler for sql server?
How to get the Installed Oracle Version Information ?
What happens to the current transaction if a ddl statement is executed?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What do you mean by merge in oracle and how can you merge two tables?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
what are archived logs?
How to get a create statement for an existing table?
What is the quickest way to fetch the data from a table?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is dual table oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
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?