Modul 3: Database Administration

Question 1

What does a database contain?

Answer 1

A database contains Tables, Tables contain Records, Records contain Fields, and a Field is an individual piece of data in a record.

Question 2

What is a Table?

Answer 2

A table is a collection of records in the database

Question 3

How is records defined?

Answer 3

Records are identified by a 32-character, globally unique ID, called a sys_id.

Each record corresponds to a row in a table.

Question 4

How is fields defined?

Answer 4

Each field corresponds to a column in a table and represents individual pieces of data in a record.

Question 5

Mention the three key Field Attributes

Answer 5

• A label
  The label is a user-friendly term which allows people to identify the field in the user interface.
• A name
  The name is a unique term that the system uses to identify the field in scripts and automated business processes.
• A value
  The values are actual data.

Question 6

What are reference fields and how are they identified?

Answer 6

Reference fields are identified with the reference lookup icon.
The reference lookup icon opens a dialog box for locating a record to reference, presented as a list of the referenced (target) table.

Question 7

In which ways can tables be related to each other?

Answer 7

• One-to-Many: Within a table, a field can hold a reference to a record on another table. There are three one-to-many relationship field types:
  1. Reference Fields
  2. Glide List
  3. Document ID Fields
• Many-to-Many: Two or more tables can be related in a bi-directional relationship, so that the related records are visible from both tables in a related list.
• Database Views: Two tables can be joined virtually using the Database Views Plugin to allow for reporting on data that might be stored in more than one table. Database Views are read-only.
• Extensions: A table can extend another table. The extended table includes unique fields plus all of the fields and their properties from the parent table.

Question 8

What is a table that extends another table?

Answer 8

A Child Class. And the table it extends is the Parent Class.

Question 9

Mention two parent tables that are extended to child classes

Answer 9

Task table
Configuration table
are examples of parent tables

Question 10

If a table is extended but itself is not extending another table, it is called a:

Answer 10

Base table

Question 11

Tables that exist in the base system are called:

Answer 11

Core tables

Question 12

Tables that are created and do not exist in the base system are:

Answer 12

Custom tables

Question 13

Hvad kendetegner at tabellen er Custom?

Answer 13

u_

Question 14

What is a Schema Map?

Answer 14

The Schema Map provides a graphical representation of other tables related to a specifik table. This tool is available to Admin users.

Question 15

What is an Access Control?

Answer 15

An Access Control is a security rule defined to specify which user are granted access. It is executed when attempting to access any ServiceNow table and may be set at the: Row-level and/or Column-level. Most security settings are implemented using Access Controls.

Question 16

What is CRUD?

Answer 16

Create
Read
Update
Delete

Question 17

What is the Access Control List (ACL)

Answer 17

The Access Control List (ACL) contains all of an instance’s Access Control rules. Users with the appropriate permissions can modify rules and their definitions. In order for a user to create or update Access Control roles, they must have the Security_admin.

Question 18

Nævn de 3 Access Control Definition: Rule Types

Answer 18

table. field (Mest specifikke) (Nøglen til VIP rummet)
table. * (Næst mest specifik) (Nøglen til de specifikke rum)
table. none (Tjekkes til sidst) (Nøglen til hoveddøren)

Det kommer først an på handling og derefter regel.

Question 19

Access Control Rules can be defined by the following three permissions:

Answer 19

1. Roles: If you put one or more roles there, then only users with at least one of those roles are allowed to perform the requested operation.
2. Conditional Expression: You will see a condition widget where you can add conditional expressions to your AC rule.
3. Scripts: If the advanced checkbox is selected, you then have an opportunity to apply security based on user defined script.

Question 20

The selection of the wildcart (*) symbol from the Namedrop-down list on the Access Control form means:

Answer 20

..that the rule in question applies to all fields on the selected table except for those with explicit rule.

Question 21

What is an Import Set?

Answer 21

An Import Set is a tool used to import data from various data sources, and map that data into ServiceNow tables. (it stores data in import set tables).

Data sources can be: JDBC, HTTP, EXCEL, CSV, XML etc.
Users with Admin or import_admin can manage all aspects of import sets.

Question 22

What is the Import Set Table?

Answer 22

The Import Set Table is a staging area for records imported from a data source. Fields on these tables are generated automatically based on imported data.

Question 23

What is a Transform Map?

Answer 23

A Transform Map is a set of field maps that define the relationships between fields in an Import Set Table and fields on a Target Table.

Question 24

What does Coalesce Fields means?

Answer 24

Coalescing a field (or multiple fields) means the field will be used as a unique key during imports.

• If a match is found using the coalesce field(s), the existing record will be updated with the information being imported.
• If a match is not found using the coalesce field(s), then a new record will be inserted into the database.

Question 25

There are four possible configurations you can use to coalesce data in Import Sets:

Answer 25

• No coalesce
• Single-field coalesce
• Multiple-field coalesce
• Conditional coalesce

Question 26

What is the CMDB?

Answer 26

CMDB står for: Configuration Management Database. It is a series of tables and fields that contain all of the Configuration Items (CI’s) controlled by your company, as well as their attributes and relationships.

Question 27

What is CI’s?

Answer 27

Configuration Items can be tangible or intangible devices or applications in the CMDB such as firewalls, computers, email services, and business services.

Question 28

What is The CI relationship editor?

Answer 28

The CI relationship editor uses a concept of suggested relationships to help users see reasonable relationships between configuration items.

Question 29

What is Dependency View? (Emne: Configuration Items).

Answer 29

Dependency Views graphically display an infrastructure view for a configuration item and the business services that it is part of and that it supports.
Dependency Views indicate the status of configuration items, and allow access to the CI’s related alerts, incidents, problems, changes, and business services.

Question 30

Which one of the following is a definition for transformation maps in ServiceNow?
A: A map that is used to store the history of the incident records.
B: A map used to add data to encrypyted fields.
C: A map used to trigger Business Rules before the data is queued in the outbound Web Service.
D: A map to determine relationships between fields displaying in an Import Set to fields in an existing table..

Answer 30

D: A map to determine relationships between fields displaying in an Import Set to fields in an existing table..