Aris Global Java & PL/SQL Developer Interview (Mysore Bangalore)

Experience - (2 - 4 Years).
Technology Looking For - Javascript, PLSQL, Java. 
First Round - Technical.
Interviewer - Senior Consultant
Mode of Interview - Telephonic(Duration: 0:40 hour).
Day - I.
1. Tell me about yourself?
2. What are the SQL codes you are writing on daily basis?
3. Explain me some DDL & DML SQL codes.
4. What are the joins you have used in your work?
5. What are the differences between left outer join and full outer join?
6. How do you use SQL Inject in your project?
7. What is Views, and why to use it?
8. How will you use procedures? Explain it in detail what is procedures and what are it's components.
9. What are sub-queries and why to use it?
10. What are the differences between Truncate and Delete?
11. What are packages?
12. What are the functions?
13. Explain me the complete code of how did you use web services in your projects?
14. Which design patterns you have used?
15. How to inject SQL codes in java codes?
16. How did you use the Controller in your project?
17. Why to use self join?
18. Do you know how to use Data Migration?
19. How two threads can use the same object, explain me the complete code?
20. What is collection and which collection did you use?
21. Why to use Map?
22. What are the differences between HashMap and HashSet?
23. What is garbage collection in java?
24. Explain me the complete hierarchy of Collection.
25. Have you used JavaScript earlier?
26. What are the differences between Service tickets and feature tickets in jira?
27. What are git branches you were using in previous company?
28. How are you?
29. How are the days passing in lock-down?
30. From where are you arranging food items in such situation?

Second Round - Technical
Interviewer - Associate Team Lead
Mode -Telephonic.
Day - (I+7).

1. Tell me briefly about yourself.
2. What is garbage collection and how many types of garbage collection are there?
3. What are the java features?
4. What are oops features?Explain briefly all of them.
5. What is marker interface and what are its usage?
6. What are checked and unchecked exception and how to create that?
7. What is priority queue?
8. What is wrapper class and what are it's usage?
9. What are the difference between Synchronized and concurrent HashMap?
10. What are the differences between procedures and functions?
11. What is left outer join?
12. What are the types of external joins?

Third Round - Managerial Round.
Interviewer - Senior  Manager
Mode - Microsoft Teams(Video Conference)  
Day - (I+7)

1. Tell me about yourself.
2. What is abstraction?
3. What is multiple inheritance?
4. What is diamond problem in multiple inheritance and how to avoid that?
5. What is JIT Compiler?
6. How many types of class loaders are there?
7. What is the default value of local static variable?
8. What is the default value of static and instance variables?
9. What is package and why is it used?
10. What is virtual method in java?
11. What is multitasking and multithreading?
12. What is restful webservices and how did you use it?
13. How do you rate yourself in sql/plsql
14. What is trigger and Views?
15. Difference between simple and complex views?
16. What are joins? what are the types of joins?
17. How do you tune your sql with database?
18. Fourth Round - With Director or VC.

Fourth Round.
Interviewer - Senior Director
Day - (I+11).

1. Which company you are currently you are working in?
2. What are the things you have worked on in java technology?
3. How heavily are you involved in writing PLSQL  Queries as You are basically Java Developer?
4. How do you trouble shoot your problem?
5. What kind of work do you do on daily basis? Explain each and everything.
6. What are the tools you used in your work for various purpose?
7. Explain the flow when somebody hits enter button on browser then how it flows to back-end and interacts with database and how it returns the result to the browser again?
8. Are you aware about Java Script? Have you worked on it?
9. How long will you take to learn Java Script?
10. How open you are in learning new technology?
11. In which category you keep yourself, java developer or plsql developer?

Joining - (I+22)


Investor & Coder.

Comments

  1. AnonymousMay 2, 2020 at 12:40 PM

    Found this Post Very Useful and Helpful for Interview .
    Thanks a lot.

    ReplyDelete

Post a Comment

Thank You for reading our post.
Your comment or feedback encourages us to improve the quality of content.
Don't forget to follow/subscribe to get the latest post.

Popular posts from this blog

Xylem bangalore : Senior Java Developer.

Dated - May 2020 1st Round - HackerRank Test. Day - I   Question:  Java program for performing the arithmetic addition. Question:  Java program to implement deep cloning. Question: Arrange the Words A Sentence is defined as a string of space separated words that starts with a capital letter followed by lowercase letters and spaces, and ends with a period. That is, it satisfies the regular expression ^ [A-Z][a-z] *\.$. Rearrange the words in a sentence while respecting the following conditions. Each word is ordered by length, ascending. Words of equal length must appear in the same order as in the original sentence. The rearranged sentence must be formatted to satisfy the regular expression  ^ [A-Z][a-z] *\.$ Example 1. sentence= Cats and hats. Order the sentence  by word's length and keep the original order for the words with same length. Length 3: {and} Length 4: {Cats, hats} Example 2. Input: "The lines are printed in reverse order." Output: "In the ...
Read more

Core Java Interview Question's Answers - 2

   What is overloading? The process of writing multiple methods with the same name in a class is known as Method Overloading . Here parameter list must be different in terms of Number or Order or Type of parameter( NOT ). Method name and parameter list together is known as Method Signature so in short we can say in case of Overloading Method Signature must be different.  Method Signature does not include Return type of method so Return type can be anything. Method Overloading is also known as Early Binding or Compile Time Polymorphism or Static Polymorphism . It is known as Early Binding because from the invocation statement which actual version of methods will be invoked, this binding is made earlier the execution of program by  the compiler. It is known as Compile Time Polymorphism because Compiler is making decision during the Compilation process about which exact methods. What is overriding? If we are not okay with the m...
Read more

Zensar Java Interview Questions.

Experience - 3 Years. Date - May 2019. Location - Bangalore. 1st Round - Written Test.     Easy and very basic questions from core java and aptitude. 2nd Round. Technical. Tell me about yourself. Explain something about your last project. What are OOPS Concepts? What is the use of Abstract class in java? How your java application interacts with Database? Which JDBC drivers you used? What is callable statement? What is Abstraction? What is Collection? What is difference between ArrayList and LinkedList? 3rd Round. Managerial Round. Tell me about yourself. Tell me something about your family background. Current CTC. Expected CTC. We can give only 25% hike, are you okay? Why Zensar? How longer you can stay with us? How sooner you can join us? Other Comapany's Interview Questions IBM Mphasis Happiest Mind Bridgei2i Mobily E ricsson
Read more