Spherical 1: Goal Examination based mostly on Aptitude, DBMS, Working System, SQL Queries
This spherical was performed offline within the lecture corridor of my faculty.
A complete of 140 college students took this take a look at.
The examination Sheet incorporates 3 sections: Arithmetic/Aptitude, DBMS/Working System, and SQL queries.
You could have maintain over laptop science core topics.
And, sure there was detrimental marking for every improper try, as effectively, i.e., -25%.
A complete of 20 college students have been shortlisted after spherical 1.
Spherical 2: Technical Interview 1: Right here, the entire dialogue was round Java structure, SQL queries, and one query associated to optimization. Questions have been:
Introduce your self
What’s bytecode in Java? Use of it?
What’s JVM?
Can we set up a number of JVMs on one system? If sure, then what would be the profit then?
What are Iterators in Java?
Suppose you’re given a file containing phrases, you need to learn the phrases of the file and do the next operations:
If the phrase size is lower than 5 then immediately retailer it in one other file as it’s.
If a phrase is bigger than 5 after which take away all vowels from it and retailer it in one other file.
How would you optimize the above operations by way of area and time?
Eventually, the interviewer requested a SQL question:
Show the identify of the division, and the depend of scholars in every division from the desk division and scholar.
Round 10 college students have been shortlisted after this spherical.
Spherical 3: Technical Interview 2 (System Design): On this spherical, the interviewer first requested me for an introduction after which requested the next questions:
You must design a meals supply service (you possibly can take the instance of zomato), contemplating all of the required entities concerned, their relationships and operations related to it, and so on. How would you design? What do you assume?
The second query was, Take into account on the consumer facet, there’s a type with a submit button. And after clicking the button, a request has been despatched to the server for processing. Now the issue is, on the consumer facet, the consumer could click on the identical button a number of instances and every time the identical request is shipped to the server. How would you forestall duplicate requests on the server facet?
The third query was associated to database desk design and querying.
You’re given a relation that the coed is related to the division and every scholar can take n variety of programs.
What number of tables do you want to arrange information?
Then he requested me to jot down a question associated to the above configuration (not keep in mind the precise question)
Spherical 4: Technical Interview 3 (UI Design, OOPs, DSA): This spherical once more began with my introduction. And in my resume, there was written react js. So he gave me an issue associated to UI design.
In UI design, I’ve to arrange and keep transitions in pages utilizing react js. The primary web page was the login web page, the second was the house web page with 2 hyperlinks, and hyperlinks related to one web page every. (I defined, I’ll retain login credentials utilizing native storage after login, then utilizing router I’ll redirect to the respective web page after clicking hyperlinks, and also will use hooks to take care of props)
Within the second query from DSA, you’re given a quantity starting from 1-1000, and you need to return a string that incorporates the English format of that quantity. (e.g., 145: One Hundred Forty-5).
One query from the information construction: You’re given a community of pals(think about Fb), see the beneath illustrations:
Pal A
Pal B
The time after they related
F1
F2
T1
F3
F4
T2
F5
F6
T3
F2
F3
T4
Now you could have given queries based mostly on the above connections. For instance, inform the time when F2 related to F4.(Reply: T4). You must inform which information construction you’ll use and what shall be your strategy to unravel this drawback.
Distinction between Methodology Overloading and Methodology Overriding.
What’s Inheritance?
Output prediction (Multilevel Inheritance)
Once more, eventually, he requested to jot down a SQL question by giving a database state of affairs. Discover the topper scholar identify and his division identify from every division from the college database.
Database Tables:
Scholar (id, identify, dept_id, rating)
Division (id, identify)
After this spherical, solely 3 college students left.
Spherical 5: HR Interview:
Inform me about your self
From which metropolis do you belong?
What are your tech pursuits?
Adopted by OOPs ideas
Distinction between Aggregation and Composition
What’s Joins and forms of joins
Cartesian product and real-world instance?
Complete 2 college students have been chosen after this spherical together with me. ????