Civil Engineering Interview Questions Answers in top companies
What is rigging?
In sailing, the ropes used to move the sails around so the boat will move in the right direction when the wind blows.
What is absolute pressure?
Absolute pressure is simply the addition of the observed gage pressure plus the value of the local atmospheric pressure.
What is the meaning of soil reinforcement?
Soil reinforcement is the act of improving soil strength to enable it support or carry more load.
Two common examples are:
a) Mixing a soil amendment such as lime into weak clayey soil and re-comPActing to improve soil-bearing caPAcity (often done under the road base in highway construction)
b) Installing plastic or composite webbing layers (called geo-grid material) alternating with comPActed soil to produce a stronger sloped soil structure (often done on steep roadway embankments to improve strength and stability)
What is aggregate?
Aggregate is the component of a composite material used to resist compressive stress.
What is braced excavation all about?
Excavations are braced to prevent the cave-in of surrounding unstable soil.
What year was the keystone power plant in Indiana County constructed?
1967 began commercial operation on unit 1.
What is the force exerted by the Tacoma narrows bridge?
The force exerted to the Tacoma narrows bridge was initially the wind resistance. The wind resistance caused the whole bridge to act as a system with forced vibration with damping.
How do you calculate the power of a centrifugal pump?
The input power, that is, the power required to operate the pump should be stated in Hp (horsepower) on the pump's nameplate. It can also be calculated by the 3-phase power equation:
P(in Hp) = VI(1.7c) = Rated Voltage x Rated Current x 1.73/ %Efficiency
If this is a consumer grade pump that operates on 120Vac, then the equation becomes P = VI, simply multiply the operating voltage, 120 x current (which is the number followed by the letter "A".
The output power, which really is not technically power, but rated in Gpm (gallons per minute), or caPAcity should also be on the nameplate. If you have the make, model, and (not necessarily needed) the serial number (also on the nameplate) you could call the manufacturer's customer service dept. As an application engineer, I have contacted countless manufacturers’, and service dept's for assistance. It is now big deal to them, they will be happy to answer your questions.
What is nautical mile is different from statute mile?
One nautical mile is defined by one latitude minute of arc (there are 60 such minutes to a degree). This equals 1852 meters, and roughly (but coincidentally) 2000 yards or 6000 feet. (Edit: actually, a standard nautical mile is 6076 feet, 6000 feet and 2000 yards are commonly used approximations, but produce an error of about 1%).
The statute mile had a little fuzzier definition to start with, as one mile was the same as 1000 roman PAces/steps. The definition has since changed, but one statute mile equals about 1609 meters.
How do we calculate absolute pressure?
Absolute is equal to gauge pressure plus atmospheric.
More...
January 21, 2012
MS.NET Interview Questions And Answers
Posted Under
.NET Interview Questions,
Microsoft-Technologies-Interview
.Net Interview Questions And Answers for freshers and experienced professionals
What is code review?
The process of examining the source code generally through a peer, to verify it against best practices.
What is logging?
Logging is the process of persisting information about the status of an application.
What is the global assembly cache (GAC)?
GAC is a machine-wide cache of assemblies that allows .NET applications to share libraries. GAC solves some of the problems associated with dll’s (DLL Hell).
What is a stack? What is a heap? Give the differences between the two?
Stack is a place in the memory where value types are stored. Heap is a place in the memory where the reference types are stored.
What are functional and non-functional requirements?
Functional requirements defines the behavior of a system whereas non-functional requirements specify how the system should behave; in other words they specify the quality requirements and judge the behavior of a system.
E.g.
Functional - Display a chart which shows the maximum number of products sold in a region.
Non-functional – The data presented in the chart must be updated every 5 minutes.
What is instrumentation?
It is the ability to monitor an application so that information about the application’s progress, performance and status can be captured and reported.
What are mock-ups?
Mock-ups are a set of designs in the form of screens, diagrams, snapshots etc., that helps verify the design and acquire feedback about the application’s requirements and use cases, at an early stage of the design process.
What is a Form?
A form is a representation of any window displayed in your application. Form can be used to create standard, borderless, floating, modal windows.
What is a multiple-document interface(MDI)?
A user interface container that enables a user to work with more than one document at a time. E.g. Microsoft Excel.
What is a single-document interface (SDI) ?
A user interface that is created to manage graphical user interfaces and controls into single windows. E.g. Microsoft Word
What is BLOB ?
A BLOB (binary large object) is a large item such as an image or an exe represented in binary form.
What is ClickOnce?
ClickOnce is a new deployment technology that allows you to create and publish self-updating applications that can be installed and run with minimal user interaction.
What is object role modeling (ORM) ?
It is a logical model for designing and querying database models. There are various ORM tools in the market like CaseTalk, Microsoft Visio for Enterprise Architects, Infagon etc.
What is a private assembly?
A private assembly is local to the installation directory of an application and is used only by that application.
What is a shared assembly?
A shared assembly is kept in the global assembly cache (GAC) and can be used by one or more applications on a machine.
What is the difference between user and custom controls?
User controls are easier to create whereas custom controls require extra effort.
User controls are used when the layout is static whereas custom controls are used in dynamic layouts.
A user control cannot be added to the toolbox whereas a custom control can be.
A separate copy of a user control is required in every application that uses it whereas since custom controls are stored in the GAC, only a single copy can be used by all applications.
Where do custom controls reside?
In the global assembly cache (GAC).
What is a third-party control ?
A third-party control is one that is not created by the owners of a project. They are usually used to save time and resources and reuse the functionality developed by others (third-party).
What is a binary formatter?
Binary formatter is used to serialize and deserialize an object in binary format.
What is Boxing/Unboxing?
Boxing is used to convert value types to object.
E.g. int x = 1;
object obj = x ;
Unboxing is used to convert the object back to the value type.
E.g. int y = (int)obj;
Boxing/unboxing is quiet an expensive operation.
What is a COM Callable Wrapper (CCW)?
CCW is a wrapper created by the common language runtime(CLR) that enables COM components to access .NET objects.
What is a Runtime Callable Wrapper (RCW)?
RCW is a wrapper created by the common language runtime(CLR) to enable .NET components to call COM components.
What is a digital signature?
A digital signature is an electronic signature used to verify/gurantee the identity of the individual who is sending the message.
What is garbage collection?
Garbage collection is the process of managing the allocation and release of memory in your applications. Read this article for more information.
What is globalization?
Globalization is the process of customizing applications that support multiple cultures and regions.
What is localization?
Localization is the process of customizing applications that support a given culture and regions.
What is MIME?
The definition of MIME or Multipurpose Internet Mail Extensions as stated in MSDN is “MIME is a standard that can be used to include content of various types in a single message. MIME extends the Simple Mail Transfer Protocol (SMTP) format of mail messages to include multiple content, both textual and non-textual. Parts of the message may be images, audio, or text in different character sets. The MIME standard derives from RFCs such as 2821 and 2822”. Quoted from here.
More...
What is code review?
The process of examining the source code generally through a peer, to verify it against best practices.
What is logging?
Logging is the process of persisting information about the status of an application.
What is the global assembly cache (GAC)?
GAC is a machine-wide cache of assemblies that allows .NET applications to share libraries. GAC solves some of the problems associated with dll’s (DLL Hell).
What is a stack? What is a heap? Give the differences between the two?
Stack is a place in the memory where value types are stored. Heap is a place in the memory where the reference types are stored.
What are functional and non-functional requirements?
Functional requirements defines the behavior of a system whereas non-functional requirements specify how the system should behave; in other words they specify the quality requirements and judge the behavior of a system.
E.g.
Functional - Display a chart which shows the maximum number of products sold in a region.
Non-functional – The data presented in the chart must be updated every 5 minutes.
What is instrumentation?
It is the ability to monitor an application so that information about the application’s progress, performance and status can be captured and reported.
What are mock-ups?
Mock-ups are a set of designs in the form of screens, diagrams, snapshots etc., that helps verify the design and acquire feedback about the application’s requirements and use cases, at an early stage of the design process.
What is a Form?
A form is a representation of any window displayed in your application. Form can be used to create standard, borderless, floating, modal windows.
What is a multiple-document interface(MDI)?
A user interface container that enables a user to work with more than one document at a time. E.g. Microsoft Excel.
What is a single-document interface (SDI) ?
A user interface that is created to manage graphical user interfaces and controls into single windows. E.g. Microsoft Word
What is BLOB ?
A BLOB (binary large object) is a large item such as an image or an exe represented in binary form.
What is ClickOnce?
ClickOnce is a new deployment technology that allows you to create and publish self-updating applications that can be installed and run with minimal user interaction.
What is object role modeling (ORM) ?
It is a logical model for designing and querying database models. There are various ORM tools in the market like CaseTalk, Microsoft Visio for Enterprise Architects, Infagon etc.
What is a private assembly?
A private assembly is local to the installation directory of an application and is used only by that application.
What is a shared assembly?
A shared assembly is kept in the global assembly cache (GAC) and can be used by one or more applications on a machine.
What is the difference between user and custom controls?
User controls are easier to create whereas custom controls require extra effort.
User controls are used when the layout is static whereas custom controls are used in dynamic layouts.
A user control cannot be added to the toolbox whereas a custom control can be.
A separate copy of a user control is required in every application that uses it whereas since custom controls are stored in the GAC, only a single copy can be used by all applications.
Where do custom controls reside?
In the global assembly cache (GAC).
What is a third-party control ?
A third-party control is one that is not created by the owners of a project. They are usually used to save time and resources and reuse the functionality developed by others (third-party).
What is a binary formatter?
Binary formatter is used to serialize and deserialize an object in binary format.
What is Boxing/Unboxing?
Boxing is used to convert value types to object.
E.g. int x = 1;
object obj = x ;
Unboxing is used to convert the object back to the value type.
E.g. int y = (int)obj;
Boxing/unboxing is quiet an expensive operation.
What is a COM Callable Wrapper (CCW)?
CCW is a wrapper created by the common language runtime(CLR) that enables COM components to access .NET objects.
What is a Runtime Callable Wrapper (RCW)?
RCW is a wrapper created by the common language runtime(CLR) to enable .NET components to call COM components.
What is a digital signature?
A digital signature is an electronic signature used to verify/gurantee the identity of the individual who is sending the message.
What is garbage collection?
Garbage collection is the process of managing the allocation and release of memory in your applications. Read this article for more information.
What is globalization?
Globalization is the process of customizing applications that support multiple cultures and regions.
What is localization?
Localization is the process of customizing applications that support a given culture and regions.
What is MIME?
The definition of MIME or Multipurpose Internet Mail Extensions as stated in MSDN is “MIME is a standard that can be used to include content of various types in a single message. MIME extends the Simple Mail Transfer Protocol (SMTP) format of mail messages to include multiple content, both textual and non-textual. Parts of the message may be images, audio, or text in different character sets. The MIME standard derives from RFCs such as 2821 and 2822”. Quoted from here.
More...
January 20, 2012
Accenture Microsoft.NET Interview Questions and Answers
Posted Under
.NET Interview Questions,
Microsoft-Technologies-Interview
Accenture DotNet Interview Questions and Answers
What event can you subscribe to if you want to display information from SQL Print statements?
NOTE: This is objective type question, Please click question title for correct answer.
Q1. Explain the differences between Server-side and Client-side code?
Ans. Server side code will execute at server (where the website is hosted) end, & all the business logic will execute at server end where as client side code will execute at client side (usually written in javascript, vbscript, jscript) at browser end.
Q2. What type of code (server or client) is found in a Code-Behind class?
Ans. Server side code.
Q3. How to make sure that value is entered in an asp:Textbox control?
Ans. Use a RequiredFieldValidator control.
Q4. Which property of a validation control is used to associate it with a server control on that page?
Ans. ControlToValidate property.
Q5. How would you implement inheritance using VB.NET & C#?
Ans. C# Derived Class : Baseclass
VB.NEt : Derived Class Inherits Baseclass
Q6. Which method is invoked on the DataAdapter control to load the generated dataset with data? Ans. Fill() method.
Q7. What method is used to explicitly kill a user's session?
Ans. Session.Abandon()
Q8. What property within the asp:gridview control is changed to bind columns manually?
Ans. Autogenerated columns is set to false
Q9. Which method is used to redirect the user to another page without performing a round trip to the client?
Ans. Server.Transfer method.
Q10. How do we use different versions of private assemblies in same application without re-build? Ans.Inside the Assemblyinfo.cs or Assemblyinfo.vb file, we need to specify assembly version.
assembly: AssemblyVersion
Difference between VB.NET and C#.
Difference between VB.NET and C#.
VB.NET :
-----------
1)no unsigned int
2)Loosely typed language
3)no operator overloading
4)no pointers
5)no auto XML documentation
C#.net :
-------------
1) supports unsigned int
2)strongly typed language
3)supports operator overloading
4)supports pointers
5)supports auto XML documentation
Name a feature which is common to all .NET languages?
Name a feature which is common to all .NET languages?
There is only one feature which is common to all languages and that is Garbage collection or GC. This feature is automated which relieves developers of much work. This garbage is disposed only when there is need of memory or stress for memory. GC feature halts the application for few seconds before restarting it.
What is the difference between Master- Detail view and MVG?
Following are the main advantages:-
1) MVG Makes effective use of the space.
2) Multiple set of detail records can be viewed from a single
view
If I write System.exit (0); at the end of the try block, will the finally block still execute ?
No in this case the finally block will not execute because when you say System.exit (0); the control immediately goes out of the program, and thus finally never executes.
whats the similarilty & difference between .dll extension and .exe extension files?
A standard exe application is one that is created using Standard EXE project. It is the most widely used Project type using VB6. Standard EXE application is normally the most widely used among the available Project types in Visual Basic. Stand-alone programs have an .EXE file extension.
Usage A standard EXE application is normally used when you want to develop a stand-alone application. Examples include calculators, text editors, and other similar applications.
An ActiveX EXE application is one that is created using ActiveX EXE project. ActiveX EXE are widely used in conjunction with standard EXE applications. There are three types of widely used of ActiveX projects. These are:
a. ActiveX EXE
b. ActiveX DLL
c. ActiveX Control
ActiveX EXE: Unlike a stand-alone EXE file, an ActiveX EXE file is designed to work as an OLE server, which is nothing more than a program designed to share information with another program. It has an .EXE file extension.
ActiveX DLL: ActiveX DLL files are not meant to be used by themselves. Instead, these types of files contain subprograms designed to function as building blocks when creating a stand-alone program. It has a .DLL file extension.
ActiveX Control: Unlike an ActiveX DLL or ActiveX EXE file, an ActiveX Control file usually provides both subprograms and a user interface that you can reuse in other programs. It has an .OCX file extension.
Usage
1. The ActiveX EXE/DLL is normally used when you need to build a component that is separate from the main program. The concept is based on COM model.
2. ActiveX DLL/EXE allows multiple applications to share the same code. This allows for scalability of programs, and saves time because you only need to write the code once.
3. ActiveX DLLs and ActiveX EXEs are almost same in the ways they are built and used. In either case, you build one or more classes that applications can use to do something.
4. One of the main differences between ActiveX EXE and an ActiveX DLL's is that the code is executed within the main program's address space for ActiveX DLL. This is because the code lies inside the program's address space, calling methods and execution of code is very fast.
Differences
An ActiveX Exe provides the reusability of code, by accessing it from different clients.
An ActiveX Exe is a component that can be called by another application by providing a reference to the component. But a Standard Exe application cannot be called in this way.
An ActiveX EXE's code is run in a separate process. When the main program calls an ActiveX EXE's method, the application passes required parameters into the ActiveX EXE's and calls the method. The ActiveX EXE, upon execution may return the results to the main program. This is slower than running an ActiveX DLL's method inside the main program's address space.
More...
What event can you subscribe to if you want to display information from SQL Print statements?
NOTE: This is objective type question, Please click question title for correct answer.
Q1. Explain the differences between Server-side and Client-side code?
Ans. Server side code will execute at server (where the website is hosted) end, & all the business logic will execute at server end where as client side code will execute at client side (usually written in javascript, vbscript, jscript) at browser end.
Q2. What type of code (server or client) is found in a Code-Behind class?
Ans. Server side code.
Q3. How to make sure that value is entered in an asp:Textbox control?
Ans. Use a RequiredFieldValidator control.
Q4. Which property of a validation control is used to associate it with a server control on that page?
Ans. ControlToValidate property.
Q5. How would you implement inheritance using VB.NET & C#?
Ans. C# Derived Class : Baseclass
VB.NEt : Derived Class Inherits Baseclass
Q6. Which method is invoked on the DataAdapter control to load the generated dataset with data? Ans. Fill() method.
Q7. What method is used to explicitly kill a user's session?
Ans. Session.Abandon()
Q8. What property within the asp:gridview control is changed to bind columns manually?
Ans. Autogenerated columns is set to false
Q9. Which method is used to redirect the user to another page without performing a round trip to the client?
Ans. Server.Transfer method.
Q10. How do we use different versions of private assemblies in same application without re-build? Ans.Inside the Assemblyinfo.cs or Assemblyinfo.vb file, we need to specify assembly version.
assembly: AssemblyVersion
Difference between VB.NET and C#.
Difference between VB.NET and C#.
VB.NET :
-----------
1)no unsigned int
2)Loosely typed language
3)no operator overloading
4)no pointers
5)no auto XML documentation
C#.net :
-------------
1) supports unsigned int
2)strongly typed language
3)supports operator overloading
4)supports pointers
5)supports auto XML documentation
Name a feature which is common to all .NET languages?
Name a feature which is common to all .NET languages?
There is only one feature which is common to all languages and that is Garbage collection or GC. This feature is automated which relieves developers of much work. This garbage is disposed only when there is need of memory or stress for memory. GC feature halts the application for few seconds before restarting it.
What is the difference between Master- Detail view and MVG?
Following are the main advantages:-
1) MVG Makes effective use of the space.
2) Multiple set of detail records can be viewed from a single
view
If I write System.exit (0); at the end of the try block, will the finally block still execute ?
No in this case the finally block will not execute because when you say System.exit (0); the control immediately goes out of the program, and thus finally never executes.
whats the similarilty & difference between .dll extension and .exe extension files?
A standard exe application is one that is created using Standard EXE project. It is the most widely used Project type using VB6. Standard EXE application is normally the most widely used among the available Project types in Visual Basic. Stand-alone programs have an .EXE file extension.
Usage A standard EXE application is normally used when you want to develop a stand-alone application. Examples include calculators, text editors, and other similar applications.
An ActiveX EXE application is one that is created using ActiveX EXE project. ActiveX EXE are widely used in conjunction with standard EXE applications. There are three types of widely used of ActiveX projects. These are:
a. ActiveX EXE
b. ActiveX DLL
c. ActiveX Control
ActiveX EXE: Unlike a stand-alone EXE file, an ActiveX EXE file is designed to work as an OLE server, which is nothing more than a program designed to share information with another program. It has an .EXE file extension.
ActiveX DLL: ActiveX DLL files are not meant to be used by themselves. Instead, these types of files contain subprograms designed to function as building blocks when creating a stand-alone program. It has a .DLL file extension.
ActiveX Control: Unlike an ActiveX DLL or ActiveX EXE file, an ActiveX Control file usually provides both subprograms and a user interface that you can reuse in other programs. It has an .OCX file extension.
Usage
1. The ActiveX EXE/DLL is normally used when you need to build a component that is separate from the main program. The concept is based on COM model.
2. ActiveX DLL/EXE allows multiple applications to share the same code. This allows for scalability of programs, and saves time because you only need to write the code once.
3. ActiveX DLLs and ActiveX EXEs are almost same in the ways they are built and used. In either case, you build one or more classes that applications can use to do something.
4. One of the main differences between ActiveX EXE and an ActiveX DLL's is that the code is executed within the main program's address space for ActiveX DLL. This is because the code lies inside the program's address space, calling methods and execution of code is very fast.
Differences
An ActiveX Exe provides the reusability of code, by accessing it from different clients.
An ActiveX Exe is a component that can be called by another application by providing a reference to the component. But a Standard Exe application cannot be called in this way.
An ActiveX EXE's code is run in a separate process. When the main program calls an ActiveX EXE's method, the application passes required parameters into the ActiveX EXE's and calls the method. The ActiveX EXE, upon execution may return the results to the main program. This is slower than running an ActiveX DLL's method inside the main program's address space.
More...
January 19, 2012
Estimation and Costing - Civil Engineering Interview
Posted Under
Civil-Engineering-Interview
Estimation and Costing - Civil Engineering Interview Questions
* Give the % of steel used for RCC Item of work for Column footings, Columns, Plinth Beam, and Roof Slab in the preparation of detailed estimate?
* Write short notes on a) Plinth Area Estimate, b). Revised Estimate, c), Supplementary Estimate, and d) Actual or Complete Estimate
* Define Estimating? Method of Estimation? Explain with examples?
* What are Detailed Estimate and Abstract Estimate? List out Types of Estimation?
* Give the area co-efficient required for Painting of wood work in the preparation of detailed estimate?
* List out main items of work of a building with unit of measurement?
* List out the common L.S. provisions required for a Building?
* List and explain any eight general items of work involved in the estimation for a building along with the process of calculations.
* “An estimate is never the actual cost of work" justify your answer with a suitable example
* Enumerate different methods for estimating building works along with a suitable example
* Explain the following general items of work involved in the estimation for a building and its process calculation.
(a) Earthwork excavation for foundation trenches
(b) Earthwork in filling
(c) Cement or lime concrete in foundation
(d) Damp proof course
* Write down unit of measurement, unit rate of payment and mode of measurement for the following general items of work.
(a) Rain-water, Vent, Waste pipes etc.
(b) Ventilating cowls.
(c) Surface drains.
(d) Sanitary fittings.
(e) Glass-panes.
(f) Broken glass coping.
* List out limits of measurement and degrees of accuracy in estimating.
Unit 2:
* Prepare a preliminary estimate for a framed four storied office building having a carpet area of 250 sq m for each floor. Assume areas occupied by corridor, verandah, lavatories, staircase etc as 25% of built up area and that occupied by walls and columns as 8.5% of the same. The following details may be used for estimation
(a) Built-up area rate for ground floor (excluding foundation) = Rs1,500/- per sqm
(b) Built-up area rate for 1st and 2nd floor = Rs1,650/- per sq m
(c) Built-up area rate for 3rd floor = Rs1,800/- per sq m
(d) Extra for foundation = 20% of superstructure cost
(e) Extra for special architectural treatment = 1% of building cost
(f) Extra for water supply and sanitary = 7
(g) Extra for electrical installation = 8% of building cost
(h) Extra for contingencies = 4% of overall cost
(i) Extra for work charge establishment = 10
(j) Extra for other source = 5% of building cost.
Unit 3:
* The formation width of a road embankment is 9.0m. The side slopes are 2.5:1. The depths along the center line of road at 50.0m intervals are 1.2,1.1,1.4,1.2,0.9,1.5 and 1.0.m. It is required to calculate the quantity of earthwork by
(a) Prismoidal rule.
(b) Trapezoidal rule.
* Estimate the cost of earthwork for laying of road for 400m length from the following data. Formation width of the road is 10meter. Side slopes are 2:1 in banking 1:1 in cutting.
Station Distance in meter RL of ground RL of formation
25 1000 51.00 55.00
26 1040 50.00
27 1080 50.50
28 1120 50.80
29 1160 50.60 Downward gradient of 1 in 250
30 1200 50.70
31 1240 51.20
32 1280 51.40
33 1320 51.30
34 1360 51.00
35 1400 50.60
* Calculate the quantity of each work for 200m length for a portion of a road in an uniform ground the heights of bank at the two ends being 1.00m and 1.60m. The formation width is 1.0 m and side slopes 2:1 (H:V). Assume that there is no transverse slope. Use the following methods and justify which method is good.
(a) Prismoidal formula and
(b) Mean - sectional area method
Unit 4:
* Explain Analysis of Rates? Factors affecting rate of an item of work? Give different heads used in Analysis of Rates.
* Describe the procedure for the calculation of rate per unit cum of cement concrete 1:2:4 with stone ballast 40 mm
* Describe the procedure for the calculation of rate per unit sq.m of the following items
(a) White washing three coats.
(b) White washing two coats.
* Describe the procedure for the calculation of rate per unit cu.m of RCC work in beams, slabs etc., 1:2:4 work excluding steel but including centering, shuttering, bending and binding.
* Describe the procedure for the calculation of rate per unit cu.m of Random Rubble stone masonary in foundation and plinth.
Unit 5:
* Define reinforcement? List and explain various types of reinforcement?
* What do you mean by development of length of reinforcement?
* What do you mean by lap length, explain with suitable sketches
* What are the cover rules to be followed in RCC.
* Draw reinforcement details along with curtailment lengths in the following slabs.
(a) Simply supported.
(b) Continuous over several spans.
* Differentiate between development length in tension and compression.
Unit 6:
* Distinguish Contractor and Contract? Types of Contract? Explain?
* What do you understand about Contract Document?
* Write a short note on the following with respect to contract document.
(a) Security deposit.
(b) Retention money.
* Write a short note on the following:
(a) Informal tender.
(b) Sale of tender papers.
(c) Unbalanced tender.
* Explain the following
(a) Market rate.
(b) Work-charged establishment.
(c) Lump-sum
* Differentiate between Security deposit and Retention money.
* Elaborate earnest money along with its necessary
* Write a short note on the following:
(a) Time limits for tender notice
(b) Sale of tender papers.
(c) Global tender
Unit 7:
* What do you understand about Valuation? Explain?
* Explain the following method of valuation of a building along with an example.
1. Valuation based on profit
2. Depreciation method of valuation.
* A colonizer intends to purchase a land of 100,000 sq m area located in the suburb of a big city to develop it into plots of 700 sq.m each after providing necessary roads and parks and other amenities. The current sale price of small plots in the Neighbourhood is Rs.25.00 per sq.m. The colonizer wants a net prot of 25%. Work out the maximum price of the land at which the colonizer may purchase the land
* A building is situated by the side of a main road of Hyderabad city on a land of 600 sq.m. The built up portion in 22m x 17m. The building is first class type and provided with water supply, sanitary and electric fittings, and the age of the building is 30 years. Workout the valuation of the property. Assume plinth area rate is Rs.200.00 and cost of land as Rs.6000 per sq.m.
* Explain the following method of valuation of a building along with an example.
(a) Rental method of valuation
(b) Direct comparison with the capital value.
Unit 8:
* List and explain standard speciations of a first class building.
* Give the detailed specifications of the following items of works.
(a) Colour washing
(b) Lime concrete in foundation.
* Give the detailed specifications of the following items of works.
(a) Cast iron water pipes
(b) Mangalore tiled roof.
* Give the detailed specifications of the following items of works.
(a) Earthwork in excavation in foundation
(b) Random rubble stone masonry.
More...
* Give the % of steel used for RCC Item of work for Column footings, Columns, Plinth Beam, and Roof Slab in the preparation of detailed estimate?
* Write short notes on a) Plinth Area Estimate, b). Revised Estimate, c), Supplementary Estimate, and d) Actual or Complete Estimate
* Define Estimating? Method of Estimation? Explain with examples?
* What are Detailed Estimate and Abstract Estimate? List out Types of Estimation?
* Give the area co-efficient required for Painting of wood work in the preparation of detailed estimate?
* List out main items of work of a building with unit of measurement?
* List out the common L.S. provisions required for a Building?
* List and explain any eight general items of work involved in the estimation for a building along with the process of calculations.
* “An estimate is never the actual cost of work" justify your answer with a suitable example
* Enumerate different methods for estimating building works along with a suitable example
* Explain the following general items of work involved in the estimation for a building and its process calculation.
(a) Earthwork excavation for foundation trenches
(b) Earthwork in filling
(c) Cement or lime concrete in foundation
(d) Damp proof course
* Write down unit of measurement, unit rate of payment and mode of measurement for the following general items of work.
(a) Rain-water, Vent, Waste pipes etc.
(b) Ventilating cowls.
(c) Surface drains.
(d) Sanitary fittings.
(e) Glass-panes.
(f) Broken glass coping.
* List out limits of measurement and degrees of accuracy in estimating.
Unit 2:
* Prepare a preliminary estimate for a framed four storied office building having a carpet area of 250 sq m for each floor. Assume areas occupied by corridor, verandah, lavatories, staircase etc as 25% of built up area and that occupied by walls and columns as 8.5% of the same. The following details may be used for estimation
(a) Built-up area rate for ground floor (excluding foundation) = Rs1,500/- per sqm
(b) Built-up area rate for 1st and 2nd floor = Rs1,650/- per sq m
(c) Built-up area rate for 3rd floor = Rs1,800/- per sq m
(d) Extra for foundation = 20% of superstructure cost
(e) Extra for special architectural treatment = 1% of building cost
(f) Extra for water supply and sanitary = 7
(g) Extra for electrical installation = 8% of building cost
(h) Extra for contingencies = 4% of overall cost
(i) Extra for work charge establishment = 10
(j) Extra for other source = 5% of building cost.
Unit 3:
* The formation width of a road embankment is 9.0m. The side slopes are 2.5:1. The depths along the center line of road at 50.0m intervals are 1.2,1.1,1.4,1.2,0.9,1.5 and 1.0.m. It is required to calculate the quantity of earthwork by
(a) Prismoidal rule.
(b) Trapezoidal rule.
* Estimate the cost of earthwork for laying of road for 400m length from the following data. Formation width of the road is 10meter. Side slopes are 2:1 in banking 1:1 in cutting.
Station Distance in meter RL of ground RL of formation
25 1000 51.00 55.00
26 1040 50.00
27 1080 50.50
28 1120 50.80
29 1160 50.60 Downward gradient of 1 in 250
30 1200 50.70
31 1240 51.20
32 1280 51.40
33 1320 51.30
34 1360 51.00
35 1400 50.60
* Calculate the quantity of each work for 200m length for a portion of a road in an uniform ground the heights of bank at the two ends being 1.00m and 1.60m. The formation width is 1.0 m and side slopes 2:1 (H:V). Assume that there is no transverse slope. Use the following methods and justify which method is good.
(a) Prismoidal formula and
(b) Mean - sectional area method
Unit 4:
* Explain Analysis of Rates? Factors affecting rate of an item of work? Give different heads used in Analysis of Rates.
* Describe the procedure for the calculation of rate per unit cum of cement concrete 1:2:4 with stone ballast 40 mm
* Describe the procedure for the calculation of rate per unit sq.m of the following items
(a) White washing three coats.
(b) White washing two coats.
* Describe the procedure for the calculation of rate per unit cu.m of RCC work in beams, slabs etc., 1:2:4 work excluding steel but including centering, shuttering, bending and binding.
* Describe the procedure for the calculation of rate per unit cu.m of Random Rubble stone masonary in foundation and plinth.
Unit 5:
* Define reinforcement? List and explain various types of reinforcement?
* What do you mean by development of length of reinforcement?
* What do you mean by lap length, explain with suitable sketches
* What are the cover rules to be followed in RCC.
* Draw reinforcement details along with curtailment lengths in the following slabs.
(a) Simply supported.
(b) Continuous over several spans.
* Differentiate between development length in tension and compression.
Unit 6:
* Distinguish Contractor and Contract? Types of Contract? Explain?
* What do you understand about Contract Document?
* Write a short note on the following with respect to contract document.
(a) Security deposit.
(b) Retention money.
* Write a short note on the following:
(a) Informal tender.
(b) Sale of tender papers.
(c) Unbalanced tender.
* Explain the following
(a) Market rate.
(b) Work-charged establishment.
(c) Lump-sum
* Differentiate between Security deposit and Retention money.
* Elaborate earnest money along with its necessary
* Write a short note on the following:
(a) Time limits for tender notice
(b) Sale of tender papers.
(c) Global tender
Unit 7:
* What do you understand about Valuation? Explain?
* Explain the following method of valuation of a building along with an example.
1. Valuation based on profit
2. Depreciation method of valuation.
* A colonizer intends to purchase a land of 100,000 sq m area located in the suburb of a big city to develop it into plots of 700 sq.m each after providing necessary roads and parks and other amenities. The current sale price of small plots in the Neighbourhood is Rs.25.00 per sq.m. The colonizer wants a net prot of 25%. Work out the maximum price of the land at which the colonizer may purchase the land
* A building is situated by the side of a main road of Hyderabad city on a land of 600 sq.m. The built up portion in 22m x 17m. The building is first class type and provided with water supply, sanitary and electric fittings, and the age of the building is 30 years. Workout the valuation of the property. Assume plinth area rate is Rs.200.00 and cost of land as Rs.6000 per sq.m.
* Explain the following method of valuation of a building along with an example.
(a) Rental method of valuation
(b) Direct comparison with the capital value.
Unit 8:
* List and explain standard speciations of a first class building.
* Give the detailed specifications of the following items of works.
(a) Colour washing
(b) Lime concrete in foundation.
* Give the detailed specifications of the following items of works.
(a) Cast iron water pipes
(b) Mangalore tiled roof.
* Give the detailed specifications of the following items of works.
(a) Earthwork in excavation in foundation
(b) Random rubble stone masonry.
More...
Siebel Workflow Related SQLs and Queries
Posted Under
Siebel-Tutorials
To find the WFs in which BS is used:
SELECT
T1.SERVICE_NAME "BS",
T2.name "WF",
T2.status_cd "WF Status"
FROM
S_WF_STEP T1,
s_wf_step T2
WHERE
T1.row_id = T2.process_id and
T2.SERVICE_NAME like ('BS NAME')
and T1.status_cd ='ACTIVE'
To find WF policy from WF process:
select t1.name from siebel.s_escl_rule t1, s_escl_action t2,s_action_arg t3 where
t1.row_id = t2.rule_id and
t2.action_id = t3.action_id and
t3.DEFAULT_VALUE like 'WF Process Name'
To find parent process from sub process:
select distinct(name) from s_wf_step where
status_cd ='ACTIVE' and
type_cd='PROCESS' and row_id in
(select distinct(process_id) from s_wf_step where method_name like
'Sub Process Name'
and type_cd ='SUB_PROCESS')
More...
SELECT
T1.SERVICE_NAME "BS",
T2.name "WF",
T2.status_cd "WF Status"
FROM
S_WF_STEP T1,
s_wf_step T2
WHERE
T1.row_id = T2.process_id and
T2.SERVICE_NAME like ('BS NAME')
and T1.status_cd ='ACTIVE'
To find WF policy from WF process:
select t1.name from siebel.s_escl_rule t1, s_escl_action t2,s_action_arg t3 where
t1.row_id = t2.rule_id and
t2.action_id = t3.action_id and
t3.DEFAULT_VALUE like 'WF Process Name'
To find parent process from sub process:
select distinct(name) from s_wf_step where
status_cd ='ACTIVE' and
type_cd='PROCESS' and row_id in
(select distinct(process_id) from s_wf_step where method_name like
'Sub Process Name'
and type_cd ='SUB_PROCESS')
More...
January 18, 2012
Interview Question Answers on Microsoft .NET
Posted Under
.NET Interview Questions,
Microsoft-Technologies-Interview
What is the difference between a strong and weak named assemblies?
1. Weak named assemblies can be duplicated and tampered with, where as strong named assemblies cannot be tampered and duplicated.
2. Strong named assemblies can be copied into GAC(GLOBAL ASSEMBLY CACHE), where as weak named assemblies cannot be copied.
3. A single copy of strong named assembly present in the GAC(GLOBAL ASSEMBLY CACHE) can be shared with multiple applications, where as weak named assembly must be copied into the bin directory of each project.
What is an application domain?
An application domain is the CLR equivalent of an operation system’s
process. An application domain is used to isolate applications from one
another. This is the same way an operating system process works. The
separation is required so that applications do not affect one another.
This separation is achieved by making sure than any given unique
virtual address space runs exactly one application and scopes the
resources for the process or application domain using that address space.
What is the difference between ASP.NET and VB.NET?
ASP.Net is a program application with server controls with programmable objects, which can do the same job HTML did in the past. ASP.Net is used to build a Website and VB.Net is a computer language you use to build the site. Some use VB.Net and others use C# (C Sharp language) to build a website. Using ASP. Net and VB.Net or C# you can build an E-commerce store, which has multi functional capabilities. You can integrate PayPal or one of the other payment programs into your site. Create an Email system, speed up the applications by caching the pages and the data within the pages of your site and do a number of other things to successfully run an E- commerce store on the Internet.
ASP.Net is very successful Web application platform used by individuals and many large companies, who want to build and run their own websites. ASP.Net provides server controls with the ability to give you rich web content and more. Anyone willing to purchase the software and learn how to properly use this technology can use the tools, and application system to build a great Website. You can develop and build your own database choosing to use VB.net or C# language. Many websites today, which were built in the past used HTML language to build their websites.
How the garbage collector knows when to collect garbage ?
The garbage collector's optimizing engine determines the best time to perform a collection based upon the allocations being made. When the garbage collector performs a collection, it checks for objects in the managed heap that are no longer being used by the application and performs the necessary operations to reclaim their memory.
.NET and Java J2ee Design pattern interview question :- What is the difference between Template and Strategy pattern?
Below are the main differences between these two design patterns.
Template Design pattern
Defines outline for algorithms and allows sub class to override some steps.
Efficient in terms of less redundant code.
Depends on super class for methods.
Strategy Design pattern
Uses object composition to provide variety of algorithm implementation.
Flexible in terms of allowing users to change algorithm at run time.
All the algorithms can be itself implemented.
Do visit our .NET design pattern and Java J2EE design pattern interview questions.
What are merge modules?
Merge modules are a feature of Windows Installer that can be incorporated into the setup projects of various applications and used to perform operations like
installing assemblies in the GAC.Merge modules cannot be installed directly,
They are merged into an installer for each application that uses the component.
Merge modules contain a component such as a .dll along with any related files, resources, registry entries, and setup logic.
Which of these editors allows us to perform searches on the target machine for a Registry key or Windows Installer components?
NOTE: This is objective type question, Please click question title for correct answer.
What are listeners?
These are the classes used to collect the output of Tracing.
The listeners write the Tracing output which they collect to a number of devices.
3 Types of listeners are there:
1)TextWriterTraceListener
It allows us to write messages to an object of the TextWriter class.
2)EventLogTraceListener:
It allows us to write messages to EventLogs
3)DefaultTraceListener:
Allows us to send messages to Output Window.
They are defined by System.Diagnostics namespace
example:
Stream m = File.Create("dd.txt");
/*Create a TextWriterListener and then add it to the Listeners*/
TextWriterTraceListener t = new
TextWriterTraceListener(m);
Trace.Listeners.Add(t);
// Write output to the file.
Trace.Write("hello ");
On which of these locations, we cannot create a breakpoint?
NOTE: This is objective type question, Please click question title for correct answer.
Which debugging window can be used to view the variables in current and previous statements?
Autos Window is the debugging window that can be used in the condition
mentioned. When in break mode(use F10 key for that),Autos Window can be opened from the
Debug Menu-->Windows-->Autos
Difference between Globalization and Localization ?
Globalization refers to formatting data in formats relevant for the current culture setting.
example:
a)consider this tag in Web.Config file.
It would cause the dates to be displayed in French for the web page of
the folder where this Web.Config file is located.
b) CultureInfo d=new CultureInfo("de-DE");
Response.Write(DateTime.Now.ToString("D",d);
It would display date in long format using German culture
Localization refers to retrieving and displaying appropriately
localized data based on the culture.
It can be done by using the Resource files.
example:
we have 2 resource files:
a)default.aspx.fr-FR.resx
b)default.aspx.en-US.resx
Using appropriate coding in the .aspx.cs files of a web page, the strings written in these resource files can be used to change the text of the strings dynamically.
Which Constructor gets fired first Static or Non-Static while creating an object of a class?
Static constructor will be fired first.
Ex:
class Test{
public Test(){
Console.WriteLine(" public Test()");
}
static Test(){
Console.WriteLine(" static Test()");
}
}
class Program{
static void Main(string[] args){
Test test = new Test();
Console.Read();
}
}
Output:
static Test()
public Test()
More...
1. Weak named assemblies can be duplicated and tampered with, where as strong named assemblies cannot be tampered and duplicated.
2. Strong named assemblies can be copied into GAC(GLOBAL ASSEMBLY CACHE), where as weak named assemblies cannot be copied.
3. A single copy of strong named assembly present in the GAC(GLOBAL ASSEMBLY CACHE) can be shared with multiple applications, where as weak named assembly must be copied into the bin directory of each project.
What is an application domain?
An application domain is the CLR equivalent of an operation system’s
process. An application domain is used to isolate applications from one
another. This is the same way an operating system process works. The
separation is required so that applications do not affect one another.
This separation is achieved by making sure than any given unique
virtual address space runs exactly one application and scopes the
resources for the process or application domain using that address space.
What is the difference between ASP.NET and VB.NET?
ASP.Net is a program application with server controls with programmable objects, which can do the same job HTML did in the past. ASP.Net is used to build a Website and VB.Net is a computer language you use to build the site. Some use VB.Net and others use C# (C Sharp language) to build a website. Using ASP. Net and VB.Net or C# you can build an E-commerce store, which has multi functional capabilities. You can integrate PayPal or one of the other payment programs into your site. Create an Email system, speed up the applications by caching the pages and the data within the pages of your site and do a number of other things to successfully run an E- commerce store on the Internet.
ASP.Net is very successful Web application platform used by individuals and many large companies, who want to build and run their own websites. ASP.Net provides server controls with the ability to give you rich web content and more. Anyone willing to purchase the software and learn how to properly use this technology can use the tools, and application system to build a great Website. You can develop and build your own database choosing to use VB.net or C# language. Many websites today, which were built in the past used HTML language to build their websites.
How the garbage collector knows when to collect garbage ?
The garbage collector's optimizing engine determines the best time to perform a collection based upon the allocations being made. When the garbage collector performs a collection, it checks for objects in the managed heap that are no longer being used by the application and performs the necessary operations to reclaim their memory.
.NET and Java J2ee Design pattern interview question :- What is the difference between Template and Strategy pattern?
Below are the main differences between these two design patterns.
Template Design pattern
Defines outline for algorithms and allows sub class to override some steps.
Efficient in terms of less redundant code.
Depends on super class for methods.
Strategy Design pattern
Uses object composition to provide variety of algorithm implementation.
Flexible in terms of allowing users to change algorithm at run time.
All the algorithms can be itself implemented.
Do visit our .NET design pattern and Java J2EE design pattern interview questions.
What are merge modules?
Merge modules are a feature of Windows Installer that can be incorporated into the setup projects of various applications and used to perform operations like
installing assemblies in the GAC.Merge modules cannot be installed directly,
They are merged into an installer for each application that uses the component.
Merge modules contain a component such as a .dll along with any related files, resources, registry entries, and setup logic.
Which of these editors allows us to perform searches on the target machine for a Registry key or Windows Installer components?
NOTE: This is objective type question, Please click question title for correct answer.
What are listeners?
These are the classes used to collect the output of Tracing.
The listeners write the Tracing output which they collect to a number of devices.
3 Types of listeners are there:
1)TextWriterTraceListener
It allows us to write messages to an object of the TextWriter class.
2)EventLogTraceListener:
It allows us to write messages to EventLogs
3)DefaultTraceListener:
Allows us to send messages to Output Window.
They are defined by System.Diagnostics namespace
example:
Stream m = File.Create("dd.txt");
/*Create a TextWriterListener and then add it to the Listeners*/
TextWriterTraceListener t = new
TextWriterTraceListener(m);
Trace.Listeners.Add(t);
// Write output to the file.
Trace.Write("hello ");
On which of these locations, we cannot create a breakpoint?
NOTE: This is objective type question, Please click question title for correct answer.
Which debugging window can be used to view the variables in current and previous statements?
Autos Window is the debugging window that can be used in the condition
mentioned. When in break mode(use F10 key for that),Autos Window can be opened from the
Debug Menu-->Windows-->Autos
Difference between Globalization and Localization ?
Globalization refers to formatting data in formats relevant for the current culture setting.
example:
a)consider this tag in Web.Config file.
It would cause the dates to be displayed in French for the web page of
the folder where this Web.Config file is located.
b) CultureInfo d=new CultureInfo("de-DE");
Response.Write(DateTime.Now.ToString("D",d);
It would display date in long format using German culture
Localization refers to retrieving and displaying appropriately
localized data based on the culture.
It can be done by using the Resource files.
example:
we have 2 resource files:
a)default.aspx.fr-FR.resx
b)default.aspx.en-US.resx
Using appropriate coding in the .aspx.cs files of a web page, the strings written in these resource files can be used to change the text of the strings dynamically.
Which Constructor gets fired first Static or Non-Static while creating an object of a class?
Static constructor will be fired first.
Ex:
class Test{
public Test(){
Console.WriteLine(" public Test()");
}
static Test(){
Console.WriteLine(" static Test()");
}
}
class Program{
static void Main(string[] args){
Test test = new Test();
Console.Read();
}
}
Output:
static Test()
public Test()
More...
Siebel Process Properties Versus Siebel Property Sets
Posted Under
Siebel-Tutorials
Siebel Business Process Designer provides capabilities to store property sets as process properties. You can use process properties to pass property sets to and from business service steps. Such process properties have a data type of hierarchy, and can be used as input and output arguments for any business service method arguments that have a data type of hierarchy.
When you want to call a workflow as a business service, you can map the data contained in the input and output property sets to and from process properties. This is useful when you want to run a workflow within a script.
When a workflow process is started, any process properties of type string, number,or date will be initialized to the input property with the same name, if one exists. Any hierarchy process properties will be initialized with any child input property sets that have a matching name (type). Any process properties with their Default String set to "" will be initialized with the value in the Value field of the input property set.
When a workflow process completes, all process properties of type string, number, or date will be stored as properties in the output property set. Any hierarchy process properties will be stored as child property sets. If a process property with the name is defined, its value will be stored in the Value field of the output property set.
More...
When you want to call a workflow as a business service, you can map the data contained in the input and output property sets to and from process properties. This is useful when you want to run a workflow within a script.
When a workflow process is started, any process properties of type string, number,or date will be initialized to the input property with the same name, if one exists. Any hierarchy process properties will be initialized with any child input property sets that have a matching name (type). Any process properties with their Default String set to "
When a workflow process completes, all process properties of type string, number, or date will be stored as properties in the output property set. Any hierarchy process properties will be stored as child property sets. If a process property with the name
More...
January 17, 2012
Advanced .NET Interview Questions Answers Explanations
Posted Under
.NET Interview Questions,
Microsoft-Technologies-Interview
What's the advantage of using System.Text.StringBuilder over System.String?
StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it's being operated on, a new instance is created.
What's a satellite assembly?
When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.
What is the difference between the value-type variables and reference-type variables in terms of garbage collection?
The value-type variables are not garbage-collected, they just fall off the stack when they fall out of scope, the reference-type objects are picked up by GC when their references go null.
What's the difference between the Debug class and Trace class?
Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds
How does CAS work?
The CAS security policy revolves around two key concepts - code groups and permissions. Each .NET assembly is a member of a particular code group, and each code group is granted the permissions specified in a named permission set.
For example, using the default security policy, a control downloaded from a web site belongs to the 'Zone - Internet' code group, which adheres to the permissions defined by the 'Internet' named permission set. (Naturally the 'Internet' named permission set represents a very restrictive range of permissions.)
How does assembly versioning work?
Each assembly has a version number called the compatibility version. Also each reference to an assembly (from another assembly) includes both the name and version of the referenced assembly.The version number has four numeric parts (e.g. 5.5.2.33). Assemblies with either of the first two parts different are normally viewed as incompatible. If the first two parts are the same, but the third is different, the assemblies are deemed as 'maybe compatible'. If only the fourth part is different, the assemblies are deemed compatible. However, this is just the default guideline - it is the version policy that decides to what extent these rules are enforced. The version policy can be specified via the application configuration file.
Why string is called Immutable data Type?
The memory representation of string is an Array of Characters, So on re-assigning the new array of Char is formed & the start address is changed. Thus keeping the Old string in Memory for Garbage Collector to be disposed.
What is side-by-side execution? Can two application one using private assembly and other using Shared assembly be stated as a side-by-side executables?
Side-by-side execution is the ability to run multiple versions of an application or component on the same computer. You can have multiple versions of the common language runtime, and multiple versions of applications and components that use a version of the runtime, on the same computer at the same time. Since versioning is only applied to shared assemblies, and not to private assemblies, two application one using private assembly and one using shared assembly cannot be stated as side-by-side executables
Tell me a method to access a COM dll in .NET?
We can create a interop dll of COM to access in .NET
What is the class to access FTP?
FtpWebRequest
Can you please tell me about the typed dataset?
A typed dataset will be having the sehema with them as in an xml format.
It raises the compile time exceptions. Arranging data and giving relationship is possible through this.
How do we store the same named assemblies in GAC? Whether its possible?
Yes it is possible. By different versions of assembly we can store.
More...
Cross-selling functionality in Siebel
Posted Under
Siebel-Tutorials
Siebel Cross-selling functionality
The strategy of pushing new products to current customers based on their past purchases. Cross-selling is designed to widen the customer's reliance on the company and decrease the likelihood of the customer switching to a competitor.
When deciding whether to add an extension column to a base table or to use columns in an extension table, consider the following recommendations:
* Add extension columns to base tables when the data you need to store almost always exists for a given base record and it is accessed regularly. By avoiding the join used with an extension table, this approach often results in better performance. However, note that it can result in slower access to the base table if there is a lot of data (that is, many large fields have been added and they are always populated), because fewer rows now fit on one page.
NOTE: When an extension column will be regularly specified in user queries, it is likely to need an index on the column that may need to include other base table columns; and therefore should be added to the base table.
* Use columns in an extension table when a one-to-many extension fields are required, and the view displaying this data is accessed infrequently. In this case, the join is executed for the extension table, but only when this view is accessed.
* As a general rule, if you plan to display additional attributes in a list applet, add extension columns to the base table; if you plan to display additional attributes in a form applet, use extension table columns.
More...
The strategy of pushing new products to current customers based on their past purchases. Cross-selling is designed to widen the customer's reliance on the company and decrease the likelihood of the customer switching to a competitor.
When deciding whether to add an extension column to a base table or to use columns in an extension table, consider the following recommendations:
* Add extension columns to base tables when the data you need to store almost always exists for a given base record and it is accessed regularly. By avoiding the join used with an extension table, this approach often results in better performance. However, note that it can result in slower access to the base table if there is a lot of data (that is, many large fields have been added and they are always populated), because fewer rows now fit on one page.
NOTE: When an extension column will be regularly specified in user queries, it is likely to need an index on the column that may need to include other base table columns; and therefore should be added to the base table.
* Use columns in an extension table when a one-to-many extension fields are required, and the view displaying this data is accessed infrequently. In this case, the join is executed for the extension table, but only when this view is accessed.
* As a general rule, if you plan to display additional attributes in a list applet, add extension columns to the base table; if you plan to display additional attributes in a form applet, use extension table columns.
More...
January 16, 2012
Siebel Script for Email, FAX
Posted Under
Siebel-Tutorials
Code to Verify an Email Address
function VerifyEmail(Inputs, Outputs)
{
var sEmailAddr = Inputs.GetProperty("Address List")
var sInd = sEmailAddr.indexOf("@")
var sInd1 = sEmailAddr.indexOf(".")
var sInd2 = sEmailAddr.indexOf(" ")
if (sInd == -1 || sInd1 == -1 || sInd2 != -1)
{
Outputs.SetProperty("Status", "Failure");
Outputs.SetProperty("Address List", sEmailAddr);
}
else
{
Outputs.SetProperty("Status", "Success");
Outputs.SetProperty("Address List", sEmailAddr);
}
}
Code to Verify a FAX address
function VerifyFax(Inputs, Outputs)
{
var strFax = Inputs.GetProperty("Address List");
var strFaxURL;
if (strFax.length == 10)
{
strFaxURL = TheApplication().InvokeMethod("LookupValue", "MMF_CONTACT_FAX_ADDRURL", "FAX URL");
//strFax = "91" + strFax + "@fax.mmf.capital.ge.com"
strFax = "91" + strFax + strFaxURL;
Outputs.SetProperty("Status", "Success");
Outputs.SetProperty("Address List", strFax);
}
else
{
Outputs.SetProperty("Status", "Failure");
}
}
Code to Set Activity Due Date excluding Saturday and Sunday
function ActivityDueDate(iDate)
{
var retDate = new Date;
var Saturday = 6;
var Sunday = 0;
if (ToNumber(iDate) > 0)
{
retDate.setDate(retDate.getDate()+ ToNumber(iDate));
}
var sDay = retDate.getDay();
if (sDay == Sunday)
{
retDate.setDate(retDate.getDate()+ 1);
}
else if (sDay == Saturday)
{
retDate.setDate(retDate.getDate()+ 2);
}
var dDate = (retDate.getMonth()+1) + "/" + retDate.getDate() + "/" + retDate.getFullYear() + " 06:00:00";
return (dDate);
}
Code for Required * Image
More...
January 15, 2012
Generating SQL output from the Siebel client application
Posted Under
Siebel-Tutorials
Generate Log , SQL in Siebel.
In the command line for your Siebel application startup, use the /s filename
option. This will begin spooling all of the SQL that Siebel generates to an
output file named filename. If filename does not include an absolute path, it is
placed in the Siebel bin directory. If you are not familiar with the SQL output,
you may want to run Siebel once, up to the point of executing action with poor
performance, but not actually performing the action. Then exit and save the
output file. Restart the Siebel client and follow the same process, except that
you should execute the poor performance action this time and then exit
Siebel.
The difference between the output files is the SQL with poor performance.
Often this will consist of multiple SQL statements, although frequently it is
only one of the statements actually causing the poor performance. If several
statements are included for the action with poor performance, perform your
tests using all of them until you are able to isolate the ones causing the
problem.
In order to run the generated SQL through db2batch, you will need to edit the
output file to select just the desired portion of code.
In addition, you can use DB2 Event Monitor to get a summary of activity at the
completion of events such as statement execution, transaction completion, or
when an application disconnects.This is applicable for the thick clients only.
More...
In the command line for your Siebel application startup, use the /s filename
option. This will begin spooling all of the SQL that Siebel generates to an
output file named filename. If filename does not include an absolute path, it is
placed in the Siebel bin directory. If you are not familiar with the SQL output,
you may want to run Siebel once, up to the point of executing action with poor
performance, but not actually performing the action. Then exit and save the
output file. Restart the Siebel client and follow the same process, except that
you should execute the poor performance action this time and then exit
Siebel.
The difference between the output files is the SQL with poor performance.
Often this will consist of multiple SQL statements, although frequently it is
only one of the statements actually causing the poor performance. If several
statements are included for the action with poor performance, perform your
tests using all of them until you are able to isolate the ones causing the
problem.
In order to run the generated SQL through db2batch, you will need to edit the
output file to select just the desired portion of code.
In addition, you can use DB2 Event Monitor to get a summary of activity at the
completion of events such as statement execution, transaction completion, or
when an application disconnects.This is applicable for the thick clients only.
More...
January 14, 2012
Setting Explicit Primary Mappings Siebel
Posted Under
Siebel-Tutorials
Setting Explicit Primary Mappings
Primary foreign keys are columns that have names usually beginning with PR_ and are defined as primaries in the data model.
Case 1: One-to-many relationship (S_ORG_EXT with S_ADDR_ORG with 1:M relationship)
Ex: PR_ADDR_ID in S_ORG_EXT identifies the primary address for this account.
In above case, as both the parent table (S_ORG_EXT) and the primary child table (S_ADDR_ORG) of a primary foreign key are mapped to the same EIM table EIM_ACCOUNT, explicit primary mapping is available for this primary foreign key under the table mapping of the primary child table.
It is necessary to have both the parent and the primary child table mapped to the same EIM table for explicit primary mapping.
As an explicit primary mapping exists, same EIM process can be used to set the primary explicitly during import or update by setting the primary flag column in the EIM table.
Case 1: Many-to-Many relationship (S_OPTY with S_CONTACT with M:M relationship)
When setting a primary key for a many-to-many relationship, such as the relationship between Opportunities and Contacts, there is also an intersection table S_OPTY_CON.
This can be worked in steps. One way is -
Step 1 - Import into S_CONTACT using EIM_CONTACT.
Step 2 - Use EIM_OPTY to import into S_OPTY and the intersection table S_OPTY_CON, and explicitly set the primary S_OPTY.PR_CON_ID during this process.
The explicit primary mapping for S_OPTY.PR_CON_ID is under the table mapping of its primary child table, that is, S_OPTY_CON.
Explicit primary mapping for setting S_OPTY.PR_CON_ID would not found as S_CONTACT is not mapped in EIM_OPTY.
More...
Primary foreign keys are columns that have names usually beginning with PR_ and are defined as primaries in the data model.
Case 1: One-to-many relationship (S_ORG_EXT with S_ADDR_ORG with 1:M relationship)
Ex: PR_ADDR_ID in S_ORG_EXT identifies the primary address for this account.
In above case, as both the parent table (S_ORG_EXT) and the primary child table (S_ADDR_ORG) of a primary foreign key are mapped to the same EIM table EIM_ACCOUNT, explicit primary mapping is available for this primary foreign key under the table mapping of the primary child table.
It is necessary to have both the parent and the primary child table mapped to the same EIM table for explicit primary mapping.
As an explicit primary mapping exists, same EIM process can be used to set the primary explicitly during import or update by setting the primary flag column in the EIM table.
Case 1: Many-to-Many relationship (S_OPTY with S_CONTACT with M:M relationship)
When setting a primary key for a many-to-many relationship, such as the relationship between Opportunities and Contacts, there is also an intersection table S_OPTY_CON.
This can be worked in steps. One way is -
Step 1 - Import into S_CONTACT using EIM_CONTACT.
Step 2 - Use EIM_OPTY to import into S_OPTY and the intersection table S_OPTY_CON, and explicitly set the primary S_OPTY.PR_CON_ID during this process.
The explicit primary mapping for S_OPTY.PR_CON_ID is under the table mapping of its primary child table, that is, S_OPTY_CON.
Explicit primary mapping for setting S_OPTY.PR_CON_ID would not found as S_CONTACT is not mapped in EIM_OPTY.
More...
January 13, 2012
How to update the LastUpdated date when associating a record in MVG?
Posted Under
Siebel-Tutorials
In Siebel , How to update the LastUpdated date when associating a record in MVG?
If you associate a new record in MVG field (i.e. if associating an account to a contact) the last updated field is not updated for the contact.
Hence, it is difficult to know who is associated with the account.
The updated field is only changed if the Primary account is changed.
The solution is simple. Just write a server script in event WebApplet_InvokeMethod in the applet, which is invoked.
In this case, it is Account Mvg Applet. Here is the code
Sub WebApplet_InvokeMethod (MethodName As String)
if MethodName = "NewRecord" Then
Dim ActiveBusComp As BusComp
Dim parentBC As BusComp
Set ActiveBusComp=me.BusComp
Set parentBC = ActiveBusComp.ParentBusComp
If parentBC.Name="Contact" Then
OldValue = parentBC.GetFieldValue("Comment")
If len(OldValue)=0 Then
dateTime=date()
OldValue=" Account Association was added for this contact on :" & dateTime
End If
parentBC.SetFieldValue "Comment", "blah"
parentBC.WriteRecord
parentBC.SetFieldValue "Comment", OldValue
parentBC.WriteRecord
Set parentBC=Nothing
End If
End Sub
More...
If you associate a new record in MVG field (i.e. if associating an account to a contact) the last updated field is not updated for the contact.
Hence, it is difficult to know who is associated with the account.
The updated field is only changed if the Primary account is changed.
The solution is simple. Just write a server script in event WebApplet_InvokeMethod in the applet, which is invoked.
In this case, it is Account Mvg Applet. Here is the code
Sub WebApplet_InvokeMethod (MethodName As String)
if MethodName = "NewRecord" Then
Dim ActiveBusComp As BusComp
Dim parentBC As BusComp
Set ActiveBusComp=me.BusComp
Set parentBC = ActiveBusComp.ParentBusComp
If parentBC.Name="Contact" Then
OldValue = parentBC.GetFieldValue("Comment")
If len(OldValue)=0 Then
dateTime=date()
OldValue=" Account Association was added for this contact on :" & dateTime
End If
parentBC.SetFieldValue "Comment", "blah"
parentBC.WriteRecord
parentBC.SetFieldValue "Comment", OldValue
parentBC.WriteRecord
Set parentBC=Nothing
End If
End Sub
More...
January 12, 2012
BizTalk Server Interview Question Answers Collection
Posted Under
Biztalk Interview Questions,
Sitemaps
Largest Collection of BizTalk Server Interview Question Answers
More...
- Biztalk Job Interview Question Answers
- Common Biztalk Interview Questions asked in a Job Interview
- 110 Biztalk Interview Question Answers
- Frequently asked BizTalk Server Interview Question Answers
- Most Asked BizTalk Server Interview Question in Companies
- Design Architecture BizTalk Server Interview Question Answers
- BizTalk Server Interview Question Answers on BAM and Deployment
- BizTalk Server Interview Question Answers on Pipelines and Adapters
- BizTalk Server Interview Question Answers on Orchestrations
- BizTalk Server Interview Question Answers
- Basic BizTalk Interview questions
More...
December 12, 2011
Siebel Tutorials Collection
Posted Under
Siebel-Tutorials
December 9, 2011
Siebel Access Control, Views and Data
Posted Under
Siebel-Tutorials
Access Control + Views + Data
Mechanisms used to control user access to views + data records in Siebel
- Two (only) Types of Access Control
- View-level Access Control: controls access to views (based on job function/role)
- Responsibility:
- Determines set of views to which a user has access (based on job role)
- Views can be under more than one responsibility (different responsibility. Can share a common set of views)
- User can have more than one responsibility (after logging-in, user sees “union” of all views available to them)
- If a user does not have a view, he/she will not see a reference in:
- Site map
- Show drop-down list
- Detail tabs
- If user does not have access to any views in a screen:
- Screen tab is not displayed
- Screen will not appear in the Site map
- Data-level Access Control: Controls user access to data records
**types are not mutually exclusive.. can be restricted by more than one**
- Types of Data (not interface or repository data)
- Customer Data :
- Includes dynamic, transactional data such as Accounts, Optys, Orders; Created + Managed by users of App; Access controlled at record level
- Master Data
- Includes static, referential data such as products + literature
- Created + maintained by admins
- Grouped into Catalogs + categories (which control access)
- Three ways to control:
- Personal Access Control
- Limited to records that a user has created or to which a user has been assigned (user id restricted)
- Position-based Access Control
- Limited to users based on their position within an organization (I.e. Arlington Hotel position for Marriott receives all Reservations -- Opportunities -- for that territory)
- People may change, but position is static
- Some positions have single EE (i.e. CEO) ; Some have Multiple (i.e. Sales group) à in later case there is a primary EE
- Primary Employee: only this person’s name appears in a record’s team field
- EEs can have M positions; has a primary position that is the default when logging in;
- Since users can only log in as one position at a time, they may “Change Postions” while in an active session
- SINGLE vs. TEAM access control:
- (1) Single Position Access Control: only one position can be assigned to record; all users with that position have access to the record
- (2) Team Access Control: allows multiple positions to be assigned to a single record; all users associated with both positions have access
- E.g. Opportunities View, Contacts View, Accounts View
- Every team has one position designated as primary for each record, but default is person who creates record, that person can change the primary (or an Admin or AM)
- Organization-based Access Control
- Limited to organization to which a user’s positions are assigned
- Provides another level at the business organization level
- User belongs to one organization at a time
- Allows you to partition company into logical groups
- Types:
- Single Organization: assigns single org to record
- Multiple Organization: assigns multiple orgs to individual record (similar to multiple positions)
More...
December 8, 2011
Steps in Installing Siebel in a windows/unix box
Posted Under
Siebel-Tutorials
Installing Siebel Software
· Installation Documentation:
o System Requirements + Supported Platforms
o Release Notes
o Server Installation Guide
o Web Client Administration Guide
· Steps:
o Prepare for Installation
§ Verify prerequisites
· Supported HW, Supported OS, Required Third-party SW
§ ID which SW on which machines
· Fast Ethernet between SS + DB Server
§ What Naming conventions should be used? (i.e. GW1, D1, S1, W1)
§ What Directory Structures should be used?
§ Siebel Service Owner Account/OS Account
· Need Siebel Service Owner account for
§ Siebel Monitoring Account for Resonate
§ RDBMS Account(s)
§ Install RDBMS + Create Siebel Database
· Empty database/tablespace with mim requirements based on your project’s sizing
· Oracle, DB2, SQLServer
§ Create File System
· Must be accessible from machines running ES + Clients
· Must support long and case-sensitive filenames
o Install + Verify Siebel Software
§ Install Gateway Server
· May install on M machines in high-availability environment
· Verify by viewing directory + log files + seeing that NT/UNIX process is running
§ Install
· Run
· Must specify name of a SINGLE database
§ Install Siebel Server
· Inspect SESsetup.log; verify NT/UNIX process is running for each SS
§ Install Database Server
· Run install.ksh
· Run grantusr.sql
o Creates default users (Siebel)
· Table owner = SIEBEL
· Verify: log files + db connectivity + schema + seed data + repository data
§ Siebel Web Server Extensions
· Install WebServer
· Install SWSE (eappweb.exe install program)
· Inspect virtual diectories
§ Third-party products
o Post Installation
§ Verify Client
§ License Keys
· Entered using tools
· Can hide by:
o Hide Admin View
Remove Button in ToolsMore...
Subscribe to:
Posts (Atom)