Other Interview Experiences - 3 (Persistent + Deqode + Barclays + Amdocs + LTI + Capgemini + UBS + Pubmatic + Rakuten)
1. Difference between SQL and NoSQL.
2. What is surrogate key and foreign key?
3. What are joins?
4. Difference between factual table and behavioural table?
5. Details about projects.
6. How you manage your project among team?
7. What is your role in project work ,give detailed explanation?
8. How your team manage delays in project work?
9.Tell me about yourself.
10. Puzzle of 8 balls. Where 7 are of same weight and 1 with different weight. And you are provided with Balance scale. Tell minimum number of scaling required.
11. Guesstimate: You owns Asian paints and you have to make a quotation of painting College arena.
12. Why you want to be part of .....?"
1.implement array's question , find number that have highest frequency in array. (we should print more than one number if they have highest and same frequency)
2. Can we traverse trees by DFT and BFT.
3.what data structures are used by DFT and BFT?
4.Tell me algorithm of DFT and BFT.
5.Interviewer gave me one schema of blood bank , hospital and person and asked for e-r diagram.She want all concepts should be included in diagram.
6.What is normalization and tell me different types of normalization.
7.Tell me basic use of normalization.
8.asked for different data structures.
9.asked about linked list.
10.advantages and disadvantages of linked list over array.
11. Asked for cycles in linked lists.
12.asked for OOP concepts.
13.asked for real time example of encapsulation.
14.what is multithreading?
(non-technical)
1.Tell me about yourself.
2.interviewer gave me one topic COVID19 and tell me suggest your thoughts like it's impacts on society,etc.
3.asked about my projects.
4.Why you choose computer stream?
5.Why you want .......?
6.Tell me about .....?
7.asked about my family and financial condition.
8.Why you get less or average marks in HSC,academics.
9.ask my hobbies.
10.I answered above question , Photography then interviewer asked me , what are pixels,which camera do you used for photography,etc.
11.Who took ur previous interviews?
12.Asked for experiences of previous interviews."
---------------------------------------------------------------------------------------------------------------
1.What is data structure ,where it is used ?
2 .Types of data structure
3 .Give real life example of those data structures
4 .Queue is structured or non structured ?
5. Give real life example pf each OOP concept
6. What is final method ,final class ,final variable ?
7. Tell about joins with example
8. Primary key can be null or not ?
9. Gave some sql queries to write
10. What is complex query give example where you have used it. "
---------------------------------------------------------------------------------------------------------------
1. Cursor in PL/ SQL.
2. Normalization.
3. Latest oracle version.
4. SQL vs NOSQL.
5. Real-life example of polymorphism.
6. Functional programming definition.
7. Mutable and Immutable classes.
8. Priority queue.
9. Vector vs List.
10. REST API.
11. SAAS, PAAS, IAAS.
12. Shell scripting.
13. What's new in the latest Java version.
14. 2 ways to create thread in Java.
15. Couple of aptitude problems.
16. About Internship (Automation, Selenium).
17. About Projects (Framework used, database used, Scalability).
18. What is success?
19. Which industry interests you(Manufacturing, Oil etc)?
20. Tell me about yourself."
---------------------------------------------------------------------------------------------------------------
ROUND 1
1.Tell me about yourself.
2.he asked me about my projects.
3.what is your BE Project.
4. Questions related to my Internship
5. Print fibonacci series. (from #include to return 0).
6. You have given two strings s1 and s2. Swap these two strings without using 3rd
string.(can be done using substr() function ).
7. Why icertis.
8. Do u have any questions.(always ask atleast 2 questions!)
ROUND 2
1.Tell me about yourself.
2.Who is your fav director.(I said Christopher Nolan and there after we had some discussion on INTERSTELLAR :p)
3. Discussion on my projects.(explain the need, use case, database used, scale of the project, difficulty faced during the project).
4. We had a rapid fire in which he asked me to give unique applications on each domain. Ex. Blockchain, ML AI, IOT,etc (think of something new!).
5.Difference between VR(virtual reality) & AR(augmented reality). I explained him with examples. Always try to explain with examples.
6. Explain multiple inheritance with code. (on notepad).
7. What new feature should instagram have and why?
8. What happens when you enter a website.
9. Any questions.
ROUND 3
1. Interviewer asked me about my previous interviewers.
2. Why icertis.
3. Ghar mein kon kon hai. What does your father do? Ghar mein kitne log rehte hai vagaire.
4. Where do u see yourself in 5 years.(Yeh acchse dena answer)
5. What do u like about us.
6. What qualities should a teamleader have.
7. Your strengths and weakness.
Before facing these type of interviews , plz go through their website and look for their achievements and mention them in HR. they really love it.
8.Finally ask them some questions like joining date n all..
Thank you! :)
---------------------------------------------------------------------------------------------------------------
All Interview Experiences (CS/IT/ENTC)
2020-2021
> Most common interview questions and answers
>Common interview questions and answers for freshers
>Job interview questions and answers
>Short interview questions and answers
>Interview questions to ask
>Best interview questions
>Unique interview questions
>Interview questions for students
Topics Covered
>Interview Questions ✅ ♨️ (C++/Java/SQL/Databases)
>Coding Round Questions✅ 💻
>Programming Questions ✅
>Managerial Round Questions ✅
>HR Round Questions✅🙌
Everything at one place😜😎
No comments:
Post a Comment