Modul 3: Database Administration Flashcards

1
Q

What does a database contain?

A

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

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

What is a Table?

A

A table is a collection of records in the database

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

How is records defined?

A

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

Each record corresponds to a row in a table.

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

How is fields defined?

A

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

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

Mention the three key Field Attributes

A
  • 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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are reference fields and how are they identified?

A

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.

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

In which ways can tables be related to each other?

A
  • 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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a table that extends another table?

A

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

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

Mention two parent tables that are extended to child classes

A

Task table
Configuration table
are examples of parent tables

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

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

A

Base table

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

Tables that exist in the base system are called:

A

Core tables

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

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

A

Custom tables

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

Hvad kendetegner at tabellen er Custom?

A

u_

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

What is a Schema Map?

A

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

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

What is an Access Control?

A

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.

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

What is CRUD?

A

Create
Read
Update
Delete

17
Q

What is the Access Control List (ACL)

A

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.

18
Q

Nævn de 3 Access Control Definition: Rule Types

A

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.

19
Q

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

A
  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.
20
Q

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

A

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

21
Q

What is an Import Set?

A

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.

22
Q

What is the Import Set Table?

A

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.

23
Q

What is a Transform Map?

A

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.

24
Q

What does Coalesce Fields means?

A

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.
25
Q

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

A
  • No coalesce
  • Single-field coalesce
  • Multiple-field coalesce
  • Conditional coalesce
26
Q

What is the CMDB?

A

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.

27
Q

What is CI’s?

A

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

28
Q

What is The CI relationship editor?

A

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

29
Q

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

A

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.

30
Q

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..

A

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