Question

would either of your attributes be allowed to contain NULLS? Yes or No? Explain why or...

would either of your attributes be allowed to contain NULLS? Yes or No? Explain why or why not

in database why you can't
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Yes, attributes are allowed to contain a NULL value in the SQL database.

The attribute which is a primary key or a group of attribute which form a primary key is not allowed to contain a NULL value.

The foreign key can contain NULL value and duplicate value.

NULL Values:

NULL values are the unknown value or the value which has no result in the SQL database and these values are not equal to itself.

We can't apply any relational operator with the NULL value.

NULL == NULL no
NULL <> NULL no
NULL < NULL no
NULL > NULL no
IS NULL yes
IS NOT NULL yes
Add a comment
Know the answer?
Add Answer to:
would either of your attributes be allowed to contain NULLS? Yes or No? Explain why or...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT