Salesforce Data Model & Database Design Flashcards
Q. What is the Salesforce data model?
A. The Salesforce data model consists of objects, fields, and relationships that define how data is structured and stored in the Salesforce database.
Q. What are the main types of objects in Salesforce?
A. Standard Objects, Custom Objects, External Objects, Big Objects, and Junction Objects.
Q. What are records in Salesforce?
A. Records are instances of objects that store specific data entries, similar to rows in a database table.
Q. What are standard objects?
A. Predefined objects provided by Salesforce, such as Accounts, Contacts, Leads, and Opportunities.
Q. What are custom objects?
A. User-defined objects that extend Salesforce functionality and store organization-specific data.
Q. What are external objects?
A. Objects that represent data stored outside Salesforce, accessed using Salesforce Connect.
Q. What are Big Objects?
A. Special objects designed to store large amounts of data efficiently in Salesforce.
Q. What are the different types of fields in Salesforce?
A. Standard Fields, Custom Fields, Formula Fields, Roll-Up Summary Fields, Lookup Fields, Master-Detail Fields, and External Lookup Fields.
Q. What is the difference between a standard field and a custom field?
A. Standard fields come prebuilt with Salesforce objects, while custom fields are user-defined.
Q. What are the different types of relationships in Salesforce?
A. Lookup Relationship, Master-Detail Relationship, Many-to-Many Relationship (via Junction Objects), and Hierarchical Relationship.
Q. What is a lookup relationship?
A. A loose association between two objects where one object can reference another without dependency.
Q. What is a master-detail relationship?
A. A strong relationship where the child record is dependent on the parent record and inherits security and ownership settings.
Q. What is a junction object?
A. A custom object that enables many-to-many relationships between two other objects.
Q. What is the difference between lookup and master-detail relationships?
A. Lookup relationships are optional, while master-detail relationships enforce parent-child dependency.
Q. What happens when a parent record in a master-detail relationship is deleted?
A. All related child records are also deleted (cascade delete).