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
Explain what is sql*plus?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the purpose of using pl/sql?
What are local and global Indexes and where they are useful.
What does truncate mean in sql?
What is your daily office routine?
What is the mutating table and constraining table?
What is rename in sql?
how to enter characters as hex numbers? : Sql dba
What does the argument [or replace] do?
Why cross join is used?
What is a sql trace file?
What kind of join is join?
What is program debugging?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql