Is it possible to allow NULL values in foreign key? I s it possible to use

Advertise your Business Here

Refer this Site

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

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL 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

Question	Asked @	Answers
Other SQL Server Interview Questions


How to work on DTS?what is the main requirement?	ivan	1
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	IBM	2
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?	Accenture	3
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?	HCL	3
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?	Polaris	2
What are the types of backup and tell me the difference between full and differential backup?	TCS	3
What is excution Plan in sql server	TCS	1
What is the basic difference between clustered and a non-clustered index?		3
how to implement locking in sql server	Satyam	1
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	HCL	2
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 \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

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