Answer Posted / prashant
Primary key = Unique Index + Not NUll Constraint .
So we can create primary key without Unique index ..But it
is created as combination of both (Unique Index + Not NUll
Constraint ) in oracle databases.
We need not have to create Unique index . :)
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is a left inner join?
Can we use join in subquery?
How to display Row Number with Records in Oracle SQL Plus?
What are the parts of a basic sql query?
What is application trigger?
What are the advantages of stored procedure?
What is sql lookup?
What is normalization in a database?
What is rowtype?
how can we know the count/number of elements of an array? : Sql dba
What is memory optimized?
how to drop an existing view in mysql? : Sql dba
Why is sql better than hql?
what is the difference between truncate and drop statements? : Sql dba
What is dba in sql? : SQL DBA