Difference between primary key and unique key ?
Answer Posted / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
Explain a data segment?
Are truncate and delete commands same? If so why?
What are the ways tablespaces can be managed and how do they differ?
How do you find current date and time in oracle?
How translate command is different from replace?
What is a sub query? Describe its types?
How to resolve name conflicts between variables and columns?
candidate key is subset of super key but not vice-verse explain
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a private synonym?
What is the difference between sharding and partitioning?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.