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
Which of the following best describes a 'View' in the context of ServiceNow database schema?
Answer: A virtual table created by joining two or more physical tables for reporting
A database View in ServiceNow is a virtual table defined by a query joining multiple physical tables, used to simplify complex reporting without duplicating data.
What is the effect of marking a field as 'Unique' in the ServiceNow dictionary?
Answer: ServiceNow enforces that no two records in the table can have the same value in that field
Setting a field as Unique in the dictionary adds a uniqueness constraint, causing ServiceNow to reject saves where the value already exists in another record.
In ServiceNow, the 'cmdb_ci' table serves as the base class for which configuration management concept?
Answer: Configuration Items (CIs) in the CMDB
cmdb_ci is the base Configuration Item table in the CMDB; all specific CI types (servers, applications, networks) extend it.
An admin notices a table has the 'Extensible' checkbox unchecked in sys_db_object. What does this mean?
Answer: No child tables can be created that extend this table
When a table is not marked as Extensible, ServiceNow prevents other tables from being created that extend (inherit from) it.
What is the role of the 'sys_glide_object' table in ServiceNow?
Answer: It defines the available field data types (like String, Integer, Reference) that can be used in dictionary entries
sys_glide_object defines all available field types in the platform; each entry represents a data type administrators can select when creating dictionary fields.
Which statement about 'table rotation' (archiving) in ServiceNow is correct?
Answer: It moves older records to an archive table to keep the active table performant
Table rotation moves aging records from a primary table to a corresponding archive table (e.g., from syslog to syslog_archive), preserving data while maintaining query performance.
When creating a new application scope in ServiceNow, custom tables within that scope are automatically prefixed with:
Answer: x___
Tables created within a scoped application are prefixed with x___ to namespace them and prevent collisions with global or other scoped tables.