Anyone that has worked on projects with several different environments knows the pain involved with getting identical LOVs. You might think: how difficult can it be?
 
Try working with 40-50 developers, tight deadlines, multiple builds, corrections after testing cycles etc, and chances are big the LOVs will be out of synch.

Siebel uses Denormalized Columns to improve the performance of query operation in view where data visibility is restricted using Siebel View modes like Organization, Position etc. Denormalized columns are generally created for columns most frequently used for query like Contact First Name, Last Name etc. 

High Interactivity and Standard Interactivity are Types of User interface.
High Interactivity is available for employee Applications supporting highly interactive enterprise users and requires internet explorer 5 or more.
 Standard Interactivity is available for customer Application and behaves like traditional web applications, requiring frequent page refreshes.

Purpose of Constraint Picklists is to restrict or constraint the values of child Picklist based on the value of parent.

Every Button created have a specific functionality associated with it, a task that is performed just on a click. We can create and place a button either on the applet header or we can provide the same functionality option in Menu Items.