Siebel CRM interview questions Part#6
Comprehensive Collection of Interview Questions on Siebel Configurations,Workflow,Siebel Tools
1.) 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
2.)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
3.)What object types have a Sort Specification property?
4.)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.
5) 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.
6)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.
7) 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.
8.) 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.
9.)List some of the calculated field limitations.
Cannot be used as sort criteria, stored in columns and read only. Validation criteria on calculated fields is ignored. If SQL is used and performs a calculation, the value will be applied after the data is in the BC, but before displaying in the applet.
10.)Describe the types of Siebel database extensions.
Standard extension tables – Predefined tables which support 1:1 or M:1 relationship. Partof the existing physical database.Custom extension tables and custom extension columns – New 1:1 tables, New columns that are added to new and existing tables.
11) What are the steps for using a standard 1:1 extension table?
Add a joined field in the parent BC (based on the “main” table). The join is implied and created automatically at runtime. Add a control or list column to an applet.
12.) What are the steps for using a standard 1:M extension table?
Create BC to represent 1:M extension table
Set Search Spec to equal Pre Default Value “TYPE” field
Add fields to the new BC (ensure “NAME” and “TYPE”)
Create a link from BC to New BC and add the New BC to BO
Create applet to display data from new BC
13)What is data-driven access control?
Controls the read-only nature of BC, BC record, or BC Field based on value of another BCField
BC Read Only Field: current record read only
Field Read Only Field: field specified by field name is read only
Parent Read Only Field: BC read only
14)Name the 5 main building blocks of the Siebel Architecture
Siebel Database Server.
15) Name the four levels of control we have over the Server
16.)Explain the 5 main functions of the Server Manger
Controls your Enterprise,
Manages Siebel Servers,
Allows the configuration of the components,
Allow you to run tasks,
17)Name and explain the three modes of Component operation.
Server Mode: run background operations for the server and runs forever, once started,
Task Mode: run specific task and exits upon completion,
Session Mode: created dynamically for client request. Runs as long as session is maintained then exits.