CSA Database Schema and Tables 3 — Questions and Answers
Question 1: Which of the following is TRUE about the 'Task' table (task) in ServiceNow?
- It is a standalone table with no child tables
- It is a base table that Incident, Problem, and Change all extend (Correct answer)
- It stores only completed tasks and is archived
- It is a virtual table with no physical database storage
Correct answer: It is a base table that Incident, Problem, and Change all extend
The Task table is the foundational base class in ServiceNow; Incident, Problem, Change Request, and many other tables extend it, inheriting its common fields.
Question 2: What happens to data in a ServiceNow table field when you change the field's maximum length to a shorter value via the dictionary?
- Existing data is automatically truncated immediately
- The change is rejected if any existing value exceeds the new length
- Existing data is unaffected; the constraint applies only to new records (Correct answer)
- A data migration script runs automatically
Correct answer: Existing data is unaffected; the constraint applies only to new records
Reducing a field's max length in the dictionary does not alter or truncate existing data — it only enforces the new constraint on records saved after the change.
Question 3: In ServiceNow, which access control mechanism governs whether a user can read or write a specific field on a table?
- ACL rules (Access Control List)
- Data Policies
- UI Policies
- Both A and B (Correct answer)
Correct answer: Both A and B
ACL rules enforce server-side read/write permissions on fields, while Data Policies can additionally make fields mandatory or read-only based on conditions.
Question 4: What is the maximum number of characters a 'String' field in ServiceNow can store by default (without using a 'Large' field)?
- 255 (Correct answer)
- 1000
- 4000
- 65535
Correct answer: 255
Standard String fields in ServiceNow default to a maximum of 255 characters; for longer text you must use Large Text or change the max length.
Question 5: A ServiceNow administrator wants to add a custom column to the 'Incident' table. Which method is recommended?
- Directly modifying the underlying database using SQL
- Adding the field through the Table's dictionary in Studio or the Dictionary module (Correct answer)
- Editing the sys_db_object record manually
- Cloning the table and adding the field to the clone
Correct answer: Adding the field through the Table's dictionary in Studio or the Dictionary module
Custom fields should always be added through ServiceNow's Dictionary editor or Studio, ensuring proper metadata, upgrade safety, and scope tracking.
Question 6: Which table in ServiceNow stores audit trail information (who changed what and when) for fields enabled for auditing?
- sys_log
- sys_audit (Correct answer)
- sys_history_set
- sys_update_log
Correct answer: sys_audit
The sys_audit table records every field-level change for audited fields, capturing the old value, new value, timestamp, and user who made the change.
Question 7: In ServiceNow table design, what is a 'dot-walk' used for?
- Navigating the application menu hierarchy
- Traversing reference field relationships to access fields on related records (Correct answer)
- Walking through workflow stages
- Iterating over list view rows
Correct answer: Traversing reference field relationships to access fields on related records
Dot-walking (e.g., incident.caller_id.department.name) lets you traverse reference links to access fields on related records in scripts, conditions, and reports.
CSA Database Schema and Tables 3
Which of the following is TRUE about the 'Task' table (task) in ServiceNow?