Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have more than one NULL in a column having unique
constraint?
- 12 Answers
- 16492 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / habibur rahaman
It depends upon the database on which you are working.....in SQL we can have only one value but in oracle we can have n no of values.......i did it practically.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain different types of joins?
What are the different authentication modes in sql server? How can it be changed?
What is master database? : SQL Server Architecture
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Does partitioning help performance?
How use inner join in sql server?
which backup strategy you are following at ur company
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is serializable?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How does index makes search faster?
How to convert binary strings into integers in ms sql server?
What is the difference between a local and a global temporary table?
How to create a simple stored procedure in ms sql server?
Can you always create a cache of a report?
