Asked by Shayle Lliaban on Jun 03, 2024

verifed

Verified

Which of the following is a best practice when you are creating a table containing employee names?

A) Separate the first and last names into two fields.
B) Keep the first and last names together in one field.
C) Assign the Long data type to any field containing names.
D) Create the table in Table Datasheet view.

Employee Names

Refers to the data field or collection of fields in a database or application that stores the names of employees.

Long Data Type

A data type in programming used to represent integer numbers larger than those that can be stored in an int data type.

Table Datasheet View

A display format in a database application that shows data in rows and columns, resembling a spreadsheet.

  • Comprehend the principles and architecture of tables, records, and fields within a database.
verifed

Verified Answer

HC
Hosanna CostinJun 09, 2024
Final Answer :
A
Explanation :
Separating the first and last names into two fields allows for easier sorting and searching by either name. It also enables the use of honorifics and suffixes without causing data redundancy.