A table designed to store PhoneNumber01,PhoneNumber02 and PhoneNumber03 contains ________.
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
E)None of the above is correct.

Question

Quizplus · Accepted Answer

Storing multiple phone numbers in separate columns (PhoneNumber01, PhoneNumber02, PhoneNumber03) is an example of the multivalued, multicolumn problem. This can make it difficult to retrieve and analyze the data efficiently, and may require more complex queries to extract the information needed. A better solution would be to create a separate table for phone numbers, with one row per phone number and a foreign key linking each phone number to the person or entity it belongs to.

A Table Designed to Store PhoneNumber01,PhoneNumber02 and PhoneNumber03 Contains ________