ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
 Question Submitted By :: Elumalai.k
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
Answer
# 1
Yes, it is possible to allow NULL values in a foreign key, 
this property has a relation with the another property "ON 
UPDATE/DELETE SET NULL".
It is also possible to define multiple constraints on a 
single column.
 
Is This Answer Correct ?    4 Yes 2 No
Uma
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to work on DTS?what is the main requirement? ivan1
write the query for taking database restore in sql?  2
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18  2
How will u find the query which is running in some other machine IBM2
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
How the data stores in a page?  1
What are the two virtual tables SQL Server maintains for triggers?  2
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? HCL3
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??  1
what are the joins,primary key,foriegn key, candidate key, super key and expain them? Polaris2
What are the types of backup and tell me the difference between full and differential backup? TCS3
What is excution Plan in sql server TCS1
What is the basic difference between clustered and a non-clustered index?  3
how to implement locking in sql server Satyam1
The Difference between 'Count' and 'Count(*)'  12
What is the difference between a Local temporary table and a Global temporary table? How is each one used?  1
how to get the automatic backup of the database in the sql server  3
how to give input dynamically to a insert statement in sqlserver HCL2
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???  3
where do you use Isolations?give me some exmpale?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com