Hello All, i just want to share my experience of AMDOCS technical test so that someone will get an idea.. I attended the test as experienced candidate in java/j2ee in june 2009. There were total of 7 sections in test: 1. Aptitude test 2. Analytical reasoning 3. Learning ability 4. Java 5. J2ee 6. Unix 7. SQL Aptitude Test: It requires practice as after experience people get out of touch with aptitude so be prepare for this. I guess bit preparation will be enough but yes you do need to. Analytical Reasoning : This is easy comparatively. Just solve some examples from any reasoning book. The question i remember were : a. If *for -, + for /, - for * and / for +, calculate value for some expression like 2+3*7-6/5. (this is not exact question, just an idea how were they) b. If 0 to be written as * and 1 as $ and as 1 get promoted to left side its value just doubled, like 4 can be represented as $** and 3 can be $$ den evaluate following (i) $**$$ (ii) ***$$$**. Learning Ability : They gave a paragraph and on basis of this you have to answer 10 ques. This was quite simple as you have sufficient time (15 mins) to ans 10 ques. Java : Questions were on Thread, File handing, try catch bolck. Some of the questions were a. wait(),notify() n notifyAll() methods are of which class (i) Thread (ii) Object (iii) Class (iv) String b. for each try block (i) there must be a catch block (ii) there must be a finally block (iii) there must be either a catch of finally block (iv) if both catch n finally blocks are there den finally must be followed by catch block. J2EE : Questions were on servlets, EJB and transaction. a. How exceptions in J2EE servlets handled (i) Ignored by server (ii) Propagating the exception to the servlet user (iii) by a handler in servlet contanier (iv) A handler is written and linked through the deployment descriptor b. Tag to make database connection and add record (i) DBConnect (ii) DBQuery (iii) DBModify (iv) none c. Which is correct about transaction in EJB (i) EJB must not use bean managed persistance. (ii) EJB2.0 supports nasted transaction. (iii) EJB2.0 allows you to specify isolation level. (iv) Message driven beans must not use bean managed transaction. d. _ is used to provide faster access to binding objects to keys (i) Primary key (ii) Complex primary key (iii) Hashtable (iv) Foreign key e. A transaction client receives transactionRolledBackException from a call to a method on an entity bean. What is the possible reason to this?? f. Which is most lenient transactional level that can be applied to transactions (i) Transaction_None (ii) Transaction_Read_Uncomm (iii) Transaction_Read_Comm (iv) Transaction_Serialized g. Use of javax.rmi.ProtableRemoteObject.narrow h. Whose responsibility is to provide an implementation of home interface of EJB?? UNIX a. Kill –o 121 – will this command kill the process id 121 i. True ii. Syntax error as –o is invalid option iii. Not kill the process iv. None b. Which will with grep give the line number of matched pattern i. –i ii. –l iii. –n iv. –u c. Which option is used to refer to current script being executed i. $? ii. $! iii. $o iv. $# d. Command to run the process even after the user logout i. Nohup ii. Bgnd iii. Sh iv. Shellrun e. In sh script command to show current working directory in prompt i. PS1=’pwd’(backquotes) ii. PS1=’$pwd#’ (single quote) iii. PS1=”$pwd#” (double quote) iv. PS1=$pwd f. Using sed how to delete word from file i. Sed –e ‘s/word/g’ filename ii. Sed –e ‘s/word//g’ filename iii. Sed –e ‘s_word//g’ filename iv. Sed –e s/word/g filename g. Area of harddisk for extension of main memory i. Kernel space ii. Swap space iii. System space iv. Process space h. Put sign in place of exist extension in vi editor i. e ii. u iii. l iv. some more option (I forgot) i. file descriptor for stderr,stdout,stdin i. 0,1,2 ii. 3,2,1 iii. 1,2,3 iv. 2,1,0 SQL a. Question related to correlated subquery b. Query to remove column from table i. Delete statement ii. Drop statement iii. Alter statement iv. Update statement c. How minimize the number of rows for a particular execution of query i. CUTDOWN ii. LIMIT iii. LESS iv. NUMBER d. How delete all rows from table i. Truncate table ii. Delete statement iii. Drop table statement iv. Delete * statement e. Question about Truncate keyword. f. Table A has x no of rows n table B has y no of rows, which of the following gives maximum no of rows i. A union B ii. A minus B iii. A intersaction B iv. A union all B g. Question regarding rollback h. Question about NULL SQL keyword i. To drop constraint, which of following is used i. Update constraint ii. Delete constraint iii. Remove constraint iv. Alter table j. To change definition of existing table i. Alter table change (……) ii. Alter table (…..) iii. Alter table modify (……) iv. Can not change because table has data k. Question about HAVING clause l. Intersect option i. Does not present in sql ii. To combine 2 rows into 1 and return resultset that contain single row. iii. Combine multiple table column values into 1 row and return resultset. iv. Combine 2 table exp into 1 and return a result set that consist of rows those appear in the result of both table exp.