What is Difference Between Unique and Primary Key Constraints?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Can we use out parameter in function?

4 Answers   Infosys,


what happens if null values are involved in expressions? : Sql dba

0 Answers  


how many groups of data types? : Sql dba

0 Answers  


What are the PL/SQL Statements used in cursor processing ?

4 Answers  


what is schema? : Sql dba

0 Answers  






What is a trigger word?

0 Answers  


What are the usage of SAVEPOINTS?

5 Answers  


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  


What is pl sql in oracle?

0 Answers  


Which version of sql do I have?

0 Answers  


how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  


What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,


Categories