CSA - ServiceNow System Administrator Database Schema and Tables Questions and Answers 1 — Questions and Answers
Question 1: A system administrator needs to visualize the database structure for the Incident table, including which tables it extends and which tables extend it. Which ServiceNow feature provides a graphical representation of these table relationships?
- Dependency View
- Schema Map (Correct answer)
- Table Browser
- Data Dictionary
Correct answer: Schema Map
The Schema Map provides a visual representation of table relationships, showing details like which tables extend the current table and which tables are referenced by it. This is the correct tool for understanding the database structure in a graphical format.
Question 2: A developer is creating a new custom table for a specific application. This table will inherit all of the fields and functionality from the Task [task] table, such as 'State', 'Priority', and 'Assignment Group'. In this scenario, the new custom table is considered a __________ table.
- Base
- Parent
- Core
- Child (Correct answer)
Correct answer: Child
When a table extends another table, it is called a child table. The child table inherits all the fields, scripts, and business rules of the parent table. The Task [task] table is a common parent table in ServiceNow.
Question 3: Which of the following BEST describes a 'base table' in the ServiceNow schema?
- A table that is included in the core ServiceNow platform but extends another table.
- Any custom table created by an administrator that begins with the 'u_' prefix.
- A table that is extended by other tables but does not extend any other table itself. (Correct answer)
- A table used solely for importing data, such as an Import Set table.
Correct answer: A table that is extended by other tables but does not extend any other table itself.
A base table is a foundational table in the hierarchy. It can be extended by other tables (becoming a parent), but it does not extend another table (it has no parent). The Task [task] and CMDB [cmdb] tables are common examples of base tables.
Question 4: An administrator wants to change the default value of the 'State' field for Incident records to 'In Progress' without affecting the default value for Problem or Change records, which also use the 'State' field from the parent Task table. What is the appropriate mechanism to achieve this?
- UI Policy
- Data Policy
- Dictionary Override (Correct answer)
- Business Rule
Correct answer: Dictionary Override
A Dictionary Override is used to change the properties of a field on a child table without affecting the parent table. Since Incident, Problem, and Change are all child tables of Task, a dictionary override allows the administrator to modify the 'State' field's behavior specifically for the Incident table.
Question 5: The 'caller_id' field on the Incident form allows a user to select a record from the User [sys_user] table. This establishes a one-to-many relationship between the User and Incident tables. What type of field is 'caller_id'?
- Choice
- String
- Reference (Correct answer)
- Glide List
Correct answer: Reference
A Reference field stores the unique sys_id of a record on another table, creating a relationship between the two tables. The 'caller_id' field on the Incident table references the User [sys_user] table, allowing users to look up and select a specific user record.
Question 6: Which table in ServiceNow acts as a central repository for the definition of every table and field in the system?
- System Schema [sys_schema]
- Table Definitions [sys_table_def]
- System Dictionary [sys_dictionary] (Correct answer)
- Configuration [sys_config]
Correct answer: System Dictionary [sys_dictionary]
The System Dictionary [sys_dictionary] contains the definition for every table and field in the database. It stores metadata such as data type, character limit, default values, and other attributes for each column on each table.
CSA - ServiceNow System Administrator Database Schema and Tables Questions and Answers 1
A system administrator needs to visualize the database structure for the Incident table, including which tables it extends and which tables extend it.
Which ServiceNow feature provides a graphical representation of these table relationships?