J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 1 jour. J'ai passé un entretien chez Open Access Technology International (Sahāranpur) en févr. 2023
Entretien
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)
Questions d'entretien [1]
Question 1
what are indexes, temporary tables, procedures and functions, joins, group by, joins. Data adaptor in c#
J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 4 semaines. J'ai passé un entretien chez Open Access Technology International en mai 2021
Entretien
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
J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 2 jours. J'ai passé un entretien chez Open Access Technology International (Mohali, Punjab) en avr. 2017
Entretien
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.