what is the different between unique+not null & primary key,

Answer Posted / mohan babu

A unique key is nothing but it does not allow any
duplicateds but allows nullvalues

A primary key is nothing but it does not allow duplicates
as well as Null values i.e Not Nulls

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between stored procedure and view?

526


Can you have more than one trigger on a table?

526


Which command is used to delete a trigger?

765


Write a query to find the names of users that begin with "um" in sql?

493


How to check if a column is nullable before setting to nullable?

580






How many types of tables are there?

496


What do you understand by pl/sql packages?

566


how to enter binary numbers in sql statements? : Sql dba

487


Are sql database names case sensitive?

493


What is hibernate and its relation to sql?

587


What is difference between sql and oracle?

554


How much does a sql dba make? : SQL DBA

501


How do I send sql query results to excel?

569


What is a sql instance vs database?

570


List the various privileges that a user can grant to another user?

570