Module 7: Manage Data Flashcards
The ServiceNow Infrastructure includes what 3 things?
- Tables (contain records)
- Records (correspond to rows in table)
- Fields (individual piece of data in record and corresponds to column in table)
The System Dictionary contains the definition for each and every table and field in a database.
Where do you navigate to, to find it?
All > System Definition > Dictionary
What references and uniquely identifies a record? (32 characters)
sys_id
Each field has 3 key attributes. What are they?
- Field label
- Field Name
- Field Data (Value)
What are the 4 ways that Tables can be related to each other?
- One-to-Many (a field can hold a reference to a record on another table)
- Many-to-Many (related in a bi-directional relationship)
- Database Views (tables can be joined using Database Views plugin)
- Extensions (extends another table)
There are 3 One-to-Many relationship fields. What are they?
- Reference Fields
- Glide List
- Document ID Fields
What are the 3 classes of Tables?
- Parent Class
- Child Class
- Base
What does the Child Class inherit?
It inherits all fields of its parent, plus anything specific to the child class table.
The INCIDENT table extends the TASK table
What are the Child Class Tables extended from the Task Table?
Incident
Problem
Change Request
A Parent Class that is not an extension of another table is called a _?
Base Table (class)
What are Core Tables?
Tables that exist in the base system (part of the initial SN installation).
Core Tables can be BASE tables and PARENT tables.
What are Custom Tables?
Tables created by admins or developers
What provides a graphical representation of other tables related to a specific table?
Schema Map.
It tells you what is a Child table, Parent table…
Which users is the Schema Map available to?
personalise_dictionary
Admin
Where are the 2 places you can go to create a table?
- Tables Module
- Tables & Columns Module
A new table created in the Global scope will have what?
u_
A custom table created in custom app will have what?
x_
3 levels of security before an end user can perform CRUD on a table?
- Access to platform/ login
- Which applications & modules does the user have access to
- Database access
3 security modules typically used by System Administrator?
- All > System Properties > Security
- All > System Security > Access Control (ACL)
- All > System Security > High Security Settings
What is an Access Control?
A security rule defined to restrict the permissions of a user from viewing & interacting with data
What are the ACL Rules?
CRWD (CRUD)
C - Create
R - Read
W - Write
D - Delete
What does the Access Control List contain?
An instance’s Access Control rules