Data Schema Flashcards

• Identify how data is stored and managed in tables, records, and fields • Recognize the relationship between base, parent, and child tables • Evaluate the differences between core and custom tables • Use the tools provided to navigate table types and schema maps

1
Q

Where to navigate to modify the record number format?

A

System Definition > Number Maintenance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Where to navigate to access tables?

A

System Definition > Dictionary

System Definition > Tables

System Definition > Tables & Columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is inside the Dictionary module?

A

Records for every table and field in the system

Table records are identified as a Collection type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is inside the Tables module?

A

A record for each table in the DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is inside the Tables & Columns module?

A

All the tables in the DB

Selecting a table name displays its contents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

System Definition > Dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How are records uniquely identified in the system?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is stored in fields?

A

Actual data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are examples of different field types?

A
  • Choice
  • Date / Time
  • Journal
  • Reference
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are 3 key attributes of a field?

A
  • Field name (stored in the system)
  • Field label (user-friendly name)
  • Field data (data stored in the field)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is stored in a Reference field?

A

The sys_id of a record that lives in another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How are Reference fields identified?

A

With the Reference lookup icon (magnifier)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Document ID element type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the 4 table relationships in ServiceNow?

A
  • One-to-Many
  • Many-to-Many (think software vendors and products)
  • Database Views
  • Extensions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A
  • Reference fields (Caller field on Incident table)
  • Glide List (Watchlist field on Incident table)
  • Document ID fields (Document field on the Translated Text table)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Database Views (which are read-only)

17
Q

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

A
  • sys_collection
  • sys_m2m
18
Q

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

A

The global default fields

19
Q

When can we extend a table?

A

When we create the table

20
Q

Are all tables extensible?

A

No

21
Q

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

A

System Definition > Language File

22
Q

How to make a table extensible?

A

Select the Extensible checkbox on the table record

23
Q

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

A

Dictionary overrides

24
Q

What is a core table?

A

A table that comes with the system (like Incident)

25
Q

What is a base table?

A

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

26
Q

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

A

x_

27
Q

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

A

u_

28
Q

What is the purpose of the schema map?

A

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
29
Q

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

A

Based on reference or extension classes

  • red: show referenced tables
  • orange: show referencing tables
  • green: show extended tables
  • blue: show extending tables
30
Q

Schema map is available to which roles?

A
  • admin
  • personalize_dictionary
31
Q

How to generate a schema map?

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

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

A

Create module