Module 3 - Database Administration Flashcards
What are the three ServiceNow data infrastructures?
Tables, Records, Fields
How can you access the System Dictionary?
System definition > Dictionary
What does the System Dictionary do?
Contains the definition of every table and field
Where are Numbers maintained?
System Definition > Number Maintenance
Sys_id are how long?
32 characters
How do you add columns to a table?
System Definition > Tables and columns
What are the three attributes of a field?
Field Label, Field Name, Value
Name the 4 ways tables can be related
One-to-Many, Many-to-many, Database View, and Extensions
Where do you set up a Database View?
System Definition > Database Views
What’s a base Table?
An extended table that is itself not extended IE Task
How do you set up alternate Labels for a Table?
System definition > Language File
What’s are tables called that are OOB?
Core Table
What’s a table that was created by an admin or developer?
Custom Table
What’s a schema map
A graphical representation of table relations
What two modules allow you to create tables?
Tables & Tables and Columns
What 2 things created by default when a new table is created?
Application Menu with the same name as the table
Module with the plural table names
How do you edit the title of an application menu?
Click the pencil (edit) icon or Update the Title field on the form
What is CRUD
Create, Read, Update, Delete
Name three Security layers to access data?
User Logon
Application/Module access
Database Access
What three modules are used to administer security?
System Properties>Security
System Security>Access Control (ACL)
System Security>High Security Settings
Besides CRUD there are 5 additional security operations
Execute
edit_ci_relations
save_as_template
Report_on
personalize_choices
What role allows ACL access?
security_admin
Each access control rule specified three things:
the Object (table)
permissions required (role, conditions, scripts)
Operation (CRUD)
How do you access the Access Controls easily?
table_name.CONFIG
