WebSphere Commerce interview questions collections

Q1 ) what is the difference between the controller command and task command.

        ANS : Generally controller command is the main command which we used to call from the JSP to process the request, But task command is used to perform some specific task like for inventory check, price check, these are handled through task commands, so task command are command which perform specific task for controller command. DIFFERENCE - By the above statement we can visualize that Controller command is required to be configure in the struts file, but task command is not required to be configured in struts, rest everything is same in both.

Q2) What is ObjectNotFoundException and FinderException ?

        ANS : ObjectNotFoundException is the subclass of FinderExcepton, So when the AccessBean finder method  return empty row, we get ObjectNotFoundException, but as generally we throw FinderException in EJB, so ObjectNotFoundException is catched in FinderException and thrown.

Q3) Difference Between Products and Items?

          Products : Product is a group of items which exhibit same attributes. we can say Shirt is a products, but a shirt of red color of size 44 is a item. So it is clear in this example that there are two attributes size and color which belong to this item. And we can also say , that items belong to a particular product exhibit the same set of attributes.

Items : As Info center says - An item is a tangible unit of merchandise that has a specific name, part number,size and price. For example, a 44 size shirt with red color is an item for the above item.

Actually it is not required to associate Item with Products, In Commerce we do so to maintain a consistent view, by doing this we are able to easily manage the items through Product Management Tool in WebSphere commerce server.

So It is clear now that Product is not a physical entity which we can purchase, but it is Item which we potentially purchase and add to cart.

The relationship between Product and Item is modeled in CATENTREL table.

______________________________________________________________ 

Actually we are following a generic navigation technique in the site

[ROOT CATEGORY]  --->[PARENT CATGEORY] ---> [CHILD CATEGORY] ---> [PRODUCT] ---> [ITEMS]

Below are some of the important tables through which we can get the details of the item which we are going to purchase:

CATENTREL = has the relationship on the parent catentry[PRODUCTS] and child catentry[Items].

CATGPENREL = has the information on the target catalog entry with the catalog and category.i.e;

the item belong to which category and catalog.

CATGRPREL = has the information on the relationship between the CATEGORY or CATGROUP, like it says which is parent and which is child. 

CATTOGRP = has the information on relationship of CATALOG_ID and ROOT CATGROUP [category]

NOTE: Categoy and catgroup are synonyms in commerce

STORECAT = has relationship on store with catalog and also says that whether the catalog which is referenced to the stores is master catalog or not. 

Q4) Difference between different types of DataBean?
Q5) What is EJB copyHelper?
Q6) General difference between B2B and B2C shopping flow?
Q7) General difference between B2B and B2C shopping flow in mobile?
Q8) important jsp tags in WCS.
Q9) How can we create a site for multilingual sites?
Q9) Difference between well formed and well managed xmls?
Q10) Access Control Policy Tables and their relation.
Q11) How commerce is picking up different struts file from the project?
Q12) Is it mandatory to mention the struts file in web.xml?
Q13) What is reload interval? where do we configure reload interval?

        ANS : WC_eardir\Stores.war\WEB-INF\ibm-web-ext.xml -- change reload-interval

                   reload interval is generally used at the time when we are doing caching. if we make the relaod-interval to 10 then  the jsp  compilation interval will be 10 sec.

Possible interview questions:

1. Tell me about yourself?

2. For which company you are doing your WCS project?

3. Can you tell me about current project?

4. Can you tell the about your project in technical way?

5. What are your modules in your project? How many subsystems you deal with in your project?

6. Can you explain about Order Management Subsystem, which you developed in your project?

7. What are the control commands you have worked in order management?

8. Can you list out the some of the control commands, which created your own by using existing control commands?

9. What is the need to create your own commands by using existing owns? Tell me main purpose to create your own commands?

10. Tell me the code that you have written in your controller command?

11. Can you tell me about another subsystem that is Member subsystem?

12. What you have done with member subsystem?

13. Do you know about customizing the accelerator?

14. How can you create the Admin User in Organization Console?

15. Can you explain about ACP control policies? How can you execute the ACPcontrol policies?

16. Suppose one user login into our site. He selected some of items and he has given the order. After two months, how can you check the status of the Order?

17. Are you comfortable with SQL Queries?

18. I want to collect user email id’s whose email id ends with @and particular company name.com. Then how can you give SQL query to Database in WCS?

19. I want to know the particular member _id. Then tell me the relation between MEMBER table with ORDER table.

20. What is your production system?

21. Are you comfortable with Unix and AIX System?

22. What is the coding that you have developed?

23. What kind of tables did you use?

24. Setting up the staging server?

25. Migration from WCS 5.1 to WCS 5.6

26. About JSTL?

27. Did you use both JSTL and Scriptlets in the JSP’s that you have developed?

28. What kind of caching did you use for your JSP’s?

29. Do you know about Dynacache?

30. About CSS and its importance?

31. What is a task command?

32. How do you call a task command from a controller command? And what is the syntax?

33. How many types of promotions?

34. How can you apply promotions to your catalog products?

35. Explain about total flow of Task Command Execution?

36. For creating a Controller Command, we register Controller Command into CMDREG table? Is it necessary to register in that table? What is the main purpose to register in CMDREG table?

37. For Forget password how can you tell that password to user? Tell me the total scenario about that?

38. Have you done any subsystems in your project? What are they?

39. Can you tell me the scenario for status of a particular product in Order Management? And what are the tables you used in this scenario?

40. Can you list out some of the Controller Commands for giving the promotions to products, which you have been used? And explain the scenario?

41. Can you explain the some of the Controller Commands for Order Management, which you have been used in your project? And also explain related tables?

42. Have you created your own tables in your project? And List out them?

