Salesforce DEV401 - Data Model Flashcards

1
Q

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

A. 15 digit ID is case sensitive, whereas 18 digit ID is case insensitive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A. Master (Custom object) and Detail (Standard object)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
How many different Master – Detail relationships can exist on the detail object side?
A. 1
B. 2
C. 3
D. 4
A

B. 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

B. Use a junction Object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
How many external IDs are allowed on an object?
A. 1
B. 2
C. 3
D. 4
A

C. 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
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
A

C. Master-detail Relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
Which of the following cannot be a Dependent Picklist?
A. Checkbox
B. Multi-select Picklist
C. Custom Picklist
D. None of the Above
A

A. Checkbox

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A. Master (Custom object) and Detail (Standard object)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

D. Child records are not deleted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

B. When fields are deleted, they are also deleted from the summary formulas that reference them

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Can a standard field be made an External ID field?
A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
The first 3 characters of a 15 Digit ID identifies the
A. Record
B. Object
C. Field
D. Application
E. Organization
A

B. Object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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)

A

C. Formula Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A Custom Lookup Field can be created between Account and Opportunity
A. Yes
B. No

A

A. Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A. Custom Formula Fields can reference other formula fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
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

A. Adding multiple records together

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

D. Creating two lookup relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q
Which type of field cannot be universally required?
A. Lookup
B. Text
C. Email
D. Number
A

A. Lookup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q
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

A. Lookup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Default values are available for standard text fields.
A. True
B. False

A

B. False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q
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
A

B. 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

D. Creating two lookup relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q
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
A

B. Self

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q
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

A. Lookup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q
Field history tracking allows users to choose up to \_\_\_\_ fields per object
A. 5
B. 10
C. 20
D. 40
A

C. 20

28
Q

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

A

D. Creating two lookup relationships

29
Q

Required and Unique field options works on Custom Fields only
A. True
B. False

A

B. False

30
Q
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

A. Cross-object formula field

31
Q

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

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.

32
Q

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. A custom object that has 2 master-detail relationships

33
Q
A Rollup Summary field is supported by which relationship?
A. Master Detail
B. Workflow
C. Validation Rules
D. Lookup
A

A. Master Detail

34
Q

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

A

B. Production and full copy sandbox only.

35
Q
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
A

B. Hierarchical

36
Q

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

A

C. Custom object is always a child

D. Standard or custom object can be a master

37
Q
Maximum number of master-detail relationships per object
A. 0
B. 1
C. 2
D. 3
E. 4
A

C. 2

38
Q

In a master detail relationship, the owner of the parent record controls both the parent and the child
A. True
B. False

A

A. True

39
Q
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
A

B. Self

40
Q

Custom Formula fields can reference fields on related objects
A. True
B. False

A

A. True

41
Q
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
A

B. Nothing

42
Q

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

A. True

43
Q

A Junction Object is a Custom Object with three master detail relationships
A. True
B. False
C. Sometimes

A

B. False

44
Q

Custom Objects automatically have some standard fields
A. True
B. False
C. Some of them have

A

A. True

45
Q

Child Records in a Master-detail Relationship inherit the Organization Wide Defaults from their parents
A. True
B. False

A

A. True

46
Q

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.

A

B. You can only create a cross-object formula field on the child object.

47
Q
\_\_ Lookup Relationships are allowed per object
A. 10
B. 20
C. 25
D. 40
A

C. 25

48
Q
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
A

B. 2

49
Q

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

A

D. Object with two master-detail relationships

50
Q

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

A. True

51
Q
What are the data types that are supported by formula fields? (3 answers)
A. Text
B. Percent
C. Email
D. Currency
E. Phone
A

A. Text
B. Percent
D. Currency

52
Q
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
A. Self
B. Lookup
C. Master Detail
D. Many to Many
F. One to One
53
Q

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

A

D. All child records are deleted

54
Q
Custom Fields are stored for how many days after deletion?
A. 10 Days
B. 30 Days
C. 45 Days
D. 100 Days
A

C. 45 Days

55
Q

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

A

D. 500

56
Q

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

A

D. 18

57
Q
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

A. Percent

B. URL

58
Q

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

A

B. A required field is always present in an edit page

59
Q
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

A. Date

60
Q
The number of master detail relationship that an object can have are 
A. 1 
B. 2 
C. 25 
D.	300
A

B. 2

61
Q
The number of Lookup relationship that an object can have are 
A. 1 
B. 2 
C. 25 
D. 300
A

C. 25

62
Q

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

A. Parent is not a required field and may be omitted.

63
Q

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.

A

D. Roll-up summary fields are read only.

64
Q
Which of the following is not the Return Type for Formula Fields?
A. Currency
B. Radio Button
C. Text
D. Percent
A

B. Radio Button

65
Q

Default values can be set on the Dependent Picklist Fields
A. True
B. False

A

A. True