Below are some important Siebel CRM interview questions which are asked in most MNC company interviews for beginners or professionals.
21. What is s_party table?
S_PARTY Table is the Base Table for all the Party related tables.
S_ORG_EXT
S_CONTACT
S_USER
S_BU
and etc.
the party tables can have the implied joins. the party related BC's have the S_PARTY as the base table. so, any of these tables are extension tables.
22. What does install.ksh and imprep.ksh files do?
Imprep.ksh : This is a database unix shell script provided by siebel for importing all your sif files in siebel repository.It is automatically run while installing siebel and it prepares Repository file in tools.
Install.ksh : contains all manually applied installation files.
23. What is the difference between Links and Multi Value links?
Link is used for Master Detail View of two BCs. where as MVL is used to view the child records using MVG. MVL uses Link to get the records from the child BC.
Link is between the entities and MVL is between the records
24. Describe the 3 Object Explorer (OE) tabs.
Types: higher level object types displayed,
Details: expanded top level object type displays object definitions of that type,
Flat: displays all definitions of that type
25. What object types have a Sort Specification property?
BCs,
Pick Lists,
Links.
26. What are the steps for creating a static pick list?
Create a new static pick list. Add BC field that will be populated. Map the BC field to the pick list BC field. Specify which control or list column will invoke the pick list applet. Picklist will be empty until values are put in the S_LST_OF_VAL table.
27. What are the steps for creating a dynamic pick list?
Create a Pick list using a BC representing the joined table. Associate the Pick list with a BC field. Map the BC fields to the Pick list BC fields. Create a Pick list applet. Specify which control or list column will invoke the Pick list applet.
28. What are the steps for creating a MVG?
Create a MVL in the parent BC. Add MVFs in the parent BC. Create a MVG applet to display child records. Add controls/list columns to the parent applet to display MVFs and invoke MVG applets. Add primary FK in the parent BC and on the MVL.
29. What is a primary key?
A primary is a FK on the parent-side that points to one “primary” record on the child-side of a 1:M link. A primary FK creates a 1:1 link between the parent and the child.
30. How do you create a primary on a MVL?
Add a primary key field on the parent BC. Set the Primary Id Field and Use Primary Join properties on the MVL.
21. What is s_party table?
S_PARTY Table is the Base Table for all the Party related tables.
S_ORG_EXT
S_CONTACT
S_USER
S_BU
and etc.
the party tables can have the implied joins. the party related BC's have the S_PARTY as the base table. so, any of these tables are extension tables.
22. What does install.ksh and imprep.ksh files do?
Imprep.ksh : This is a database unix shell script provided by siebel for importing all your sif files in siebel repository.It is automatically run while installing siebel and it prepares Repository file in tools.
Install.ksh : contains all manually applied installation files.
23. What is the difference between Links and Multi Value links?
Link is used for Master Detail View of two BCs. where as MVL is used to view the child records using MVG. MVL uses Link to get the records from the child BC.
Link is between the entities and MVL is between the records
24. Describe the 3 Object Explorer (OE) tabs.
Types: higher level object types displayed,
Details: expanded top level object type displays object definitions of that type,
Flat: displays all definitions of that type
25. What object types have a Sort Specification property?
BCs,
Pick Lists,
Links.
26. What are the steps for creating a static pick list?
Create a new static pick list. Add BC field that will be populated. Map the BC field to the pick list BC field. Specify which control or list column will invoke the pick list applet. Picklist will be empty until values are put in the S_LST_OF_VAL table.
27. What are the steps for creating a dynamic pick list?
Create a Pick list using a BC representing the joined table. Associate the Pick list with a BC field. Map the BC fields to the Pick list BC fields. Create a Pick list applet. Specify which control or list column will invoke the Pick list applet.
28. What are the steps for creating a MVG?
Create a MVL in the parent BC. Add MVFs in the parent BC. Create a MVG applet to display child records. Add controls/list columns to the parent applet to display MVFs and invoke MVG applets. Add primary FK in the parent BC and on the MVL.
29. What is a primary key?
A primary is a FK on the parent-side that points to one “primary” record on the child-side of a 1:M link. A primary FK creates a 1:1 link between the parent and the child.
30. How do you create a primary on a MVL?
Add a primary key field on the parent BC. Set the Primary Id Field and Use Primary Join properties on the MVL.
More Questions & Answers :-
No comments:
Post a Comment