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 trigger in sql?

729


What is audit logout in sql profiler?

797


How do I run a program in pl sql?

734


What is scalar function?

796


What does over partition by mean in sql?

730


What are the most important characteristics of pl/sql?

815


Why use subqueries instead of joins?

830


How do I make my sql query run faster?

706


How do I sort a table in sql?

808


What is break?

902


Can %notfound return null after a fetch?

789


What is a constraint? Tell me about its various levels.

879


Write a sql query to get the third highest salary of an employee from employee_table?

869


How do I save the results of sql query in a file?

747


Why schema is used in sql?

759