Placement Papers - Pantheon

Interview for the position of SQL Developer- Software Engineer (Fresher).

1)Written Test.
2)Technical Round.
3)Skype interview with US boss.

Written Test: ( 30 Minutes )
Aptitude: 15 Questions. 
Java: 10 Questions.
SQL: 5 Questions.
HTML: 3 Questions.

Aptitude topics: (Train problems, Time and Distance, Time and Work, Problems on Ages, Profit and Loss, Permutation and Combination, Number Series, Probability on Playing cards, Problems on percentage)

Technical Round: With Team Lead.
Tell about Yourself.
You passed out in 2016. What did you do and did you learn any courses in these 2 years?
What skills you have or What technologies you know?
Write logic to swap two numbers without using a temporary variable.
Write logic to generate Fibonacci series.
Do you know about HTML and CSS?
Write in CSS the DIV box which has padding and width and height.
Write in HTML and CSS a table which has three rows and three columns.
Write a query to join tables and find the employee with salary greater than 5000.
Write a query to find the second highest salary in an Employee table.
What do you know about SQL Server? What are constraints in SQL Server?
What is the need of constraints?
What is a stored procedure and how to create a stored procedure?
What is Normalization in databases and types?
Do you about OOPS concepts? Explain them
Do you know Java (I told i know C# and Dotnet and so he asked me in C# )
Do multiple inheritance possible in C#.
What are interfaces and Abstract classes in C# and what are the differences between them?                               
Explain the academic projects in your B.Tech.
Are you willing to work in shift timing from 2 PM to 10 PM sometimes upto 11 PM?
What are your expectations from the company?

Skype interview with US Boss: 

How are you?
What is your Educational qualification?
What is your Major in your university? (Major means branch or stream in B-Tech)
It seems you have passed out in 2016. May I know why didn't you take a job for 2 years?
So, you don't have any work experience. Hm, can you explain me about your academic projects which you have mentioned in your resume?
Do you knowledge on SQL and HTML. Have you done any projects using SQL and HTML.
You are saying that you have knowledge on SQL SERVER and SSMS. That's good
Have you done any course on DATABASE in your university?   
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
If you got selected, then you will be working with Odyssey product team. Co-ordinating with the development team, designing team and you need to work on SQL Queries and HTML. Initially you will be working on SQL and HTML and working with a global team.

ME: What technologies i will be working on in future if I get selected?
INTERVIEWER: You will get opportunity to work on JAVA, SQL, HTML and you will get opportunity to work on many other technologies.
INTERVIEWER: We are going to develop new product and we are hiring you for that team and you will be working for that team. We have offices in America, Asia and Europe. Are you interested to work in shift timings of 2 PM to 10 PM?
Do you live nearby to the office?
What do you think your Strengths are?
Do you have any questions to me?

OK then, We will get back to you tomorrow about your interview result and finally tomorrow I got the call from HR department that I was selected for the job position.