Intermediate Database Design Principles

Test your Intermediate-level Database Fundamentals Database Design Principles skills in Database Data Management. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

To satisfy the requirements of First Normal Form (1NF), how should a designer handle a 'PhoneNumbers' field that contains multiple values for one user?

A. Create a separate table for phone numbers and link it to the user with a foreign key

B. Use a comma-separated string to store all phone numbers in a single column

C. Add multiple columns such as Phone1, Phone2, and Phone3 to the main user table

D. Store the phone numbers in a BLOB field to maintain data encapsulation and privacy

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question