retagged by
636 views
2 votes
2 votes

The Given Answer is C) , 

my doubt is can PassportNo take NULL values as it is defined as UNIQUE ?

retagged by

2 Answers

Best answer
4 votes
4 votes
Yes it can take Null values.

Bcoz constraint is unique, and Null is never equal to Null.If the constraint is specified as not Null then it cannot take but for unique it can take Null value for all rows.
selected by

Related questions

0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
717 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
431 views
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)