3 Database Administration Flashcards Preview

ServiceNow Fundamentals - CSA > 3 Database Administration > Flashcards

Flashcards in 3 Database Administration Deck (51)
Loading flashcards...
1

Name the three different components of the ServiceNow Database and their definition:

Tables
- structure/component which contains records

Records (row)
- data stored on tables which contains fields

Fields (corresponds to a column on a table)
- individual pieces of data within a record

2

Where can you find information about every table and field in ServiceNow?

System Definition > Dictionary

3

Every field has three key attributes, name these:

Field Label
- user-friendly term, e.g. User ID

Field Name
- system name, e.g. user_id

Value
- actual data

4

How can you access tables in ServiceNow?

Dictionary

Tables and columns

Tables

5

What is a reference field?

It stores a unique system identifier (sys_id) of a record on another table which is what establishes the reference relationship

(nyckel)

6

In what ways can tables be related to each other? (4)

One-to-Many

Many-to-Many

Database views
- plugin

Extensions
- child class contains all fields from parent class (table)

7

Name the three one-to-many relationship fields:

Reference Fields
- select a record on a table defined by the reference field

Glide List
- select multiple records on a table defined by the reference field

Document ID Fields
- select a record of any table in the instance

8

What is a base table?

A table that is extended but is not extending other tables

- e.g. Task table

9

What is a child table?

A table that extends another table

- every child table is a specialization of its base table or previous child table

10

What is a parent table?

A table that is extended by other tables
- possible because it has "Extensible" set as true

11

What does the schema Map provide?

What colors are used in the schema map and what does these colors represent?

It provides graphical representation of other tables related to a specific table

- yellow is table in focus
- tables with blue bars extends table in focus
- tables with red bars are tables referenced by table in focus

12

What is a custom table?

A table created (not a core table)

Name i prefixed with:
- u_ if created in global application
- namespace identifier if created in scoped application

13

How is a custom table named? (1 + 2)

Based on table label and a prefix:
- u_ if created in global application
- namespace identifier if created in scoped application

14

Which modules can you use to create a new table?

Tables

Tables & Columns

15

What is created by default when you create a new table? (2)

Application Menu with the same name as the table Label (e.g. Infinity)

Module with the plural of the table Lable (e.g. Infinities)

16

What does CRUD stand for?

Create
Read
Update
Delete

17

What three security levels does ServiceNow provide before an end user has the capability to perform CRUD on a table?

User Authentication/Login
- users, groups, roles

User Interface
- application and modules

Database
- tables, governed by global system properties, governed by access control rules

18

What is an access control?

At what level can it be set?

A security rule defined to restrict the permissions of a user from viewing and interacting with data (tables)

Row or column level

19

Name the three security modules on the Application Navigator often used by the System Admin

System Properties > Security
System Security > Access Control (ACL)
System Security > High Security Settings

20

What is the ACL?

Access Control List
- contains a list of the instance's access control rules

21

What is specified in an access control list rule? (3)

1. The object and operation being secured
2. The permissions required to access the object
- roles, conditional expressions, scripts
3. Operation - a valid action the system can take (CRUD)

22

What happens, with access control in mind, when a table is created?

Four access control rules are created by default, one for each CRUD

A new role is created and associated with these access control rules

23

In what order are AC rules processed?

1. Match the object against table ACL rules (most specific to most general)

2. Match the object against field ACL rules (most specific to most general)

- a user must pass both table and field ACL rules to access a record object

24

Which elevated role is required to modify access control rules?

security_admin

25

What type of permissions can be configured in an access control rule? (3)

Roles
Conditions
Scripts that sets the 'answer' variable to true or false

26

Which object grants access to all table records?

.None

27

What is an import set?

A tool used to import data from various data sources and then map that data into ServiceNow tables

28

What roles are needed to manage all aspects of import sets? (2)

admin

import_admin

29

What are the steps for importing data using an import set? (4)

Load the data

Create a transform map

Transform the data

Clean the import table

30

What is the Import set table?

A staging area for records imported from a data source