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 ?    1 Yes 0 No
Uma
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is normalization in Database ?  3
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000  3
How can u convert the Date to String? TCS4
Explain the basic concepts of SQL server architecture?  2
how can i store resumes in database? HCL1
what is Archive old data?  1
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  10
how can u select the Distinct values in the table, table having 20 columns , i want all columns  1
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds4
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?  2
Alternative way to DetDate() function?  2
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?  6
What is the difference between temp table and table variable? Microsoft3
What is a join and their types? Challenger-Financial2
how to get 25th row in any table in sqlserver can u tell me syntax  4
What is a materialized view?  2
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  1
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
When you first load SQL SERVER you will startup with what all databases? CompuSol2
What is normalization?  5
 
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