Salesforce DEV401 - Data Model Flashcards
What is the difference between the Salesforce.com 15 and 18 digit IDs?
A. 15 digit ID is case sensitive, whereas 18 digit ID is case insensitive
B. 18 digit ID is case sensitive, whereas 15 digit ID is case insensitive
C. Both are the same
D. 15 digit IDs are no longer used, Salesforce now only uses 18 digit IDs
A. 15 digit ID is case sensitive, whereas 18 digit ID is case insensitive
Which of the following is not allowed?
A. Master (Custom object) and Detail (Standard object)
B. Master (Standard object) and Detail (Custom object)
C. Master (Custom object) and Detail (Custom object)
D. None of the Above
A. Master (Custom object) and Detail (Standard object)
How many different Master – Detail relationships can exist on the detail object side? A. 1 B. 2 C. 3 D. 4
B. 2
How can you create a Many to Many relationship in salesforce.com?
A. Create a direct Many to Many relationship
B. Use a junction Object
C. Use a piece of code to relate both objects
D. Not Possible to create Many to Many relationship in salesforce.com
B. Use a junction Object
How many external IDs are allowed on an object? A. 1 B. 2 C. 3 D. 4
C. 3
Rollup Summary fields work in which kind of relationship? A. Many-to-many Relationship B. One-to-one Relationship C. Master-detail Relationship D. Lookup Relationship
C. Master-detail Relationship
What happens to the Secondary Relationship when the Primary Relationship is deleted in the Junction Object?
A. Secondary Relationship becomes Primary Automatically
B. Secondary Relationship is made Primary manually
C. Nothing Happens
D. You can’t delete the primary relationship
A. Secondary Relationship becomes Primary Automatically
From Salesforce Online Help: The second master-detail relationship you create on your junction object becomes the secondary relationship. If you delete the primary master-detail relationship or convert it to a lookup relationship, the secondary master object becomes primary.
Which of the following cannot be a Dependent Picklist? A. Checkbox B. Multi-select Picklist C. Custom Picklist D. None of the Above
A. Checkbox
Which of the following is not allowed?
A. Master (Custom object) and Detail (Standard object)
B. Master (Custom object) and Detail (Custom object)
C. Look Up between (Standard object) and (Standard object)
D. Look Up between (Standard object) and (Custom object)
A. Master (Custom object) and Detail (Standard object)
When a Lookup Relationship is used in the parent-child model, what happens when a parent record is deleted?
A. Child records are also deleted
B. An error is returned
C. System doesn’t allow deletion of parent record unless children are first deleted
D. Child records are not deleted
D. Child records are not deleted
Which of the following is NOT true regarding Custom Summary Formula fields?
A. Summary formula can reference another summary formula
B. When fields are deleted, they are also deleted from the summary formulas that reference them
C. One can have 5 Custom Summary Formulas on a report
D. The summary types Sum, Largest Value, Smallest Value, and Average are not available for use with the Record Count Field
B. When fields are deleted, they are also deleted from the summary formulas that reference them
Can a standard field be made an External ID field?
A. Yes
B. No
B. No
The first 3 characters of a 15 Digit ID identifies the A. Record B. Object C. Field D. Application E. Organization
B. Object
IDs CANNOT be identified in which of the following ways?
A. Salesforce.com URL when the record is displayed
B. Reports
C. Formula Fields
D. Web service API (i.e. Data Loader)
C. Formula Fields
A Custom Lookup Field can be created between Account and Opportunity
A. Yes
B. No
A. Yes
Which does NOT apply to Custom Formula Fields?
A. Custom Formula Fields can reference other formula fields
B. Custom Formula Fields can reference standard fields
C. Custom Formula Fields can reference custom fields
D. Custom Formula Fields can calculate across objects
A. Custom Formula Fields can reference other formula fields
Custom Formula fields do NOT support which of the following functional expressions? A. Adding multiple records together B. If/then/else conditional statements C. Clickable image buttons D. Combine text strings together
A. Adding multiple records together
Which of the following is NOT a step in creating a junction object?
A. Creating the custom object to serve as the junction object between the two master objects
B. Creating two master-detail relationships
C. Customizing the related lists on the page layouts of the two master objects
D. Creating two lookup relationships
D. Creating two lookup relationships
Which type of field cannot be universally required? A. Lookup B. Text C. Email D. Number
A. Lookup
A developer wants to ensure that when a parent record is deleted, child records are not deleted. Which relationship should the developer choose? A. Lookup B. Master-detail C. Many-to-many D. Self E. None of the above
A. Lookup
Default values are available for standard text fields.
A. True
B. False
B. False
What is the maximum number of master-detail relationships that can be created on a custom object? A. 1 B. 2 C. 3 D. 4 E. Unlimited
B. 2
What is the significance of the first (primary) master-detail relationship in a junction object?
A. Look and feel. The junction object’s detail and edit pages use the color and any associated icon of the primary master object.
B. You cannot delete the primary relationship.
C. You cannot rename the primary relationship.
D. There is no significance
A. Look and feel. The junction object’s detail and edit pages use the color and any associated icon of the primary master object.
From Salesforce Online Help: The second master-detail relationship you create on your junction object becomes the secondary relationship. If you delete the primary master-detail relationship or convert it to a lookup relationship, the secondary master object becomes primary.
Which of the following is NOT a step in creating a junction object?
A. Creating the custom object to serve as the junction object between the two master objects
B. Creating two master-detail relationships
C. Customizing the related lists on the page layouts of the two master objects
D. Creating two lookup relationships
D. Creating two lookup relationships
In a custom object to track bugs, the organization wants the ability to relate bugs to parent bugs in a parent-child relationship. What type of relationship should be used? A. Master-detail B. Self C. Hierarchical D. Many-to-many
B. Self
A developer wants to ensure that, when a parent record is deleted, child records are NOT deleted. Which relationship should the developer use? A. Lookup B. Master-detail C. Many-to-many D. Master-to-master E. None
A. Lookup
Field history tracking allows users to choose up to \_\_\_\_ fields per object A. 5 B. 10 C. 20 D. 40
C. 20
Which of the following is NOT a step in creating a junction object?
A. Creating the custom object to serve as the junction object between the two master objects
B. Creating two master-detail relationships
C. Customizing the related lists on the page layouts of the two master objects
D. Creating two lookup relationships
D. Creating two lookup relationships
Required and Unique field options works on Custom Fields only
A. True
B. False
B. False
What can be used in a master-detail relationship to display the fields of the parent object in the related list? A. Cross-object formula field B. Workflow rule C. Validation Rule D. Assignment rule
A. Cross-object formula field
What is true about a master-detail relationship? (2 answers)
A. When the parent record has been deleted, all the child records will be deleted.
B. You can have a child record without the parent record.
C. You have to expose the master lookup field on the child detail page layout.
D. You cannot delete a child record.
A. When the parent record has been deleted, all the child records will be deleted.
C. You have to expose the master lookup field on the child detail page layout.
What is true about a junction object?
A. A custom object that has 2 master-detail relationships
B. A custom object that has a master-detail relationship.
C. A standard object that has 2 master-detail relationships.
D. A standard object that has a master-detail relationship.
A. A custom object that has 2 master-detail relationships
A Rollup Summary field is supported by which relationship? A. Master Detail B. Workflow C. Validation Rules D. Lookup
A. Master Detail
Salesforce record ID’s are identical in
A. Production, full copy sandbox, developer
B. Production and full copy sandbox only.
C. Production , developer
D. None
B. Production and full copy sandbox only.
An organization wants to create a field to store manager data on the user object. The manager field is a reference to another user record. What type of relationship should be used? A. Master-detail B. Hierarchical C. Lookup D. Many-to-many
B. Hierarchical
In a master-child relationship between a standard object and a custom object, which of the following statements is NOT true. (2 answers)
A. Standard object is always the master
B. Custom Object is always the master
C. Custom object is always a child
D. Standard or custom object can be a master
E. Standard object is never a child
C. Custom object is always a child
D. Standard or custom object can be a master
Maximum number of master-detail relationships per object A. 0 B. 1 C. 2 D. 3 E. 4
C. 2
In a master detail relationship, the owner of the parent record controls both the parent and the child
A. True
B. False
A. True
In a custom bug-tracking object, the organization wants the ability to related bugs to parent bugs in a parent-child relationship. What type of relationship should be used? A. Master-detail B. Self C. Hierarchical D. Many-to-many
B. Self
Custom Formula fields can reference fields on related objects
A. True
B. False
A. True
If a parent object has a lookup relationship defined in a child object, what happens to the child record when you delete the parent record? A. The child record is deleted B. Nothing C. The parent record cannot be deleted D. The child record cannot be deleted
B. Nothing
In a Rollup Summary there is an option to include all records in the rollup or just those that meet certain criteria
A. True
B. False
A. True
A Junction Object is a Custom Object with three master detail relationships
A. True
B. False
C. Sometimes
B. False
Custom Objects automatically have some standard fields
A. True
B. False
C. Some of them have
A. True
Child Records in a Master-detail Relationship inherit the Organization Wide Defaults from their parents
A. True
B. False
A. True
What is true about a cross-object formula field for a master-detail relationship?
A. You can only create a cross-object formula field on the parent object.
B. You can only create a cross-object formula field on the child object.
C. You can create a cross-object formula field on both the parent and child object.
D. Cross-object formula field is not available for master-detail relationship.
B. You can only create a cross-object formula field on the child object.
\_\_ Lookup Relationships are allowed per object A. 10 B. 20 C. 25 D. 40
C. 25
What is the maximum number of master-detail relationships that can be created on a custom object? A. 1 B. 2 C. 4 D. Unlimited
B. 2
What is a junction object?
A. Object with lookup relationship
B. Object with a master-detail relationship
C. Object with two lookup relationships
D. Object with two master-detail relationships
D. Object with two master-detail relationships
Changing the data type of an existing custom field is possible, but doing so may cause loss of data
A. True
B. False
C. Maybe
A. True
What are the data types that are supported by formula fields? (3 answers) A. Text B. Percent C. Email D. Currency E. Phone
A. Text
B. Percent
D. Currency
The Force.com platform supports the following relationship types (select all that apply) A. Self B. Lookup C. Master Detail D. Many to Many E. Many to All F. One to One G. One to All H. Validation Rules
A. Self B. Lookup C. Master Detail D. Many to Many F. One to One
In a master-detail relationship, what happens when a parent record is deleted?
A. Parent record alone gets deleted
B. Exception occurs
C. Parent and Child record will not be deleted
D. All child records are deleted
D. All child records are deleted
Custom Fields are stored for how many days after deletion? A. 10 Days B. 30 Days C. 45 Days D. 100 Days
C. 45 Days
In Salesforce what is the maximum number of fields that can be added to an object?
A. There is no such limit on the number of fields
B. 100
C. 200
D. 500
D. 500
How many characters are there in the Salesforce case-insensitive id field of an object?
A. id field is not mandatory
B. The field length is customizable
C. This depends on the version of Salesforce
D. 18
D. 18
Which of these are valid data type in Force.com development platform. Select the two correct answers. A. Percent B. URL C. Choicebox D. Long E. Decimal
A. Percent
B. URL
Which of the following is correct about custom fields in Salesforce?
A. If a field is set as required it must be entered in the Salesforce generated pages, however it may not be specified when entering information via Force.com API
B. A required field is always present in an edit page
C. A unique field is always present in an edit page
D. A unique field increases report and SOQL performance
B. A required field is always present in an edit page
Fields of which of the following type are not allowed to be set as external IDs? A. Date B. Number C. eMail D. Text
A. Date
The number of master detail relationship that an object can have are A. 1 B. 2 C. 25 D. 300
B. 2
The number of Lookup relationship that an object can have are A. 1 B. 2 C. 25 D. 300
C. 25
Which of these is true about the Lookup Relationship?
A. Parent is not a required field and may be omitted.
B. Deleting an object deletes its children.
C. Roll-up summary field can be used to perform basic operations over all children of a parent record.
D. Security access of the child record is dependent upon the parent record.
A. Parent is not a required field and may be omitted.
Which of the following is true about Roll-up summary fields?
A. Roll-up summary can only be set on the parent of a Master-Detail or Lookup relationship.
B. Roll-up summary can be used to compute SUM,MIN,MAX,AVG over a set of records
C. The results of the roll-up summary is displayed on the child in a master-detail relationship.
D. Roll-up summary fields are read only.
D. Roll-up summary fields are read only.
Which of the following is not the Return Type for Formula Fields? A. Currency B. Radio Button C. Text D. Percent
B. Radio Button
Default values can be set on the Dependent Picklist Fields
A. True
B. False
A. True