Interested to Buy Any Domain ? << Click Here >> for more details...
When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
- 2 Answers
- 17786 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
Answer Posted / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
What is the syntax and use of the coalesce function?
How do I save a sql query?
Which are the different case manipulation functions in sql?
how many groups of data types? : Sql dba
How to add a column ‘salary’ to a table employee_details?
What information is needed to connect sql*plus an oracle server?
Is like operator in sql case sensitive?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is an intersect?
What are aggregate and scalar functions?
Is drop table faster than truncate?
What is the plv (pl/vision) package offers?
What are the constraints available in sql?
what is a composite key ? : Sql dba
What is application trigger?
