Can we use more than one null value for unique key?
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
What are the different datatypes available in PL/SQL?
How do I view tables in mysql?
Why do we use cursors?
How to get help at the sql prompt?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
what is the difference between a web-garden and a web-farm? : Sql dba
How does an execution block start and end in pl sql?
i have some prob lem to tell me about my self in interview first round ...
Does truncate release storage space?
How do you determine the current isolation level? : Transact sql
What are inner and outer joins examples of both?
what is single byte over head in oracle..?
Explain scalar functions in sql?
Explain polymorphism in pl/sql.
What is primary key in db?