Questions Answer on Relationship in SALESFORCE

Question No .1 : How many relationships included in SFDC & What are they?

We are having two types of relationships, they are

Lookup Relationship

Master-Detail Relationship

Question No .2 :What is a "Lookup Relationship"?

This type of relationship links two objects together, Up to 25 allowed for object Parent is not a required field.

No impact on a security and access.

No impact on deletion.

Can be multiple layers deep.

Lookup field is not required.

Question No .3 :What is “Master-Detail Relationship”?

Master Detail relationship is the Parent child relationship. In which Master represents Parent and detail represents Child. If Parent is deleted then Child also gets deleted. Rollup summary fields can only be created on Master records which will calculate the SUM, AVG, MIN of the Child records.

Up to 2 allowed to object.

Parent field on child is required.

Access to parent determines access to children.

Deleting parent automatically deletes child.

A child of one master detail relationship cannot be the parent of another.

Lookup field on page layout is required.

Question No .4 : How can I create Many – to – Many relationship?

Lookup and Master detail relationships are one to many relationships. We can create many – to – Many relationship by using junction object. Junction object is a custom object with two master detail relationships.

Question No .5 : A custom object contains some records, now my requirement is to create field in this object with master detail relationship. Can we create master detail relationship in this case?

No, directly we cannot create master details relationship if custom object contains existing records.

Following are the steps to create to create master-detail relationship when records are available in custom object.

1. First create field with lookup relationship.

2. And then associate look field with parent record for every record

3. Next change the data type of the field from look up to Master detail.

Question No .6 : What is a “Self Relationship”?

Self Relationship is a lookup relationship to the same object. Suppose let’s take an object “Merchandise”. Here we can create relationship in between the Account to Account (same object) object. That is called “Self Relationship”.

Question No .7 : What are the main things need to consider in the “Master-Detail Relationship”?

Record level access is determined by the parent, Mandatory on child for reference of parent, cascade delete (if you delete the parent, it can cascade delete the child).

Question No .8 :How to create Master Details relationship between existing records?

Directly we can’t create Master Detail relationship between existing records, first we have to create Lookup relationship and provide valid lookup fields and it shouldn’t  null.

Question No .9 : What is Roll-up summary?

Roll-up displays the count of child records and calculate the sum, min and max of fields of the child records.

Question No .10 :How to create Roll-up summary field on lookup relation?

Not possible. Roll-up summary is enabled for only Master –Detail relationship.

Question No .11: What is Audit Trail?

Audit Trail provides the information or track all the recent setup changes that an administrator done to the organization.

This can store the last 6 months data.

Question No. 12: What is difference between Role and Profile?

Role is Record level access and it is not mandatory for all users.

Profile is object level and field level access and it is mandatory for all users.

Question No.  13 : How to create Master Details relationship between existing records?

Directly we can’t create Master Detail relationship between existing records, first we have to create Lookup relationship and provide valid lookup fields and it shouldn’t  null.

Question 14: Which of the following is a step in creating a junction object?

a)     Creating the custom object to serve as the junction object between a custom and a standard objects

b)    Creating two master-detail relationships

c)     Customizing the related lists on the page layouts of the custom object

d)    Creating two lookup relationships

Ans : b)    Creating two master-detail relationships.

Question 15: When a record has been rejected by all approvers, Salesforce executes all final rejection actions.

Which of the following is NOT a possible final rejection action?

a)     Lock the record from being edited

b)    Send an email to a designated recipient

c)     Send to recycle bin

d)    Update a field on the record

Ans : c)     Send to recycle bin.

Question 16:  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

Ans : b)    2.

Question 17:  An organization has decided to manage hiring and positions.  A custom object has been created to manage all new job positions.  All positions below $50,000 must be approved by the hiring manager, and positions above $50,000 must be approved by the hiring manager, and the regional hiring manager.

What would a developer use to declaratively fulfill the requirement?

a)Apex Code, to check the position’s salary and assign to the appropriate resource for approval

b)    Approval process

c)     Validation rules

d)    Dynamic Routing Approval

Ans: b)    Approval process.

Qustion 18: A developer has created a junction object what is the significance of the first master-detail (primary) relationship?

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

Ans : a) Look and feel, the junction object's detail and edit pages use the color and any associated icon of the primary master object.

Question 19 : An organization has created an application manage new hires and job positions.  A custom object has been created to manage all job positions.  Using an approval process they have configured the application to have the first step of the process require approvals from three different hiring managers.

Select the two (2) possible approval choices based on multiple approvers for an approval step.

a)     Approve or reject based on the first response

b)    Require unanimous approval from all selected approvers

c)     Require majority approval from all selected approvers

d)    Require x out of y approval from all selected approvers

Ans: a and b.

Question 20: An organization wants to leverage a custom objects to track bugs.  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

Ans: b)    self.