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
- 17783 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thanga prabu.n
Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / 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 |
Explain sql data types?
Is there any restriction on the use of union in embedded sql?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
What is cursor status?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are the disadvantages of not performing database normalization?
How do you modify a column in sql?
what is the use of friend function? : Sql dba
What is user in sql?
What is spool?
how do you tune the slow running queries in oracle db , explain the methodology
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
