Service Now CSA – Database Questions and answers. 100% Accurate. Rated A

Document Content and Description Below

Service Now CSA – Database Questions and answers. 100% Accurate. Rated A What kind of database does ServiceNow use? - ✔✔MariaDB What is a field? - ✔✔An individual piece of data in a reco... rd. What is a table? - ✔✔A collection of records in the database. Records are identified by a 32-character, locally unique ID. What is it called? - ✔✔sys_id Which Module lists the prefixes for record numbers e.g. INC for Incident - ✔✔System Definition > Number Maintenance What are the 3 key attributes of a field? - ✔✔(1) Label (2) Name (3) Value What is a field name? - ✔✔A unique term that the system uses to identify the field in scripts and automated processes. What is the name field in the user table (sys_user.name) made up of? - ✔✔The first name and last name fields. What icon is used to identify reference fields? - ✔✔The reference lookup icon (magnifying glass). How do you preview the reference record? - ✔✔Hover/click of the reference icon (circle with an "I" in it) on the form you are viewing. What data does a reference field actually store? - ✔✔The sys_id What does the system create when you define a new reference field? - ✔✔It creates a relationship between the two tables, making the other fields in the referenced tables available to the form. Can wildcard searches be used in reference fields? - ✔✔Yes Can a reference field only link to one table? - ✔✔Yes. How do you add a field that can refer to records on any table in the platform, regardless of a shared reference? - ✔✔Use the Document ID element type. In what 4 ways can tables be related to each other? - ✔✔(1) One-to-Many (2) Many-to-Many (3) Database Views (4) Extensions What are the 3 one-to-many relationship fields? - ✔✔(1) Reference Fields (2) Glide List (3) Document ID Fields What is a reference field for? - ✔✔It allows a user to select a record on a table defined by the reference field. E.g. Caller field in the Incident table allows a user to select any record on the User table. What is the Glide List for? - ✔✔It allows a user to select multiple records on a table defined by the glide list. E.g. The watchlist field on the Incident table allows the user to select multiple records from the User table. What are Document ID Fields? - ✔✔They allow a user to select a record on any table in the instance. E.g. Document field on the Translated Text table [sys_translated_text] What is a Many-to-Many table relationship? - ✔✔Where two or more tables can be related in a bidirectional relationship, so that the related records are visible from both tables in a related list. E.g. Software vendors can sell multiple products and products can be sold my multiple vendors. How do Database Views create relationships between tables? - ✔✔Two tables can be joined virtually using the Database View plugin to allow for reporting on data that might be stored in more than one table. Where do you navigate to create Database Views - ✔✔System Definition > Database Views Can you edit a Database View. - ✔✔No. It is read-only. What does it mean to Extend a table? - ✔✔A table can extend another table. The extended table includes unique fields plus all of the fields and their properties from their parent table. A table that extends another table is called what? - ✔✔Child class A table that is extended is called what? - ✔✔Parent class Are all user tables extensions of existing tables? - ✔✔No. Users can create a new table that stands alone or that extends another table. Name 2 parent classes that are extended? - ✔✔Task table and Configuration table. Which is the parent table o [Show More]

Last updated: 2 years ago

Preview 1 out of 6 pages