GAINSIGHT ADMIN EXAM WITH COMPLETE VERIFIED SOLUTIONS

all objects are displayed on.... data management page an object is like a ... database table and columns Brainpower 0:13 / 0:15 object fields character limit 250 characters 3 types of objects standard objects, custom objects, system objects multi select dropdown is used when a user wants to store.... multiple values for one record object activity log allows you to see... all changes made to an object dependencies are when objects are.... referenced in a different part of the application with what types of data can you build a calculated field? string date number make sure data type of the custom field is the same as the return type of the formula function. string functions: substring lets you extract part of the original string. provide character position for where to start. string functions: length returns number of characters in string, including blank spaces & special characters string functions: to lowercase/to uppercase returns string with all characters converted to lowercase or uppercase string functions: string position returns position of first character of substring in main string string functions: left string/right string extracts substring from main string, must supply # of characters to be included starting from the left or right string functions: concat. how many arguments are allowed? adds two strings together, provide delimeter between two (comma, hypen or space) 10 arguments are allowed date functions: date diff subtracts one date from another in certain interval. can be days, months, quarters, weeks, years. negative number result if applicable. date functions: date add/sub dynamic fields? adds/subtracts # of days, weeks, months, or quarters to given date. provide: date, #, interval for number (day, quarter, month, week) accepts dynamic fields. The number of days you add to or subtract from a date dynamically changes with the value of the selected field. date functions: First Day of Week/Last Day of Week accepts date and returns date on which the week started/ended. monday considered start of week, sunday considered end of week. date functions: Last Day of Quarter accepts date and returns date on which the quarter ended (last date of quarter) date functions: Month Num returns number of month to which date belongs (april = 4) date functions: Month Name returns name of the month for a given date. can selected format. April, Apr etc date functions: Week Num returns number of week in year for