Now days in IT getting job is very tough day by day .,if we want good salary with luxurious life ,
we should not forgot to prepare yourself before go to any interviewPlease find the list of interview question for top 100 company .
1 How do you reverse a string?2 How do you sort a HashMap?
3 What is Multithreading?
4 What is Synchronization in Multithreading?
5 Real time examples of Multithreading and Synchronization
6 What is Serialization and what is it's use?
7 Difference between JDK1.4 and JDK1.5
8 Difference between JDK1.5 and JDK1.6
9 What are different Collection objects available in Java?
10 What is Hashmap, Vector, ArrayList and LinkedList?
11 Connection Pooling Concepts
12 How will you handle a dead connection object in Connection Pool?
13 Performance imporvements for Database connectivity
14 JDBC Concepts, Prepared Statements, Callable Statements
15 Basics of JSPs and Servlets, Servlet Life Cycle
16 Cookies, Sessions, URL rewriting, scope in Java Web applications
17 Struts (Action, Action Controller, Action Forms, Validation framework)
18 Design patterns like Front Controller, MVC, Service Locator etc
19 Oracle DB and specific query optimization - for e.g. “select for update” query
20 EJB's Session & Entity Beans , Entities relationships, Annotations
21 Unix platform (knowledge of basic commands like grep, pipes, redirection etc)
22 Basics of Hibernate
23 Basics of Junit
24 What is Remote Debugging and how is it helpful?
25 Interceptors and FileUpload Interceptors
26 JQuery and it's features
27 Who takes care of execution of Jquery statements?
28 Can we change the special characters (#) used in Jquery statements?
29 What is the significance of serialization in hibernate
30 Various Java I/O stream and its differences
31 Various encoding types in java
32 How do you sort a collection having objects of a user defined class based on it's attributes?
33 How to find how many times each word of a sentence repeats in the sentence?
34 Various XML parsers
35 How to read files?
36 How will you handle large files - let's say there's a file of 1 TB size, what will be your approach to read it?
37 What is Socket? What protocol it uses for communication?
38 How does SMS (mobile phone sms) work?
39 Let's say there is a requirement of making a server side application which should count the votes which people can send from their mobiles, what would be your approach to design that?
40 What is group by in Database and when it is used?
41 What is difference between Char and Varchar?
42 What's the maximum size of varchar?
43 What is CLOB data type?
44 What is indexing in database, how does it help?
45 Let's say there is a table which has millions of records and records get updated frequently in that table. If you had to build a report for end users to show the statics of each hour, what would be your approach. Keep performance in mind since table has huge number of records.
46 How would you design screen which shows the above data on a report and should have an option of sorting, pagination, filter, etc.
47 What is LinkedList and what's the advantage of using LinkedList?
48 What is Dictionary?
49 What are cron jobs in Unix?
50 How will you convert Array List to Arrays?
51 How will you sort an Array of string or integers?
52 Give some functions available in Object class
53 What is the use of Properties class?
54 Tell something about XML and it's structure
55 How to send emails from a program
56 What is the use of SMTP
57 Tell something about Messaging/Queuing concepts
58 Exception Handling concepts
59 How will you do debugging/troubleshooting in Production servers?
60 What is the use of an interface?
61 What is Class.forName user for?
62 What are the profiler tools you are aware of?
63 Locking tables in database for parallel update
64 What do you mean by Interface Driven Programming ?
65 How do you think the user threads / Hits will be managed in a shopping site like Ebay ? Will that be synchronized? If yes, how it is concurrently managed?
66 What are the methods to Initialise Threads ?
67 What is interceptors ni struts2? Explain one.
68 How to perform remote debugging in eclipse?
69 Explain the logic to find number of times a word repeats in a string/file.
70 Basic Linux commnacs and its purpose.
71 What do you know about encoding types in java?
72 What is jQuery and have you used any jQuery plugins?
73 A scenario, person class and the objects need to be stored in a collection and sort based on its attributes. How will you do it in a utility class and how much would be the estimation? How will you perform testing?
74 What is the version UID in a serialized file?
75 Explain the basics on java.nio
76 If I compile a java file, serialize the same and then send it to other end. Then without making any changes to java file, I am compiling the java code again. Will there be any discrepencies if we deserialise the file which was sent and compare with the latest code?
77 What would be your design approach while designing a object pool? It should be thread safe. Will be set any upper bound? What if a request comes for object when the pool has reached its limit? How will make the new request wait untill a object is released?
78 How to skip a specific portion of an XML file which processing the same?
79 How will you transfer a jpeg image via XML file? i.e. how will you transfer binary data in XML file?
80 How to pass XML data in query string?
81 Difference between Forward and redirect?
82 How to load the properties in a servlet?
83 Which parser you will use to parse an XML file of 1GB?
84 What is a Pull Parser?
85 Consider there is a oracle table which will get millions of records from the application. Design a program to insert millions of records into that table and to remove the records which are older than 90 days. Records can be sent via a flat file or from application.
86 What is Oracle AQ?
87 How will you return custom business exceptions from Stored procedure to java?
88 Explain the structure of JSON object?
89 What are the special characters do you think that needs to be handled while processing JSON object?
90 How will you get the disk free space and disk usage in Unix server?
91 Consider I set the max heap space as 4GB while running a java program. What are the things needs to be considered/handled in this scenario?
92 What are the GC parameters you are aware?
94 What are Garbage Collector Algorithms.
95 What is Minor GC.
96 What is Major GC.
97 Query to find second highest salary.
99 Query on Indexes in Oracle.
100 What is final, finally and finalize.
101 What are the advantages of using Hibernate?
102 Why use Hibernate over JDBC.
103 Explain static in Java.
104 How will you take thread dump?
105 Which will give better performance. Hibernate performance vs JDBC performance?
106 How will you tune GC parameters?
107 Have you used SQL execution plan
108 How will you do unit testing
109 Have you worked in fixing memory related issues?
110 Java collections HashMap vs LinkedHashMap vs ConcurrentHashMap
111 Java Thread executors
112 Jdk 7 features
113 JVM tunning parameters and gc algorithms
114 Serialization
115 Java design patterns
116 Junit tearup and teardown methods
117 Ant ..maven
118 Comparator's and how binarysearch works
119 Exception types
120 Synchronization
121 How SMTP, POP and IMAP works
122 Java: List, ArrayList, HashMaps, vectors, immutable objects
123 MultiThreading, synchronization
124 Servlets, servlet life cycle, detail
125 Detail JSP, JSF
126 Struts 2 in detail
127 Ajax concepts
128 UI designing (Scenario: mail receiving and sending to, cc, bcc): including tables in database
129 Details about the previous project
130 How to handle Asynchronous service in OSB
131 OSB performance optimisations parameters
132 Security in OSB
133 Certificates and key store in OSB
134 JAVA implementation in OSB
135 How do you sort a HashMap with its keys and values
136 How would you apply a customized algorithm while sorting a Hashmap
137 For Singleton design pattern, how will you ensure that only one object is created throughout the application
138 How will you implement your own HashMap
139 Brief about the projects and technologies to worked on
140 Why we use Volatile keyword in Java and its use cases?
141 "How GC works in Java and its related parameters?
"
142 Why we use multithreading and what need to be take care while programming in multithreading?
143 What are the tools we uses to develop the java applications ?
144 What are the things we need to take care while developing the java application?
145 what is sequel statements?
146 What is SQL injection?
147 What is Prepared statement and its benefit?
148 What is Http Protocol and its headers and how it works?
149 Cross Sites scripts
Other Questions
S.No. Questions1 How do you manage/handle tasks under pressure?
2 Will you be able to work with minimal guidance on an existing application?
3 Have you used a Mac machine?
5 How do you plan your tasks?
6 How do you monitor and track your tasks?
7 How often you interact with your clients in your current project?
8 What are the challenges you have faced while moving to a new project?
9 What will be your approach for an onsite-offshore project model?
10 How will you manage communication between onsite & offshore teams?
11 How will you improve turn around time of offshore team?
12 What will be your approach for Design and architecture in existing application?
13 How much you may need to understand an existing product?
14 Do you have any idea about Supply Chain Management?
15 Are you still in touch with coding?
My Project Related Questions My Project related Questions
1 How will you debug the core dump generated from C code?
2 What is the unix command used for checking the CPU usage?
3 How did you integrate your java code with JNI and get the return message back to java?
4 Explain the project that you have worked
5 Development was done in Windows/Unix/Linux platform?
6 What is the implementation process you follow?
7 How the code will be moved from development to test to production server in your project?
8 Any performance tuning in your project?
9 How many transactions were handled in your project?
10 Do you have DB design experience?
11 Explain the areas of work carried out in your project
List of questions
1 How to send image in Cookies?
2 Difference between Cookies and header
3 List out all the Final classes in java packages
4 How to convert image to byte array
5 Interface A has attribute myName and Interface B also has attribute myName, can a class X implements both the interfaces
6 What are checked and unchecked exceptions ?
7 Why java provide something called runtime expection
8 What is thread starvation ?
9 What does notify() and wait () means ? http://www.javamex.com/tutorials/wait_notify_how_to.shtml
10 Can I make main method in Servlet ?
11 What is difference between Servlet and normal java class
12 what is prefetch concept in resultset
13 What is maximum size of JVM one can can set
14 Attribute to define JVM heap size
15 How profiler help in troubleshooting ?
16 Why synchronization is required for Hashmap in multithreaded environment? And its explanation
17 Rehashing of Hashmap
18 Difference of == and equals and questions based on scenarions on this. How to overide equals?
19 How to implement a servlet counter condidering mutiple request
20 How session manged by container?
21 Questions related with constructors. How to call superclass constructor
22 Connection Pooling and its implementaion in multithreaded environment
23 Session Management in jsp , servlet
24 How to pass parameters between jsp while including
25 Limit of String in Java
26 Thread communication
27 What is the use of HashCode?
28 Where do you code for session management in JSP or Controller?
29 Why do we use StrigBuffer/StringBuilder?
30 how do you manage session if there are two servers for load balancing
31 Design an HR database.. With java objects and explain the inheritance hierarchy structure
32 what is Volatile ?
33 Singleton Pattern Explain?
34 Synchronized function in Singleton class
35 Synchronized function in servlet purpose
36 How to optimise JVM?
37 JVM invocation from JNI?
38 Parameters passed while invoking JVM and details?
39 How to invoke Java class methods/objects from JNI?
40 Thread synchronisation/programming Questions?
41 How to restrict no. of client connections to server ? (From server programming point of view)
42 How to create a non-blocking socket?
43 How to debug Java code in Unix and Windows?
44 Questions on GC, Eden ?
45 Convert Array to Collections?
46 Is it thread safe to convert array to collections?
47 What are the two MVC types?
48 What is value stack?
49 what is OGNL?
50 How can you read file using multithreading?
51 What is log4j?
52 How do we configure rolling of files?
53 How do you configure rolling files per second?
54 What is the limit on the number of requests that can be serviced?
55 Say you have jvms running on different machines and each jvm has its own cache for the same oracloe table. How will you maintain cache coherency across the jvms?
56 Different sorting algorithms you know? How does Bubble sort work?
57 Explain the algorithm behind Hashmap?
58 Why jenkins is used?
59 How to schedule a job in jenkins?
60 What are the different ways of creating a thread?
61 What is the difference between extending a Thread Class and Implementing Runnable interface?
62 What is the difference between Runnable and Clonable?
63 What are Therad Locks in Java?
64 What is a Blocking Queue?
65 What is the difference between Synchronized Hashmap and Concurrent Hashmap?
66 What are the different Http Request Headers?
67 What is the advantage of using Jquery?
68 What is the $ and # notation denote in Jquery?
69 What are the call by value and call by reference parameters in Oracle Stored Procedures?
70 How to debug the stored procedure code in Oracle?
71 What are the types of cursors in Oracle?
72 How to debug a slow running query in Oracle?
73 How to find the running process in Linux?
74 How do we print the 10 lines before and after a certain log statement from log file in linux?
75 How to stop a certain process in Linux? What is the command to force stop a certain process?
76 Comand to replace all occurences in a file in linux?
77 He had then asked me about the startup that I was working for . My role in there .
78 When setting up the offices what did you look for ( I had set up the office in Vegas since it was primarily from a Bay area guy)
79 How does your day look like ?
80 what were the different technologies used ?
81 Explain about mod pl/sql
82 What do you know about Java ?
83 How did you do email marketing ? What was the tool used .
84 What are the key things that you look for in the email marketing strategy .
85 How was the technical architecture for the email marketing tool . (I had integrated Exact Target with Oracle as the database)
86 Have you worked in Agile ? Explain
87 Tell me more about your startup . Why are you leaving that ?
88 How did you manage your team ? What were the issues
89 How did you track work
90 Can you tell me a few Technical challenges faced and how did you solve them. -> Followed by questions to get to know more about my examples.
91 Domain of Work experience ? Was Questioned about the SAN and Network domains I worked with.
92 What are the different types of transactions in J2EE and explain about them. -> Discussion about Container managed transactions, Bean Managed transactions.
93 If your table has huge volume of data, How do you handle such huge database transactions.
95 What were the different metrics that you had used . Explain a few and how were they helpful ?
Testing
Key areas covered by client
1 Ø Basic concepts of Functional testing - code coverage, requirement coverage, defect prevention. Questions were on real work experience. (Inference: Conceptual explanation is not sufficient for client. Need to give scenarios from the work experience)
2 Ø Performance testing- Concurrency, troubleshooting the server, problem solving ability (Inference: In depth Performance Engineering knowledge should be there. Client expects more in the areas of server trouble shooting. Please answer to the point and elaborate on the areas only that you are well aware of)
3 Ø Shell scripting knowledge
4 Ø Oracle tuning ,SQL Queries – Asked questions on joins, sub queries
5 Ø Code deployment knowledge, environment deployment knowledge- (Inference: Clients expects in the area of development and application deployment)
6 Ø Selenium concepts, java coding
Overall Expectation from client: A tester should have diversified knowledge in the all areas of testing including unit testing, SIT, regression, automation, performance and ops activities
1 Ø What is Java memory model?
2 Ø Garbage Collection and its working?
3 Ø Method used for garbage collection?
4 Ø What is collections framework?
5 Ø What collection will you use to make an application where multithreading is required and it should be thread safe?
6 Ø Difference between HashMap and ConcurrentHashMap?
7 Ø What is volatile and Synchronised? Race condition and critical section?
8 Ø Why we should use volatile or synchronised and when?
9 Ø What is finalize()?
10 Ø What is finally?
11 Ø What is Immutable? How will you make a class Immutable?
12 Ø Tell about wait(), notify(), notifyAll().
13 Ø Explain design patterns (AbstractFactory design pattern)
Overall topics covered : Memory Model/Garbage Collection, Collections, Multithreading.
Oracle Questionnaire
Constraints , Normalization
1 What are the different constraints that you have worked with
2 What is the difference between Primary key column and Unique key column
3 How many null values can be there in the Unique key column
4 Lets suppose you have a database with very little constraints, in that case how do you go about modifying the architecture?
5 Have you worked with data modeling? Which tool have you used
6 What is a physical data model and logical data model
7 What is the use of foreign key? What would happen if we do not have a foreign keys ? What are the problems that would be faced
8 Can you drop data in a child table if the record is present in parent table ? If not what is the way to do that?
9 What are check constraints? Have you used? Why ?
10 What is the difference between table level constraint and row level constraint?
11 In what normal form was your database?
12 Why do we do de normalization ?
13 So did your database had tables with many to many relationship ? If they say Yes , then you can ask in which normal form was the database
Indexes
1 Can you add an index to an already existing table . A table where data is already present
2 Can I have indexes on all the columns in the table.
3 What is the internal architecture of Indexes . It is generally said that index helps to retrieve data faster but why . How is index organized ?
4 What is bitmap index ?
5 What is reverse key index
6 Lets supoose you are running a query . How can you make sure that the index is getting used or not or which table in oracle will show that the index is getting used
7 Do we need to gather statistics to make sure index is working . What is the command to gather statistics
Cursors
1 What is where current of clause ?
2 What is a parameterized cursor
3 What is cursor variable
4 Have you used ref ciursor . Why did you use it – Once the answer is given we can ask why it was not done by simply passing the data from one program to another in a collection ? Generally ref cursors are declared globally
Triggers
1 What is instead of trigger ? where is that used
2 What is a mutating table ? When do you see that ? Have you faced the same issue
3 Diff between row level trigger and statement level trigger
4 What would be the value of :old in case of a before insert trigger
5 Have you worked with composite trigger ? Is there something called composite trigger?
Versions
1 What are the different versions of Oracle that you had worked on ?
2 Can you name few unique feature of 10G
3 What about 12c ? How is that different
4 What was the size of the database that you had worked on
Exception
1 What are the different types of exceptions in Oracle
2 What are user defined exception
3 Why do you need user defined exceptions
4 Suppose you have written an exception but you are not able to catch that in your exception block that is an error came up which was not defined .What will happen ? How can you avoid such situation –this question is a follow up of the main question
5 Can you name a few exceptions that you had faced .
Dynamic queries , bulk binding , bulk collect
1 have you ever worked with SQL injection or cross browser scripting . If the answer is no then ask if he has worked with Dynamic queries . Probably he will say yes
2 What was the need to work with dynamic queries ? Why couldn’t you do with Static queries
3 Which is better , static query or dynamic query in terms of performance . they will answer dynamic but its wrong , dynamic queries are compiled at run time so its not good
4 Have you ever used bulk collect and bulk binding
5 Can bulk collect work without collections . Can I have a scalar variable and use Bulk collect to collect into it . Will that work
6 Is bulk binding a performance hamper ? It will bind the whole column so it will utilize more memory
7 Where does the collections stay for each session . Will that be in PGA or SGA
Performance
1 Whenever you write queries do you actually follow certain rules so that performance is better
2 Suppose a query is running slow how do you approach its tuning
3 What are the things that you look for during Tuning
4 What are IOT tables
5 Have you worked with TKPROF utility
6 Have you used any Oracle defined packages for performance
7 Is there any way that we can force Oracle optimizer to use certain resources or execute the query using some particular index .
8 If he can’t answer ask about Hints .
9 What are Oracle clusters
10 Have you used co related queries ever . Is it better than nested queries or subqueries
11 What is no_copy compiler hint
12 Suppose, client has asked me to add a column to a table which is in production already. What are the issues i have to take care.
Joins
1 What are the different kinds of joins
2 Do you know how oracle retrieves data in case of joins , internally what happens (hash join , loop join , nested loop join )
3 Does order of the tables matter in the query when writing outer joins ?
4 How are null conditions treated in Joins
Collections
1 What are the different types of collections that you have used . Which one did you use when ?
Analytical
1 Which analytical function you had used most
2 What is the difference with aggregate queries
Partition
1 What are the different partions in Oracle
2 How were the partitions created every time for growing partitions
3 What are sub partitions ?
Backups
1 What are the different backup strategies that are there in Oracle ?
1 Difference between Arraylist and vector.
2 Doubly linked list implementation(Data structure ).
3 What is singleton class and how to create?
4 What is generics and implementation of generics with different examples
5 What is multithread .What is difference between Run() and Start().?In detail with example
6 Thread join(),yield (),Notify().
7 Difference between Hash Map and Hash Table.
8 How synchronized impact the performance.
1 Brief about the project and technologies
2 Java Reflection? how it works?
3 Can we access the methods or classes those are in different packages and its use cases?
4 Can we access the private members of a class using reflection?
5 What is serialization?
6 If we modify any class after serialization then what will happen during reserializing?
7 What is the significant of serial version id?
8 Design patterns? Singleton design patterns? how to create singleton class?
9 How to make sure that there will be only one singleton object in multithreaded environment.
10 Cloning in java? what are the methods of cloneable interface?
11 If there are three classes e.g. class A,B,and C. A have a reference of class B and B has a reference of C then If we clone Class A then what will happen and can we called it as a deep cloning?
12 Class name of the clone () method
1 General Background based on my resume. i.e Project information, technologies familiarity etc.
2 Enterprise service bus concepts?
3 Basic questions regarding webservices , creation , deployment
4 Differences between SOAP and RESTful
5 a) Deep dive questions on SOAP messaging, Deep dive questions on Axis2
5 b) which restful api used in the project?
6 Asynchronous Webservices,
6 a) What approach is required for asnych and synch webservices…
6 b) Transport layer that supports asynch mechanism etc..
6 c) how did you usage web services in your project? As a consumer or producer?
6 d) Is there integration within your projects?
7 Scenario based questions around latency of webservices and backend design to improve it?
8 Questions on GC tuning,
8 a) different algorithms
8 b) Approaches regarding a particular scenario. 4gb initially later moved upto 10gb and so on.
8 c) specify tuning params
9 Single sign on mechanism and familiarity on CAS?
9 a) scenario based questions on Single sign on, interaction within client and server.
10 Unix question, how do you check cpu utilization on a unix box.,
11 General questions
11 a) Are you open to work in an environment where you would have to work on different tech other than java?
11 b) Explained general work structure in ETS, L2 team.
11 c) Travel readiness?
No comments:
Post a Comment