I applied through college or university. The process took 1 day. I interviewed at Open Access Technology International (Sahāranpur) in Feb 2023
Interview
Have 2 rounds
1. Technical: ask ques. about sql and what you said about your project in your resume. Main is oops concept, js debugging, and most important sql questions like what are indexes, temporary tables, procedures and functions, joins, group by, joins. Data adaptor in c#.
round 2: very simple HR round (ave hi)
Interview questions [1]
Question 1
what are indexes, temporary tables, procedures and functions, joins, group by, joins. Data adaptor in c#
I applied through college or university. The process took 4 weeks. I interviewed at Open Access Technology International in May 2021
Interview
There were three rounds of selection process
1. Written test of Aptitude and technical mcqs.
2. Technical round
3. Hr round
Questions were basic, they don't expect much from fresher. Only thing is if you clear written test then you will be selected. Main focus on SQL
I applied through college or university. The process took 2 days. I interviewed at Open Access Technology International (Mohali, Punjab) in Apr 2017
Interview
Database and other sql queries , it was very comfortable because of interviewer. He was very nice person and made comfortable.
What are tables and Fields?
What is a join?
What are the types of join and explain each?
There are various types of join which can be used to retrieve data and it depends on the relationship between tables.
Inner join.
Inner join return rows when there is at least one match of rows between the tables.
Right Join.
Right join return rows which are common between the tables and all rows of Right hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table.
Left Join.
Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table.
Full Join.
Full join return rows when there are matching rows in any one of the tables. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.
