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

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

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_user.location and Name field/label = sys_user.name *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 What can tables extend? ✔✔other tables, creating parent a