CSA · Question #53
Which of the following statements describes how data is organized in a table?
The correct answer is A. A column is a field in the database and a record is one user. In ServiceNow, a column represents a field in the database, and a record, particularly in the sys_user table, can represent one user.
Question
Which of the following statements describes how data is organized in a table?
Options
- AA column is a field in the database and a record is one user
- BA column is one field and a record is one row
- CA column is one field and a record is one column
- DA column contains data from one user and a record is one set of fields
How the community answered
(26 responses)- A88% (23)
- B8% (2)
- C4% (1)
Why each option
In ServiceNow, a column represents a field in the database, and a record, particularly in the `sys_user` table, can represent one user.
A column in a ServiceNow table corresponds to a field in the database, defining the type of data stored. In the context of tables like `sys_user`, each record (row) represents a single user within the platform.
While a column is one field and a record is one row is a standard database definition, option A provides a more specific ServiceNow-related context for what a record can represent.
A record is not one column; a record is a row composed of data across multiple columns.
A column does not exclusively contain data from one user; it defines a data type for all records. While a record is a set of fields, the first part of this statement is incorrect.
Concept tested: Database table structure (columns, records)
Source: https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/table-administration/concept/c_TablesAndColumns.html
Topics
Community Discussion
No community discussion yet for this question.