Practice Test Geeks(CSA) ServiceNow System Administrator Certification Practice Test
← All CSA Flashcard Decks

Database Schema and Tables Flashcards

7 cards from real CSA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Database Schema and Tables flashcards as text

  1. Which of the following is TRUE about the 'Task' table (task) in ServiceNow?

    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.

  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?

    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.

  3. In ServiceNow, which access control mechanism governs whether a user can read or write a specific field on a table?

    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.

  4. What is the maximum number of characters a 'String' field in ServiceNow can store by default (without using a 'Large' field)?

    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.

  5. A ServiceNow administrator wants to add a custom column to the 'Incident' table. Which method is recommended?

    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.

  6. Which table in ServiceNow stores audit trail information (who changed what and when) for fields enabled for auditing?

    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.

  7. In ServiceNow table design, what is a 'dot-walk' used for?

    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.