CSA Database Schema and Tables 2

Question 1

In ServiceNow, what does the 'sys_id' field represent in every table?

Accepted Answer

A globally unique 32-character hexadecimal identifier

Answer

The sys_id is a 32-character GUID (globally unique identifier) automatically assigned to every record in every ServiceNow table.

Question 2

Which ServiceNow table stores all table definitions and metadata about tables themselves?

Accepted Answer

sys_db_object

Answer

The sys_db_object table stores metadata about all tables defined in the ServiceNow instance, including table name, label, and parent.

Question 3

What is the purpose of the 'sys_dictionary' table in ServiceNow?

Accepted Answer

It defines field-level metadata such as type, max length, and attributes for each column

Answer

The sys_dictionary table contains one row per field per table, storing the field's data type, length, default value, and other attributes.

Question 4

When you extend a table in ServiceNow, records in the child table are stored:

Accepted Answer

In both the parent and child tables, with sys_id linking them

Answer

ServiceNow uses table inheritance where a child record has a row in the parent table (for inherited fields) and a row in the child table (for extended fields), joined by sys_id.

Question 5

Which field type should you choose in ServiceNow when you need to store a reference to another record in a different table?

Accepted Answer

Reference

Answer

The Reference field type stores the sys_id of a record in a specified target table and displays the record's display value.

(CSA) ServiceNow System Administrator Certification Practice Test

(CSA) ServiceNow System Administrator Certification Practice Test

CSA Database Schema and Tables 2