Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

another CHARACTER field in another table. What will be the results for records with field value of NULL?

April 26, 2017character field null records results Table value

0

Posted

another CHARACTER field in another table. What will be the results for records with field value of NULL?

1 Answer

0

Posted

(Check one that applies the best) A. TRUE B. B. FALSE C. C. UNKNOWN D. D. Error. E. E. Those records will be ignored A45) C. NULL in a row when compared will give an UNKNOWN result. Q46) Any database needs to go through a normalization process to make sure that data is represented only once. This will eliminate problems with creating or destroying data in the database. The normalization process is done usually in three steps which results in first, second and third normal forms.