MA Placement Paper : Aptitude - General
MA Placement Paper : Technical - Java - 17 January 2004
COMPANY NAME : MANHATTAN ASSOCIATES
------------------------------------------------------------
DATE OF TEST : 17 Jan 2004
------------------------------------------------------------
PLACE OF TEST: Le Meridian hotel, Chennai
------------------------------------------------------------
MODE : Off-Campus
------------------------------------------------------------
DURATION : 50 Questions in 1.5 Hours of Time)
------------------------------------------------------------
CATEGORY : JAVA - J2EE (2+ years experienced category)
----------------------------------------------------
MANHATTAN ASSOCIATES:
About the Company:
The company is in ITPL, Bangalore. And around 200 people strong in India. The whole company is around 1000 people strong world-wide. It,s a product based company and dealing mostly with Supply-Chain management and Data Warehousing.
Visit Company WebSite at : www.manh.com
How I applied:
2 weeks back, there was an advertisement in "The Hindu-Opportunities" asking for 2 + years of Java, J2EE experience. I sent my resume to the given mail ID. Only selected people are called for written test.
----------------------------------------------------
----------------------------------------------------
TEST PAPER AND INTERVIEW PATTERN:
----------------------------------------------------
There are 4 rounds:
Written Test
Technical Interview
CEO interview
HR interview
The Written test pattern:
50 Questions -- 1.5 hours of time.
Most of the questions are multiple choice.
The split up is :
EJB (10 Questions)
JAVA (20 Questions)
JSP (5 Questions)
MISLLENEOUS - XML, JDBC etc (5 Questions)
ANALYTICAL (5 Questions)
SQL (5 Questions)
Our written test is held on 17 Jan 2004 in Le Meridian hotel, Chennai.
I have written down whatever questions I remember so that it will be useful to those who will be taking the test in future and also for those appearing for J2EE interviews.
I have given the questions in Written Test and Technical Interview.
I didn,t have the other interviews.
EJB
1) What is true about ,Primary Key class, in Entity Beans ?
(a) Used to identify the entity bean based on EJB type, Home Interface and Container Context.
(b) Used to identify the entity bean based on EJB type, Remote Interface and Container Context.
(c) The definition of Primary Key class can be deferred till deployment
2) The Home Interface in Entity beans
(a) Provides at least one create() method
(b) May not provide any create() method
(c) Provides at least one findByPrimaryKey() method
(d) May not provide any findByPrimaryKey() method
3) In CMP of Entity beans
(a) Constructor with no arguments is defined
(b) Constructor is not defined
4) What is the purpose of ejbLoad()
5) What is the purpose of ejbStore()
6) In EJB, when a system error occurs, which exception is thrown ?
(a) EJBException
(b) RemoteException
7) In EJB, which of the following is an application level Exception ?
(a) NullPointerException
(b) ArrayOutOfBoundsException
(c) CreateException
(d) ObjectNotFoundException
(e) All the above
(f) None of the above
8) CMP bean provides
(a) Empty implementation of ejbLoad() and ejbStore()
(a) Concrete implementation of ejbLoad() and ejbStore()
----------------------------------------------------
JSP and Mislleneous
----------------------------------------------------
1) What is the purpose of XSL
(a) Convert XML to HTML
(b) Convert HTML to XML
ANS: (a)
2) resultSet has the following methods
(a) next()
(b) first()
(c) a & b
(d) No methods
3) In WebLogic clusters, what is the load balancing algorithm ?
(a) RoundRobin
(b) FIFO
(c) LIFO
ANS: (a)
WebLogic uses a Round-Robin strategy as default algorithm for forwarding the HTTP requests inside a cluster. Weight-based and random algorithms are also available.
4) How many Queues does a MDB listen to ?
(a) 1
(b) 2
(c) Any Number
(d) 10
ANS: (a)
An MDB can be associated with only one Queue or Topic
5) Where is the Deployment Descriptor placed ?
(a) WEB-INF directory
(b) WEB-INF/CLASSES directory
(c) It will be mentioned in CLASSPATH
(d) The place can be specified in APPLICATION.xml
6) To denote distributed applications, What is the tag used in Deployment Descriptor ?
(a) distributable
(d) distributed="true"
(c) both a & b
7) Can a JSP be converted to SERVLET and the vice versa always ?
(a) YES
(b) NO
8) Empty JSP Tag definitions are given in Deployment Descriptor. Then which of the following syntaxes are correct ?
(I don,t remember the options)
9) One small question on <jsp:useBean> tag
----------------------------------------------------
JAVA
----------------------------------------------------
1) Which of the following 2 methods executes faster ?
class Trial {
String _member;
void method1() {
for(int i=0;i<2048;i++) {
_member += "test";
}
}
void method2() {
String temp;
for(int i=0;i<2048;i++) {
temp += "test";
}
_member = temp;
}
}
(a) method1()
(b) method2()
(c) Both method1() and method2() takes same time for execution
ANS: (b)
Accessing method variables requires less overhead than accessing class variables.
2) Integer.parseInt("12a") returns
(a) Exception
(b) 1
(c) 0
(d) -1
ANS: (a)
3) By default, Strings to functions are passed using the method
(a) Call by Value
(b) Call by Reference
(c) Strings cannot be passed to function
ANS: (b)
String is a class defined in java.lang and in java all classes are passed by reference.
4) What is the difference between OVERRIDING and OVERLOADING
5) What is the output of following program ?
class Test {
public static void main(String args[]) {
for(int i=0;i<2;i++) {
System.out.println(i--);
}
}
}
(a) Goes into infinite loop
(b) 0,1
(c) 0,1,2
(d) None
ANS: (a)
6) ,t, is the reference to a class that extends THREAD. Then how to suspend the execution of this thread ?
(a) t.yield()
(b) yield(t)
(c) yield()
(d) yield(100) where 100 is the milli seconds of time
7) What is the functionality of instanceOf() ?
8) How many String objects are created by the following statements ?
String str = " a+b=10 ";
trim(str)
str.replace(+,-);
(a) 1
(b) 2
(c) 3
(d) 4
ANS: (c)
Strings are immutable. So, for each String operation, one new object is generated.
9) (A program is given. I don,t remember exactly)
An ABSTRACT class is declared and the code is tried to instantiate it. The Question was whether it,s legal to do it or not ?
10) A question on "interface"
11) Cleaning operation in Java is done in the method
(a) finally()
(b) finalize()
(c) final()
12) Question on whether Static method can be overriden
13) How to prevent a class from being the Base Class ?
(a) declare it as final
(b) declare it as static
14) If we want to read a very big text file with so many mega bytes of data, what shall we use ?
(a) FileInputStream
(b) InputStreamReader
(c) BufferedReader
15) One Question on Inner Classes.
16) One program on Overloading and Overriding
17) A program given using try, catch and finally and it is asked to find out which statements get executed ?
18) What code, if written, below the (//code here) will display 0.
class Test {
public static void main(String argv[]) {
int i=0;
//code here
}
}
(a) System.out.println(i++)
(b) System.out.println(i+,0,)
(c) System.out.println(i--)
(d) System.out.println(i)
ANS: (a),(c),(d)
The option (b) displays the ASCII value of ,0,. So, the output in this case is: 48
19) What is the better way of writing the Constructor with 2 parameters in the following code:
class Test {
int x,y;
Test(int a) {
//Code for very complex operations will be written
//in this place
x=a;
}
Test(int a, int b) {
//Code for very complex operations will be written
//in this place (same code as in above constructor)
x=a;
y=b;
}
}
----------------------------------------------------
SQL
----------------------------------------------------
2 Table Structures are given. (Something like Employee ID, Salary, Department etc)
And there are 3 queries. I remember one query.
Write query to find the employees with top 5 salaries ?
And there 2 more theoritical SQL questions
1) What is the difference between UNION and UNION ALL ?
2) What is the difference between COMMIT and ROLLBACK ?
----------------------------------------------------
ANALYTICAL
----------------------------------------------------
5 very easy Questions. Need not bother much about it.
----------------------------------------------------
TECHNICAL INTERVIEW
----------------------------------------------------
1) Tell about yourself
2) Why do you want to leave the present company ?
3) What do you know about our (Manhattan Associates) company ?
4) About EJB types. CMP, BMP, Session, Entity beans, their differences, when to use what type of beans ?
5) Can a Client Context call ejbRemove() method ?
6) Who calls the methods ejbLoad() and ejbStore() and where the state information is stored when they are called ?
7) Do you know about Sequence Diagrams in UML ?
8) Which is faster in execution - JSP or SERVLET ? Why ?
9) What is the difference between Callable Statement and Prepared Statement?
10) Can we declare final method in abstract class ?
11) Can we declare abstract method in final class ?
12) What is the difference between Inner Join and Outer Join ?
13) How can you pass an object of data from one JSP to another JSP ?
ANS: Using Session or request.getParameter() or Hidden Variables.
14) When these methods are used ? ejbActivate(), ejbPassivate() and ejbRemove() ?
15) What is the difference between ejbPassivate() and ejbRemove() ?
16) Can the same object of Stateless Session bean be shared by multiple clients ?
17) Can the same object of Stateful Session bean be shared by multiple clients ?
18) How do you manage transactions in EJB ?
19) What is the difference between response.redirect() and forward and request dispatcher ? Which is faster ?
20) In java, which has more wider scope ? Default or Private ?
MA Placement Paper : General - other Chennai - 17 January 2004
MANHATTAN PAPER - EXPERIENCED - 17 JAN 2004 - CHENNAI
MANHATTAN ASSOCIATES:
The company is in ITPL, Bangalore. And around 200 people strong in India. The whole company is around 1000 people strong world-wide. It,s a product based company and dealing mostly with Supply-Chain management and Data Warehousing.
How I applied:
2 weeks back, there was an advertisement in "The Hindu-Opportunities" asking for 2 + years of Java, J2EE experience. I sent my resume to the given mail ID. Only selected people are called for written test.
TEST PAPER AND INTERVIEW PATTERN:
There are 4 rounds:
Written Test
Technical Interview
CEO interview
HR interview
The Written test pattern:
50 Questions -- 1.5 hours of time.
Most of the questions are multiple choice.
The split up is :
EJB (10 Questions)
JAVA (20 Questions)
JSP (5 Questions)
MISLLENEOUS - XML, JDBC etc (5 Questions)
ANALYTICAL (5 Questions)
SQL (5 Questions)
Our written test is held on 17 Jan 2004 in Le Meridian hotel, Chennai.
I have written down whatever questions I remember so that it will be useful to those who will be taking the test in future and also for those appearing for J2EE interviews.
I have given the questions in Written Test and Technical Interview.
I didn,t have the other interviews.
EJB
--------
1) What is true about ,Primary Key class, in Entity Beans ?
(a) Used to identify the entity bean based on EJB type, Home Interface and Container Context.
(b) Used to identify the entity bean based on EJB type, Remote Interface and Container Context.
(c) The definition of Primary Key class can be deferred till deployment
2) The Home Interface in Entity beans
(a) Provides at least one create() method
(b) May not provide any create() method
(c) Provides at least one findByPrimaryKey() method
(d) May not provide any findByPrimaryKey() method
3) In CMP of Entity beans
(a) Constructor with no arguments is defined
(b) Constructor is not defined
4) What is the purpose of ejbLoad()
5) What is the purpose of ejbStore()
6) In EJB, when a system error occurs, which exception is thrown ?
(a) EJBException
(b) RemoteException
7) In EJB, which of the following is an application level Exception ?
(a) NullPointerException
(b) ArrayOutOfBoundsException
(c) CreateException
(d) ObjectNotFoundException
(e) All the above
(f) None of the above
8) CMP bean provides
(a) Empty implementation of ejbLoad() and ejbStore()
(a) Concrete implementation of ejbLoad() and ejbStore()
JSP and Mislleneous
--------------------------------
1) What is the purpose of XSL
(a) Convert XML to HTML
(b) Convert HTML to XML
ANS: (a)
2) resultSet has the following methods
(a) next()
(b) first()
(c) a & b
(d) No methods
3) In WebLogic clusters, what is the load balancing algorithm ?
(a) RoundRobin
(b) FIFO
(c) LIFO
ANS: (a)
WebLogic uses a Round-Robin strategy as default algorithm for forwarding the HTTP requests inside a cluster. Weight-based and random algorithms are also available.
4) How many Queues does a MDB listen to ?
(a) 1
(b) 2
(c) Any Number
(d) 10
ANS: (a)
An MDB can be associated with only one Queue or Topic
5) Where is the Deployment Descriptor placed ?
(a) WEB-INF directory
(b) WEB-INF/CLASSES directory
(c) It will be mentioned in CLASSPATH
(d) The place can be specified in APPLICATION.xml
6) To denote distributed applications, What is the tag used in Deployment Descriptor ?
(a) distributable
(d) distributed="true"
(c) both a & b
7) Can a JSP be converted to SERVLET and the vice versa always ?
(a) YES
(b) NO
8) Empty JSP Tag definitions are given in Deployment Descriptor. Then which of the following syntaxes are correct ?
9) One small question on <jsp:useBean> tag
JAVA
----------
1) Which of the following 2 methods executes faster ?
class Trial {
String _member;
void method1() {
for(int i=0;i<2048;i++) {
_member += "test";
}
}
void method2() {
String temp;
for(int i=0;i<2048;i++) {
temp += "test";
}
_member = temp;
}
}
(a) method1()
(b) method2()
(c) Both method1() and method2() takes same time for execution
ANS: (b)
Accessing method variables requires less overhead than accessing class variables.
2) Integer.parseInt("12a") returns
(a) Exception
(b) 1
(c) 0
(d) -1
ANS: (a)
3) By default, Strings to functions are passed using the method
(a) Call by Value
(b) Call by Reference
(c) Strings cannot be passed to function
ANS: (b)
String is a class defined in java.lang and in java all classes are passed by reference.
4) What is the difference between OVERRIDING and OVERLOADING
5) What is the output of following program ?
class Test {
public static void main(String args[]) {
for(int i=0;i<2;i++) {
System.out.println(i--);
}
}
}
(a) Goes into infinite loop
(b) 0,1
(c) 0,1,2
(d) None
ANS: (a)
6) ,t, is the reference to a class that extends THREAD. Then how to suspend the execution of this thread ?
(a) t.yield()
(b) yield(t)
(c) yield()
(d) yield(100) where 100 is the milli seconds of time
7) What is the functionality of instanceOf() ?
8) How many String objects are created by the following statements ?
String str = " a+b=10 ";
trim(str)
str.replace(+,-);
(a) 1
(b) 2
(c) 3
(d) 4
ANS: (c)
Strings are immutable. So, for each String operation, one new object is generated.
9) (A program is given. I don,t remember exactly)
An ABSTRACT class is declared and the code is tried to instantiate it. The Question was whether it,s legal to do it or not ?
10) A question on "interface"
11) Cleaning operation in Java is done in the method
(a) finally()
(b) finalize()
(c) final()
12) Question on whether Static method can be overriden
13) How to prevent a class from being the Base Class ?
(a) declare it as final
(b) declare it as static
14) If we want to read a very big text file with so many mega bytes of data, what shall we use ?
(a) FileInputStream
(b) InputStreamReader
(c) BufferedReader
15) One Question on Inner Classes.
16) One program on Overloading and Overriding
17) A program given using try, catch and finally and it is asked to find out which statements get executed ?
18) What code, if written, below the (//code here) will display 0.
class Test {
public static void main(String argv[]) {
int i=0;
//code here
}
}
(a) System.out.println(i++)
(b) System.out.println(i+,0,)
(c) System.out.println(i--)
(d) System.out.println(i)
ANS: (a),(c),(d)
The option (b) displays the ASCII value of ,0,. So, the output in this case is: 48
19) What is the better way of writing the Constructor with 2 parameters in the following code:
class Test {
int x,y;
Test(int a) {
//Code for very complex operations will be written
//in this place
x=a;
}
Test(int a, int b) {
//Code for very complex operations will be written
//in this place (same code as in above constructor)
x=a;
y=b;
}
}
SQL
-------
2 Table Structures are given. (Something like Employee ID, Salary, Department etc)
And there are 3 queries. I remember one query.
Write query to find the employees with top 5 salaries ?
And there 2 more theoritical SQL questions
1) What is the difference between UNION and UNION ALL ?
2) What is the difference between COMMIT and ROLLBACK ?
ANALYTICAL
--------------------
5 very easy Questions. Need not bother much about it.
TECHNICAL INTERVIEW
-------------------------------------
1) Tell about yourself
2) Why do you want to leave the present company ?
3) What do you know about our (Manhattan Associates) company ?
4) About EJB types. CMP, BMP, Session, Entity beans, their differences, when to use what type of beans ?
5) Can a Client Context call ejbRemove() method ?
6) Who calls the methods ejbLoad() and ejbStore() and where the state information is stored when they are called ?
7) Do you know about Sequence Diagrams in UML ?
8) Which is faster in execution - JSP or SERVLET ? Why ?
9) What is the difference between Callable Statement and Prepared Statement?
10) Can we declare final method in abstract class ?
11) Can we declare abstract method in final class ?
12) What is the difference between Inner Join and Outer Join ?
13) How can you pass an object of data from one JSP to another JSP ?
ANS: Using Session or request.getParameter() or Hidden Variables.14) When these methods are used ? ejbActivate(), ejbPassivate() and ejbRemove() ?
15) What is the difference between ejbPassivate() and ejbRemove() ?
16) Can the same object of Stateless Session bean be shared by multiple clients ?
17) Can the same object of Stateful Session bean be shared by multiple clients ?
18) How do you manage transactions in EJB ?
19) What is the difference between response.redirect() and forward and request dispatcher ? Which is faster ?
20) In java, which has more wider scope ? Default or Private ?
MA Placement Paper : MA Paper Technical - Java - 17 January 2004
COMPANY NAME : MANHATTAN ASSOCIATES
------------------------------------------------------------
DATE OF TEST : 17 Jan 2004
------------------------------------------------------------
PLACE OF TEST: Le Meridian hotel, Chennai
------------------------------------------------------------
MODE : Off-Campus
------------------------------------------------------------
DURATION : 50 Questions in 1.5 Hours of Time)
------------------------------------------------------------
CATEGORY : JAVA - J2EE (2+ years experienced category)
----------------------------------------------------
MANHATTAN ASSOCIATES:
About the Company:
The company is in ITPL, Bangalore. And around 200 people strong in India. The whole company is around 1000 people strong world-wide. It,s a product based company and dealing mostly with Supply-Chain management and Data Warehousing.
Visit Company WebSite at : www.manh.com
How I applied:
2 weeks back, there was an advertisement in "The Hindu-Opportunities" asking for 2 + years of Java, J2EE experience. I sent my resume to the given mail ID. Only selected people are called for written test.
----------------------------------------------------
----------------------------------------------------
TEST PAPER AND INTERVIEW PATTERN:
----------------------------------------------------
There are 4 rounds:
Written Test
Technical Interview
CEO interview
HR interview
The Written test pattern:
50 Questions -- 1.5 hours of time.
Most of the questions are multiple choice.
The split up is :
EJB (10 Questions)
JAVA (20 Questions)
JSP (5 Questions)
MISLLENEOUS - XML, JDBC etc (5 Questions)
ANALYTICAL (5 Questions)
SQL (5 Questions)
Our written test is held on 17 Jan 2004 in Le Meridian hotel, Chennai.
I have written down whatever questions I remember so that it will be useful to those who will be taking the test in future and also for those appearing for J2EE interviews.
I have given the questions in Written Test and Technical Interview.
I didn,t have the other interviews.
EJB
1) What is true about ,Primary Key class, in Entity Beans ?
(a) Used to identify the entity bean based on EJB type, Home Interface and Container Context.
(b) Used to identify the entity bean based on EJB type, Remote Interface and Container Context.
(c) The definition of Primary Key class can be deferred till deployment
2) The Home Interface in Entity beans
(a) Provides at least one create() method
(b) May not provide any create() method
(c) Provides at least one findByPrimaryKey() method
(d) May not provide any findByPrimaryKey() method
3) In CMP of Entity beans
(a) Constructor with no arguments is defined
(b) Constructor is not defined
4) What is the purpose of ejbLoad()
5) What is the purpose of ejbStore()
6) In EJB, when a system error occurs, which exception is thrown ?
(a) EJBException
(b) RemoteException
7) In EJB, which of the following is an application level Exception ?
(a) NullPointerException
(b) ArrayOutOfBoundsException
(c) CreateException
(d) ObjectNotFoundException
(e) All the above
(f) None of the above
8) CMP bean provides
(a) Empty implementation of ejbLoad() and ejbStore()
(a) Concrete implementation of ejbLoad() and ejbStore()
----------------------------------------------------
JSP and Mislleneous
----------------------------------------------------
1) What is the purpose of XSL
(a) Convert XML to HTML
(b) Convert HTML to XML
ANS: (a)
2) resultSet has the following methods
(a) next()
(b) first()
(c) a & b
(d) No methods
3) In WebLogic clusters, what is the load balancing algorithm ?
(a) RoundRobin
(b) FIFO
(c) LIFO
ANS: (a)
WebLogic uses a Round-Robin strategy as default algorithm for forwarding the HTTP requests inside a cluster. Weight-based and random algorithms are also available.
4) How many Queues does a MDB listen to ?
(a) 1
(b) 2
(c) Any Number
(d) 10
ANS: (a)
An MDB can be associated with only one Queue or Topic
5) Where is the Deployment Descriptor placed ?
(a) WEB-INF directory
(b) WEB-INF/CLASSES directory
(c) It will be mentioned in CLASSPATH
(d) The place can be specified in APPLICATION.xml
6) To denote distributed applications, What is the tag used in Deployment Descriptor ?
(a) distributable
(d) distributed="true"
(c) both a & b
7) Can a JSP be converted to SERVLET and the vice versa always ?
(a) YES
(b) NO
8) Empty JSP Tag definitions are given in Deployment Descriptor. Then which of the following syntaxes are correct ?
(I don,t remember the options)
9) One small question on <jsp:useBean> tag
----------------------------------------------------
JAVA
----------------------------------------------------
1) Which of the following 2 methods executes faster ?
class Trial {
String _member;
void method1() {
for(int i=0;i<2048;i++) {
_member += "test";
}
}
void method2() {
String temp;
for(int i=0;i<2048;i++) {
temp += "test";
}
_member = temp;
}
}
(a) method1()
(b) method2()
(c) Both method1() and method2() takes same time for execution
ANS: (b)
Accessing method variables requires less overhead than accessing class variables.
2) Integer.parseInt("12a") returns
(a) Exception
(b) 1
(c) 0
(d) -1
ANS: (a)
3) By default, Strings to functions are passed using the method
(a) Call by Value
(b) Call by Reference
(c) Strings cannot be passed to function
ANS: (b)
String is a class defined in java.lang and in java all classes are passed by reference.
4) What is the difference between OVERRIDING and OVERLOADING
5) What is the output of following program ?
class Test {
public static void main(String args[]) {
for(int i=0;i<2;i++) {
System.out.println(i--);
}
}
}
(a) Goes into infinite loop
(b) 0,1
(c) 0,1,2
(d) None
ANS: (a)
6) ,t, is the reference to a class that extends THREAD. Then how to suspend the execution of this thread ?
(a) t.yield()
(b) yield(t)
(c) yield()
(d) yield(100) where 100 is the milli seconds of time
7) What is the functionality of instanceOf() ?
8) How many String objects are created by the following statements ?
String str = " a+b=10 ";
trim(str)
str.replace(+,-);
(a) 1
(b) 2
(c) 3
(d) 4
ANS: (c)
Strings are immutable. So, for each String operation, one new object is generated.
9) (A program is given. I don,t remember exactly)
An ABSTRACT class is declared and the code is tried to instantiate it. The Question was whether it,s legal to do it or not ?
10) A question on "interface"
11) Cleaning operation in Java is done in the method
(a) finally()
(b) finalize()
(c) final()
12) Question on whether Static method can be overriden
13) How to prevent a class from being the Base Class ?
(a) declare it as final
(b) declare it as static
14) If we want to read a very big text file with so many mega bytes of data, what shall we use ?
(a) FileInputStream
(b) InputStreamReader
(c) BufferedReader
15) One Question on Inner Classes.
16) One program on Overloading and Overriding
17) A program given using try, catch and finally and it is asked to find out which statements get executed ?
18) What code, if written, below the (//code here) will display 0.
class Test {
public static void main(String argv[]) {
int i=0;
//code here
}
}
(a) System.out.println(i++)
(b) System.out.println(i+,0,)
(c) System.out.println(i--)
(d) System.out.println(i)
ANS: (a),(c),(d)
The option (b) displays the ASCII value of ,0,. So, the output in this case is: 48
19) What is the better way of writing the Constructor with 2 parameters in the following code:
class Test {
int x,y;
Test(int a) {
//Code for very complex operations will be written
//in this place
x=a;
}
Test(int a, int b) {
//Code for very complex operations will be written
//in this place (same code as in above constructor)
x=a;
y=b;
}
}
----------------------------------------------------
SQL
----------------------------------------------------
2 Table Structures are given. (Something like Employee ID, Salary, Department etc)
And there are 3 queries. I remember one query.
Write query to find the employees with top 5 salaries ?
And there 2 more theoritical SQL questions
1) What is the difference between UNION and UNION ALL ?
2) What is the difference between COMMIT and ROLLBACK ?
----------------------------------------------------
ANALYTICAL
----------------------------------------------------
5 very easy Questions. Need not bother much about it.
----------------------------------------------------
TECHNICAL INTERVIEW
----------------------------------------------------
1) Tell about yourself
2) Why do you want to leave the present company ?
3) What do you know about our (Manhattan Associates) company ?
4) About EJB types. CMP, BMP, Session, Entity beans, their differences, when to use what type of beans ?
5) Can a Client Context call ejbRemove() method ?
6) Who calls the methods ejbLoad() and ejbStore() and where the state information is stored when they are called ?
7) Do you know about Sequence Diagrams in UML ?
8) Which is faster in execution - JSP or SERVLET ? Why ?
9) What is the difference between Callable Statement and Prepared Statement?
10) Can we declare final method in abstract class ?
11) Can we declare abstract method in final class ?
12) What is the difference between Inner Join and Outer Join ?
13) How can you pass an object of data from one JSP to another JSP ?
ANS: Using Session or request.getParameter() or Hidden Variables.
14) When these methods are used ? ejbActivate(), ejbPassivate() and ejbRemove() ?
15) What is the difference between ejbPassivate() and ejbRemove() ?
16) Can the same object of Stateless Session bean be shared by multiple clients ?
17) Can the same object of Stateful Session bean be shared by multiple clients ?
18) How do you manage transactions in EJB ?
19) What is the difference between response.redirect() and forward and request dispatcher ? Which is faster ?
20) In java, which has more wider scope ? Default or Private ?
MA Placement Paper : MA Paper General - other Chennai - 17 January 2004
MANHATTAN ASSOCIATES:
The company is in ITPL, Bangalore. And around 200 people strong in India. The whole company is around 1000 people strong world-wide. It,s a product based company and dealing mostly with Supply-Chain management and Data Warehousing.
How I applied:
2 weeks back, there was an advertisement in "The Hindu-Opportunities" asking for 2 + years of Java, J2EE experience. I sent my resume to the given mail ID. Only selected people are called for written test.
TEST PAPER AND INTERVIEW PATTERN:
There are 4 rounds:
Written Test
Technical Interview
CEO interview
HR interview
The Written test pattern:
50 Questions -- 1.5 hours of time.
Most of the questions are multiple choice.
The split up is :
EJB (10 Questions)
JAVA (20 Questions)
JSP (5 Questions)
MISLLENEOUS - XML, JDBC etc (5 Questions)
ANALYTICAL (5 Questions)
SQL (5 Questions)
Our written test is held on 17 Jan 2004 in Le Meridian hotel, Chennai.
I have written down whatever questions I remember so that it will be useful to those who will be taking the test in future and also for those appearing for J2EE interviews.
I have given the questions in Written Test and Technical Interview.
I didn,t have the other interviews.
EJB
--------
1) What is true about ,Primary Key class, in Entity Beans ?
(a) Used to identify the entity bean based on EJB type, Home Interface and Container Context.
(b) Used to identify the entity bean based on EJB type, Remote Interface and Container Context.
(c) The definition of Primary Key class can be deferred till deployment
2) The Home Interface in Entity beans
(a) Provides at least one create() method
(b) May not provide any create() method
(c) Provides at least one findByPrimaryKey() method
(d) May not provide any findByPrimaryKey() method
3) In CMP of Entity beans
(a) Constructor with no arguments is defined
(b) Constructor is not defined
4) What is the purpose of ejbLoad()
5) What is the purpose of ejbStore()
6) In EJB, when a system error occurs, which exception is thrown ?
(a) EJBException
(b) RemoteException
7) In EJB, which of the following is an application level Exception ?
(a) NullPointerException
(b) ArrayOutOfBoundsException
(c) CreateException
(d) ObjectNotFoundException
(e) All the above
(f) None of the above
8) CMP bean provides
(a) Empty implementation of ejbLoad() and ejbStore()
(a) Concrete implementation of ejbLoad() and ejbStore()
JSP and Mislleneous
--------------------------------
1) What is the purpose of XSL
(a) Convert XML to HTML
(b) Convert HTML to XML
ANS: (a)
2) resultSet has the following methods
(a) next()
(b) first()
(c) a & b
(d) No methods
3) In WebLogic clusters, what is the load balancing algorithm ?
(a) RoundRobin
(b) FIFO
(c) LIFO
ANS: (a)
WebLogic uses a Round-Robin strategy as default algorithm for forwarding the HTTP requests inside a cluster. Weight-based and random algorithms are also available.
4) How many Queues does a MDB listen to ?
(a) 1
(b) 2
(c) Any Number
(d) 10
ANS: (a)
An MDB can be associated with only one Queue or Topic
5) Where is the Deployment Descriptor placed ?
(a) WEB-INF directory
(b) WEB-INF/CLASSES directory
(c) It will be mentioned in CLASSPATH
(d) The place can be specified in APPLICATION.xml
6) To denote distributed applications, What is the tag used in Deployment Descriptor ?
(a) distributable
(d) distributed="true"
(c) both a & b
7) Can a JSP be converted to SERVLET and the vice versa always ?
(a) YES
(b) NO
8) Empty JSP Tag definitions are given in Deployment Descriptor. Then which of the following syntaxes are correct ?
9) One small question on <jsp:useBean> tag
JAVA
----------
1) Which of the following 2 methods executes faster ?
class Trial {
String _member;
void method1() {
for(int i=0;i<2048;i++) {
_member += "test";
}
}
void method2() {
String temp;
for(int i=0;i<2048;i++) {
temp += "test";
}
_member = temp;
}
}
(a) method1()
(b) method2()
(c) Both method1() and method2() takes same time for execution
ANS: (b)
Accessing method variables requires less overhead than accessing class variables.
2) Integer.parseInt("12a") returns
(a) Exception
(b) 1
(c) 0
(d) -1
ANS: (a)
3) By default, Strings to functions are passed using the method
(a) Call by Value
(b) Call by Reference
(c) Strings cannot be passed to function
ANS: (b)
String is a class defined in java.lang and in java all classes are passed by reference.
4) What is the difference between OVERRIDING and OVERLOADING
5) What is the output of following program ?
class Test {
public static void main(String args[]) {
for(int i=0;i<2;i++) {
System.out.println(i--);
}
}
}
(a) Goes into infinite loop
(b) 0,1
(c) 0,1,2
(d) None
ANS: (a)
6) ,t, is the reference to a class that extends THREAD. Then how to suspend the execution of this thread ?
(a) t.yield()
(b) yield(t)
(c) yield()
(d) yield(100) where 100 is the milli seconds of time
7) What is the functionality of instanceOf() ?
8) How many String objects are created by the following statements ?
String str = " a+b=10 ";
trim(str)
str.replace(+,-);
(a) 1
(b) 2
(c) 3
(d) 4
ANS: (c)
Strings are immutable. So, for each String operation, one new object is generated.
9) (A program is given. I don,t remember exactly)
An ABSTRACT class is declared and the code is tried to instantiate it. The Question was whether it,s legal to do it or not ?
10) A question on "interface"
11) Cleaning operation in Java is done in the method
(a) finally()
(b) finalize()
(c) final()
12) Question on whether Static method can be overriden
13) How to prevent a class from being the Base Class ?
(a) declare it as final
(b) declare it as static
14) If we want to read a very big text file with so many mega bytes of data, what shall we use ?
(a) FileInputStream
(b) InputStreamReader
(c) BufferedReader
15) One Question on Inner Classes.
16) One program on Overloading and Overriding
17) A program given using try, catch and finally and it is asked to find out which statements get executed ?
18) What code, if written, below the (//code here) will display 0.
class Test {
public static void main(String argv[]) {
int i=0;
//code here
}
}
(a) System.out.println(i++)
(b) System.out.println(i+,0,)
(c) System.out.println(i--)
(d) System.out.println(i)
ANS: (a),(c),(d)
The option (b) displays the ASCII value of ,0,. So, the output in this case is: 48
19) What is the better way of writing the Constructor with 2 parameters in the following code:
class Test {
int x,y;
Test(int a) {
//Code for very complex operations will be written
//in this place
x=a;
}
Test(int a, int b) {
//Code for very complex operations will be written
//in this place (same code as in above constructor)
x=a;
y=b;
}
}
SQL
-------
2 Table Structures are given. (Something like Employee ID, Salary, Department etc)
And there are 3 queries. I remember one query.
Write query to find the employees with top 5 salaries ?
And there 2 more theoritical SQL questions
1) What is the difference between UNION and UNION ALL ?
2) What is the difference between COMMIT and ROLLBACK ?
ANALYTICAL
--------------------
5 very easy Questions. Need not bother much about it.
TECHNICAL INTERVIEW
-------------------------------------
1) Tell about yourself
2) Why do you want to leave the present company ?
3) What do you know about our (Manhattan Associates) company ?
4) About EJB types. CMP, BMP, Session, Entity beans, their differences, when to use what type of beans ?
5) Can a Client Context call ejbRemove() method ?
6) Who calls the methods ejbLoad() and ejbStore() and where the state information is stored when they are called ?
7) Do you know about Sequence Diagrams in UML ?
8) Which is faster in execution - JSP or SERVLET ? Why ?
9) What is the difference between Callable Statement and Prepared Statement?
10) Can we declare final method in abstract class ?
11) Can we declare abstract method in final class ?
12) What is the difference between Inner Join and Outer Join ?
13) How can you pass an object of data from one JSP to another JSP ?
ANS: Using Session or request.getParameter() or Hidden Variables.14) When these methods are used ? ejbActivate(), ejbPassivate() and ejbRemove() ?
15) What is the difference between ejbPassivate() and ejbRemove() ?
16) Can the same object of Stateless Session bean be shared by multiple clients ?
17) Can the same object of Stateful Session bean be shared by multiple clients ?
18) How do you manage transactions in EJB ?
19) What is the difference between response.redirect() and forward and request dispatcher ? Which is faster ?
20) In java, which has more wider scope ? Default or Private ?