What is differance unique key and primary key.

Answer Posted / rahul khanke

primary key : primary key dose not except null value
unique key : it accept null values.. if it set to not null
then it as good as primary key.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

563


how to convert character strings to numeric values? : Sql dba

564


Does access use sql?

551


What is meant by truncate in sql?

518


Is a view faster than a stored procedure?

538






Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2056


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

623


What is a null value?

650


In what condition is it good to disable a trigger?

546


What is thread join () in threading?

534


Define commit?

537


Is sql free?

493


Explain correlated query work?

581


What does trigger mean in psychology?

528


What are the datatypes available in pl/sql ?

602