answersLogoWhite

0


Best Answer

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

A foreign can have null values and it can have duplicate values.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

A foreign can have null values and it can have duplicate values.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Does foreign key alllows null values and duplicate values?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can a foreign key be null?

yes .a foreign key can have null values


Have foreign keys null values?

Yes Foreign key can have null value.


What is key constraints?

Primary Key is a Constraint Used to avoid Duplicate entries in database table and you define primary key the column doesn't allow NULL values.


What is primary key constraint?

Primary Key is a Constraint Used to avoid Duplicate entries in database table and you define primary key the column doesn't allow NULL values.


Can a primary key have a blank or null value entered into its cell?

No. A Primary Key is the Unique identifier and cannot be null and cannot be duplicate.


What are the various reasons that lead to the occurrence of NULL values in relations?

A given field in a database table might be for a values that, in certain case, no such values exist or can be determined. For example, in an employee database, a field might be a foreign key to that employee's direct manager. However, in the case of the CEO, there is no such person. In that case, the field would be set to Null.


Did Group functions include nulls in calculations?

no null values will not be included explanation when oracle parse the query the null values will be omitted for some reason if you want to consider null values you have to use some oracle functions like nvl or nvl2


Can the foreign key accept null?

yes


Is the last name a primary key?

A primary key is always unique and not null. It is prefer to choose a field that is unique like roll number . But to choose Last name as a primary key is not a good option as two people can have same last name.A Last name field is not a good one for a primary key. A primary key cannot have duplicate values. A last name field is highly likely to have duplicate values, so it should not be used as a primary key.


What are the three interpretations for null values?

In a database it can be 'not known' or 'not applicable'.


Is the critical region the values of the test statistics for which the null hypothesis will reject?

The null hypothesis will not reject - it is a hypothesis and is not capable of rejecting anything. The critical region consists of the values of the test statistic where YOU will reject the null hypothesis in favour of the expressed alternative hypothesis.


Why null values in database?

The 'null'-content of any given field is just that. It's a 'nothing'. Example, if you create a database to hold chemical values for instance. If the values are, for example, real nubers. That would imply that any value that has 0 in it, is just that; zero. It was beeing measured, and found to contain zero. On the other hand if a value was not tested, the value of that compound should be set to 'null'. If a 'null' value isn't supported by the database a workaround is to set 'null' values to -1 (as per the example above). --