ServiceNow Certified System Administrator Fundamentals New York Module 3: Database Administration Latest Update Questions and Answers

What is the SNOW Infrastructure? Built on RELATIONAL DB containing data which can be accessed through Now Platform UI What does the ServiceNow infrastructure consist of? *Tables: data structure/database component; contain records *Records: rows in table. Is data stored in table; contain fields *Fields: Individual piece of data in record; correspond to column in table Lists & Forms provide friendly UI for managing tables, records, and fields. System Dictionary Contains definition for each and every table and field in DB System Definition > Dictionary to modify table and field attributes Which 3 modules can access tables in the System Definition application? *Dictionary *Tables & Columns *Tables Dictionary Module (System Definition)? defines every table and field in the system. Table records are identified as a Collection type. Tables & Columns Module (System Definition)? lists existing tables in the database. Selecting a table name will display its contents. *Can also view field settings & attributes for a table Tables Module (System Definition)? contains a record for each table in the database. Custom tables can be created when the New button is selected. What is a table? a collection of records in the database Records Identified 32- Character GLOBALLY unique ID: sys_id *Record numbers are automatically incremented. *Number format & number prefix per table in the system can be changed by visiting: System Definition > Number Maintenance App Field types? *Choice *Date/Time *Journal *Reference *Field types define how a field is interacted with through the interface and the type and format of data it can store What are the 3 KEY attributes of a field? Label, Name, and Value What are some examples of a LABEL (Field)? includes User ID, Full Name, and Location What is a NAME (Field)? a unique term that does not always match a field's label. Ex. Name of location field/label = sys_ion and Name field/label = sys_ *System uses to identify field in SCRIPTS & automated business processes What are VALUES (Field)? are the actual data, such as users' names, or location. In some cases, the value may be empty, or null. Reference Fields Stores a unique system identifier; sys_id of a record on another table which establishes reference relationship *Ex. Call field on incident table is a reference to record on User table Defining reference field creates relationship between two tables. Adding a reference field to a form makes the other fields in the referenced table available to the form NOTE: REFERENCE Fields Can only refer to records from one other table. *To add field that can refer to records on any table, regardless of shared reference, use Document ID element type. *Wildcard searchers can be used in reference fields What are reference fields identified by? reference lookup icon What does the reference lookup icon do? opens a dialog box for locating a record to reference, presented as a list of the referenced (target) table What does the reference icon do? preview the referenced record (on the target table) What are the 4 types of table relationships? *One-to-Many *Many-to-Many *Database views *Extensions What is a "One-to-Many" relationship field (Table Relationships)? Within a table, a field can hold a reference to a record on another table. What are the 3 "one-to-many" relationship fields (Table Relationships)? *Reference fields *Gilde List *Document ID Fields What are reference fields (One-to-Many)? Allows a user to select a record on a table defined by the reference field. Example: Caller field on the Incident table allows a user to select any record on User table. What is a gilde list (One-to-Many)? Allows a user to select multiple records on a table defined by the glide list. Example: The Watchlist field on the Incident table allows the user to select any record or records on the User table. What are document ID fields (One-to-Many)? Allows a user to select a record on any table in the instance. Example: Document field on the Translated Text table. What are "Many-to-Many" relationship fields (Table Relationships)? Two or more tables that can be related in a bi-directional relationship, so that the related records are visible from both tables in a related list. Example: software vendors can sell multiple products and products can be sold by multiple vendors. What are "database views" in relationship fields (Table Relationships)? Two tables that 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. Create Database Views by navigating to System Definition > Database Views. What are "extensions" in relationship fields (Table Relationships)? A table that can extend another table. The extended table includes unique fields plus all of the fields and their properties from the parent table