What is FOREIGN KEY? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher

A FOREIGN KEY is classically a type of primary key it is the normal key for he one table but it is can become a primary key for the other table, The foreign key constraints are using a referential integrity, The foreign key constraints are mainly signifies a referential integrity constraint prevents any actions that can be destroy links between tables with the corresponding data values. Its prevent actions that would leave rows with foreign key values when there are no primary keys with that value.

More interview questions and answers
What are the different index configurations a table can have?
What are different types of Collation Sensitivity?
What is OLTP?
What is form validation?What is Client Side and Server Side validation?
What do you mean by TRUNCATE?
What do you mean by DELETE command?
When is the use of UPDATE_STATISTICS command?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the properties of SUB-QUERY?
What is the difference between constants and variables in PHP?
What are the type of SUB-QUERy?
What is SQL Profiler?
What is Ant?
What is a build tool?
How many types of build tool you know?
What is different between Ant and Make?
What is History of Ant?
Which version of Java is required to run Ant?
What are the authentication modes in SQL Server? How can it be changed?
Why do you call it Ant?
What is SQL Server Agent?
When we used $_GET and $_POST variable?
How you can Prepare a project in ANT?
Why we use $_REQUEST variable?
From where we can download Ant latest version?
Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Why we use Date() function in PHP and How?
What is Log Shipping?
Why we used Server Side include function?
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
How we use include() and require() function in PHP?
What is the mean of Local temporary table?
How to use File Handling in PHP?
What do u mean by Global temporary table?
What types of modes we use in PHP for File Handling?
How we use fopen(),fclose(),feof(),fgets() and fgetc()in PHP?
How we can set the PATH environment variable of ant?
What you know about Cookie?
What operation we can perform with Cookie?Explain it?
How we Sessions in PHP?
What is the STUFF function and how does it differ from the REPLACE function?
How we handle errors in PHP ?
How we use Simple \"die()\" statements error handling method in PHP?
How we use Custom errors and error triggers error handling methods in PHP?
What is UNIQUE KEY constraint?
How we use Error logging method in PHP?
What is CHECK Constraint?
What is NOT NULL Constraint?
What is a Scheduled Jobs or What is a Scheduled Tasks?
What are the advantages of using Stored Procedures?
What do you understand about Exception Handling in PHP?
What is BCP? When does it used?
How to implement one-to-one,one-to-many and many-to-many relationships while designing tables?
What is Filter?How we use them?
Can a java source file hava more than one public classes?
What is an execution plan? When would you use it? How would you view the execution plan?
What do you mean by The master database?
Define The msdb database?
What do u mean by The tempdb?
What is the mean of The model?
Define whats the mean by Resoure Database?
What is Service Broker?
What is .htaccess file and how to use them?
What is Policy Management?
What is the difference b/n \'action\' and \'target\' in form tag?
What is the substitution of submit in PHP?
What is the DDL,DCL and DML?
What is the difference b/w PHP4 and PHP5?
What is Replication and Database Mirroring?
What are Sparse Columns?
What is the difference between $i and $$i?
What does TOP Operator Do?
Write some array sort functions available in php ?
What is CTE?
How to encrypt the password in PHP?
Which pre-defined classes in php?
What is the difference between unlink and unset ?
What is MERGE Statement?
What do you understand about PHP accelerator ?
What is Filtered Index?
How to get path of php.ini with a PHP script?
Output of the code? $objM = new M(); // Where, M is a class $objN = $objM;
What are the Advantages of using CTE?
How to distinguish between PHP and HTML?
What is CLR?
How we use ceil() and floor() function in PHP?
What are synonyms?
What is the significance of destructor in PHP?
What is LINQ?
What is the different b/w session and cookies in php?
What is the answer of following code echo 1< 2 and echo 1 >2 ?
What is Isolation Levels?
What is the difference b/w isset and empty?
What is the EXCEPT clause?
Can i convert PHP code into JAVA code?if yes,how?
What is the NOLOCK?
Tell how we can run PHP in command line?
What do you understand about Magic Code in PHP?