SQL interview question on foreign key | SQL interview preparation | SoftwareTestingbyMKT | SQL DBMS

To join my upcoming courses/classes please fill below form

Join this channel to get access to the perks:

Like, share and subscribe to the channel.
API Testing Playlist

Core Java Playlist

Selenium Playlist

Manual testing Playlist

Watch my other videos too,
Inheritance in Java video

Single level inheritance video

Multi Level Inheritance in Java video

Hierarchical Level Inheritance in Java video

Hybrid Level Inheritance in Java video

Method Overloading in Java video

This calling statement in Java or this() video

Constructor Overloading in Java video

Constructor in Java video

Static and Non Static Variables in Java video

How to Create an Object in Java & Handing non Static method video

Multiple static methods inside a single Class | How to deal it?

Methods in Java | What exactly is public static void main(String[] args)

Types of Variables in Java | Local,Global & Final Variables

Variable and Datatype in Java

Easy way to run a program in Java | First program in Java

Class and Object in java

50 Keywords in Java

Tokens in Java

How Java internally works?| Compilation & Interpretation

Introduction to Java | History of Java |Features of Java
Derived model in software development life cycle video link

Prototype model in software development life cycle video link

Spiral model in software development life cycle video link

Verification and Validation in software development life cycle video

Hybrid model in software development life cycle video video

Waterfall model in software development video link

Software development life cycle video link

What is manual testing, it's advantages and disadvantages video link

What is Software testing video link

I work in the IT industry as a Senior Software QA Engineer in Bangalore, India and I have worked on mobile applications, web applications, and API testing.
The main reason behind this channel is to educate people about software testing so that it will helpful for them to choose the right career and also to prepare for their interviews.

Adding my blog link

Adding my personal mail Id:

Adding my Quora profile link here:

Adding my Twitter account here,
or
Facebook Page:

Join us on Telegram today,
SoftwaretestingbyMKT
For the latest update on software jobs and to discuss each and everything about Software Testing also get an opportunity to get on an audio/video call with me directly to you.
I make videos on daily basics and also help student all over the world for FREE. If my videos are helpful in anyway help "SoftwaretestingbyMKT" reach billions by supporting
OR

[venkat]

Yes it is Right statement, foreign key always can accept duplicate and null .

[taslimtassu]

Yes.. It's true.. Because foreign key builds a relationship between two tables that is why foreign key will accept duplicate as well as null values...

[mangeshmane]

Yes applicable to foreign key but not to primary key

[venkateswaraprasad]

Yes foreign key allows null or duplicate values so it is true

[shravanjangale]

Yes, bcz it’s link with parent table. So, it can accept duplicate as well as null values.

[ritikanagpal]

Yes, it’s a true standard, foreign key can be duplicate and null

[kaustavroy]

Yes it's a true statement... Foreign key accepts null and duplicate values ... Only primary key get error on duplicate and null statement

[himanshipachouri]

Yes its true statement foreign key can be duplicate or null .

[rukminipolkam]

yes foreign key accept duplicate and null values because it is used to create a relationship between the two tables . In this two tables only one primary key allowed but more than foreign key can allowed .

[Lovelyboys]

Yes. Because primary key doesn't allow duplicate and null. But foreign key allows duplicate or null

[viveshinid]

Yes Crt it accepts Nul nd duplicate values

[RsaikumarReddy-zdgx]

Yes foreign key will be accept both duplicate and null values.

[AbhishekYadav-fbuh]

Yes . Foreign have duplicate values and as well null.

Foreign keys in SQL are used to create a relationship between two tables. It is a column that creates a relationship between the tables by taking a reference from another table in the same database using the primary key. The foreign key may contain null and duplicate values.

[nareshdjnareshdj-uyvs]

Yes FK always can accept Duplicate values...