Me postulé a través de una facultad o universidad. El proceso tomó 1 día. Acudí a una entrevista en Open Access Technology International (Sahāranpur) en feb 2023
Entrevista
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)
Preguntas de entrevista [1]
Pregunta 1
what are indexes, temporary tables, procedures and functions, joins, group by, joins. Data adaptor in c#
Me postulé a través de una facultad o universidad. El proceso tomó 4 semanas. Acudí a una entrevista en Open Access Technology International en may 2021
Entrevista
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
Me postulé a través de una facultad o universidad. El proceso tomó 2 días. Acudí a una entrevista en Open Access Technology International (Mohali, Punjab) en abr 2017
Entrevista
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.