In terms of database structures, what does extending a table involve?

• A. Creating a new table that replicates existing data
• B. Linking two tables without sharing fields
• C. Adding new fields while inheriting existing ones
• D. Removing all records from a table before creating a new one

Answer: (C)

Extending a table in a database context typically involves creating a new table that takes on the characteristics and fields of an existing table while allowing for additional fields to be added. This practice is crucial in databases like ServiceNow, where extensibility supports best practices in data organization and management. When a table is extended, the new table, often referred to as a child or derived table, inherits all the properties (fields, methods, etc.) of the parent table, enabling users to build upon the existing structure. This approach promotes reuse of data models, consistency, and helps maintain relationships within the dataset.

In extending a table, the ability to add new fields offers flexibility in adapting to changing requirements or capturing additional data points without losing the foundational attributes provided by the base table. This is particularly valuable in a platform like ServiceNow, where various modules rely on a shared data schema.