ServiceNow Certified System Administrator Fundamentals New York Module 3: Database Administration Latest Updated 2022

What does the ServiceNow infrastructure consist of? tables, records, and fields. Which 3 modules can access tables in the System Definition application? Dictionary, Tables & Columns, and Tables What is a dictionary (System Definition)? defines every table and field in the system. Table records are identified as a Collection type. What are Tables & Columns (System Definition)? lists existing tables in the database. Selecting a table name will display its contents. What are Tables (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 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. What are values (Field)? are the actual data, such as users' names, or location. In some cases, the value may be empty, or null. 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, and 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.