Data Schema

Question 1

Where to navigate to modify the record number format?

Answer 1

System Definition > Number Maintenance

Question 2

Where to navigate to access tables?

Answer 2

System Definition > Dictionary

System Definition > Tables

System Definition > Tables & Columns

Question 3

What is inside the Dictionary module?

Answer 3

Records for every table and field in the system

Table records are identified as a Collection type

Question 4

What is inside the Tables module?

Answer 4

A record for each table in the DB

Question 5

What is inside the Tables & Columns module?

Answer 5

All the tables in the DB

Selecting a table name displays its contents

Question 6

Where to navigate to modify a table or a field attribute?

Answer 6

System Definition > Dictionary

Question 7

How are records uniquely identified in the system?

Answer 7

Records are identified with a sys_id:
a globally unique ID of 32 characters

Question 8

What is stored in fields?

Answer 8

Actual data

Question 9

What are examples of different field types?

Answer 9

• Choice
• Date / Time
• Journal
• Reference

Question 10

What are 3 key attributes of a field?

Answer 10

• Field name (stored in the system)
• Field label (user-friendly name)
• Field data (data stored in the field)

Question 11

What is stored in a Reference field?

Answer 11

The sys_id of a record that lives in another table

Question 12

How are Reference fields identified?

Answer 12

With the Reference lookup icon (magnifier)

Question 13

What field type must we use in order to refer to records on any table?

Answer 13

Document ID element type

Question 14

What are the 4 table relationships in ServiceNow?

Answer 14

• One-to-Many
• Many-to-Many (think software vendors and products)
• Database Views
• Extensions

Question 15

What are the 3 One-to-Many relationship fields?

Answer 15

• Reference fields (Caller field on Incident table)
• Glide List (Watchlist field on Incident table)
• Document ID fields (Document field on the Translated Text table)

Question 16

Which table relationship can be used for reporting on data stored in different tables?

Answer 16

Database Views (which are read-only)

Question 17

Which tables are useful when working with many-to-many relationships?

Answer 17

• sys_collection
• sys_m2m

Question 18

What fields are automatically created when a stand alone table is created?

Answer 18

The global default fields

Question 19

When can we extend a table?

Answer 19

When we create the table

Question 20

Are all tables extensible?

Answer 20

No

Question 21

Where to navigate to add a table label for an extended table?

Answer 21

System Definition > Language File

Question 22

How to make a table extensible?

Answer 22

Select the Extensible checkbox on the table record

Question 23

Which feature do we use to define a field on a child table differently from the parent table?

Answer 23

Dictionary overrides

Question 24

What is a core table?

Answer 24

A table that comes with the system (like Incident)

Question 25

What is a base table?

Answer 25

A table that is not extending another table (like Task)

Question 26

If a table is created in a scoped application, what is the prefix in the table name?

Answer 26

**x_**

Question 27

If a table is created in the global scope, what is the prefix in the table name?

Answer 27

**u_**

Question 28

What is the purpose of the schema map?

Answer 28

Provide a graphical representation of the tables related to a specific table - Use it to see which fields are inherited from parent table and which fields originate on the child table, and to **look up field types**

Question 29

How can we filter the table relationships in the schema map?

Answer 29

Based on reference or extension classes - **red**: show **referenced tables** - **orange**: show **referencing tables** - **green**: show **extended tables** - **blue**: show **extending tables**

Question 30

Schema map is available to which roles?

Answer 30

- **admin** - **personalize_dictionary**

Question 31

How to generate a schema map?

Answer 31

1. **System Definition > Tables and Columns** 2. Select a table 3. Press **Schema Map** button

Question 32

Lab - Which button must be selected on the Table form in order to have a module created

Answer 32

**Create module**