Computer Science > QUESTIONS & ANSWERS > ServiceNow Certified System Administrator Fundamentals New York Module 3: Database Administration La (All)

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

Document Content and Description Below

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 [Show More]

Last updated: 2 years ago

Preview 1 out of 19 pages

Buy Now

Instant download

We Accept:

We Accept
document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Buy Now

Instant download

We Accept:

We Accept

Reviews( 0 )

$10.00

Buy Now

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search

124
0

Document information


Connected school, study & course


About the document


Uploaded On

Aug 12, 2022

Number of pages

19

Written in

Seller


seller-icon
Nutmegs

Member since 4 years

622 Documents Sold

Reviews Received
77
14
8
2
21
Additional information

This document has been written for:

Uploaded

Aug 12, 2022

Downloads

 0

Views

 124

Document Keyword Tags


$10.00
What is Scholarfriends

In Scholarfriends, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Scholarfriends · High quality services·