Can we use more than one null value for unique key?
- 31 Answers
- 56796 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raman
Primary Key is a combination of Unique and NOT NULL
Constraints so it can’t have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL
but for SQL Server It can have only one NULL
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I debug a stored procedure?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is delimiter sql?
What are the parameter modes supported by pl/sql?
What is sequence in sql?
How do you remove duplicate records from a table?
What is difference between cursor and trigger?
What is type and rowtype in pl sql?
Can we insert in sql function?
What is data definition language?
Where the sql database files are stored?
What is difference between sql and mysql?
What are basic techniques of indexing?
Explain the steps needed to create the scheduled job?
what is the difference between union and union all? : Sql dba