43. Can you list out the tag libraries in WCS?

44. What is the purpose to use fmt tag library in WCS?

45. How can you do Internationalization in WCS using fmt tag library? Tell me total flow of execution? What are the files to modify for that purpose?

46. How can you take shipping address and billing address from customer? Explain?

47. Are you familiar with Views and commands in WCS?

48. What are different models in WCS and use of the models?

49. Do you know about .sar files?

50. What is the use of SAR file?

51. What is the difference between Data Bean and Access Bean?

52. Can we use Access Bean in JSP page?

53. What is the use of Access Bean?

54. Why can’t we use an Entity Bean without using an Access Bean?

55. What are the Types of Data Beans?

56. Explain about the types of Data Beans?

57. Why do we use properties files?

58. What are the types of properties files in WCS?

59. When we insert a JSP page in the WCS what do we need to do?

60. How do we use our Data Bean in our JSP?

61. Can you tell me the attributes used in UseBean tag?

62. What is the difference between Include and import of a JSP page?

63. How do you call JSP’s?

64. How do you call a controller cmd from the JSP?

65. What is the need of the Data Bean in the JSP?

66. How to create a Controller command?

67. Do you know about B2B and Extended sites?

68. Can you tell me about extended sites? How they are used?

69. Is there any extra plug-ins should we use for creating Extended sites?

70. Before being a WebSphere commerce consultant what are the other projects did you work?

71. In what version of Commerce did you work?

72. Do you know about multi-channel in WCS?

73. How to stop caching jsp at run time?

74. What are the Controller commands using in ordering an item?

75. Elements in Access control policy?

76. How do we use this policy file? How to run this policy file in remote database?

77. What are table you worked on while working access control policy?

78. How to enable Dyna caching?

79. What is Difference between http and https?

80. What are the ways to call data bean in jsp?

81. What is Command Context?

82. Difference between B2C and B2B?

83. Can we use Access Bean in JSP page?

84. What is Store Access Bean?

85. What is the request flow in WCS?

86. Tell me about trading subsystem?

87. How will you create a controller command and what are the methods in Controller Command?

88. What is the use of the isGeneric ()?

89. How do you switch to the database Oracle9i in WCS?

90. How will retrieve data from three or more tables in your program in WCS?

91. Tell the steps that you will follow when an error occurs at the time of staging your project on the stating server?

92. Does batch process come under WCS or testing (this was posted after I explained him about the batch process is all that I create a batch file and test it as a customer)?

93. Explain some thing about display pages (after I explained him about the catalogs)?

94. Tell me something about OPT COUNTER?

95. Tell me something about asset store?

96. About search engine optimization?

97. Functional architecture?

98. Struts usage?

99. Can u call multiple control commands?

100. Explain you role in maintenance of commerce application & fixing bugs?

101. How can we customize the catalog?

102. Installation, Administration, Application Deployment, Problem determination & performance tuning WebSphere commerce suite?

103. What is the difference between a site and a store?

104. What do you mean by Asset Store?

105. What is the use of entity bean?

106. What do you mean by Optimistic Locking and what is its purpose?

107. What loading utilities have u worked with (in my second project)?

108. Have you implemented Web Services in your module?

109. What is a session bean?

110. What is the necessity going for session bean rather than access bean?

111. Which method is invoked in the data bean for calling an access bean?

112. Relation between three types of beans in WCS? (Data Bean, Access Bean, and Entity Bean)

113. Did you work on sales center?

114. Had you wrote any triggers and procedures in your Database?

115. Have you worked on Helper Classes?

116. What is the role of helper classes in WCS?

117. Is there any relation between helper classes and entity beans?

118. Can we call a task command directly? If ‘yes’ how we can call? If ‘no’ what is the reason?

119. By using primary key of the product and user id how can you retrieve the information from the database?

120. Tell me what are the changes you did in jsp?

121. How do you create Access Bean?

122. What is migration? How you have done that?

123. What is Migration Wizard and what are the advantages associated with Migration Wizard?

124. What are Loading Utilities? What is the use of that?

125. Real Time scenarios:

126. Assume that there are three stores (These three are of same stores i.e. whether they may be B2C, B2B etc. But all should belong to the same model). These three stores are differing in Functional aspects? Then it’s possible to use the same ControllerCmd or TaskCmd in all the three stores? We have to support that with a Real Time example?

127. In a Jsp if a developer inserts three fields and when the client used it, how will the data be loaded into the database?

128. What are Business Logic Facade and Business Context Services in Commerce Server?

129. What is Pick Packer and what actually it means?

130. For what purpose we are using the fulfillment centers? Can a store have multiple fulfillment centers?

131. How do you handle the Service Tickets that are received from the clients?

132. Have you done the payment module? Can you tell something about that?

133. How can we assign the roles to the users?

134. How you added products to sales catalog? How you added the new products to an existing catalog?

135. Did you created any E-marketing Spots? What are steps involved in creating an E-marketing spot? In what situation you have created that?

136. Did you involved in writing of any JavaScript’s for Front-End Validations?

137. Is it possible to retrieve the data from the Access bean to a JSP page?

138. What is the difference between the versions?

139. Have you worked on customization of storefront? If yes then what did you customize?

140. What are the steps involved in displaying a new product on a JSP? What are the different kinds of administrative things in WebSphere Commerce? When you add a column into the database table what changes do you need to make in your code and accelerator? Why do we use JSTLEnvironmentSetup.jspf in a jsp?

141. Do you have an idea of the Database model in Commerce? Have you ever been involved in dealing with the DB2 database in Commerce? If yes, please specify what tables you deal with and why?

142. What is guided selling?

143. Where do you write business logic in WCS?

144. What is view command?

145. What is master catalog?