Table Administration Flashcards

1
Q

graphical representation of the relationship between tables

A

Schema map

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

contain additional information that defines database elements

A

Data dictionary tables

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

what is sys_id

A

32 character globally unique id

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

3 key field attributes

A

label, name, data

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

which field attribute is system-friendly and which is user-friendly

A

name, label

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

what element type allows you to add a field that can refer to records on any table

A

Document ID

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

One to many relationship that allows a user to select multiple records on a table

A

glide list

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

defines table joins for reporting purposes

A

Database views

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

Incident, Problem, Change Request tables are all children of what table

A

task

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

parent class that is not an extension of another table, e.g. task

A

base table

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

what is a core table

A

a table that comes with service now

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

true or false: all tables are extensible

A

false

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

prefix for tables created in a scoped application

A

x_

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

custom table prefix

A

u_

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

which tables can be extended ad infinitum at no charge

A

CMDB tables

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

how to view the schema map for a table

A

All>System Definition>Tables, open record, Related Links>Show Schema Map

17
Q

in schema map, blue bars means

A

extending

18
Q

in schema map, red bar means

A

referenced