You are given a Employee table having emp_id,name,dept_id.etc where dept_id is refering to Department table haing attributes dept_id,dept_name. 1. Find dept_name of employees using both tables. 2. Some employees have not been assigned dept there entry in dept_id is NULL. So find the dept_name of employess having department and NULL entries.
As, I included my Frontend development internship experience in the resume; the interviewer asked me a lot of questions related to CSS, JavaScript and frameworks used; to check the authenticity of my internship experience.
Tell me about Yourself.
Design ER diagram for a hospital database
About project?
Q: Tell me something about OOP concepts?
Q: You have 9 balls, 1 of them is defective. What is the efficient way to find the defective ball?
Explain join
The final phase was a direct meeting with the CEO and a senior engineer. After introductions, I was asked to walk through some parts of my code during the on-site test and was given suggestions on how I could make them better. The CEO asked about my career goals and described the company goals and activities.
The screening test was several stages, the first few were about calling APIs and getting the answers from the responses in order to advance to the next stage. The final response was a list of strings formed by encoding a valid URL using the base64 scheme, splitting the encoded URL after every N (forgot the number) characters and shuffling the split strings. We had to construct the valid URL from the list of randomly arranged strings. Once generated, we could go to the final form and submit it.
Viewing 661 - 670 interview questions