amdocs test in june 2009

Discussion in 'Latest Placement papers' started by Guest, Jun 17, 2009.

  1. Guest

    Guest Guest

    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.

Share This Page