AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Athenahealth Technology Software Engineer Intern Interview Questions and Answers
Athenahealth Technology Software Engineer Intern Interview Experiences
1 interview found
Software Engineer Intern Interview Questions & Answers
20WH1A05F4 THURIMELLA SUJITHA
posted on 4 Sep 2023
I applied via Campus Placement and was interviewed in Aug 2023. There were 4 interview rounds.
Basic aptitude concepts
2 Questions on sorting and profit related question
(4 Questions)
- Q1. Technical questions like oops,sql queries. And previous round coding question different approaches.
- Q2. Sorting question
- Q3. Sql query on 2nd highest salary
- Ans.
Use SQL query with ORDER BY and LIMIT to find the 2nd highest salary.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 1,1 to skip the first highest salary and get the second highest salary
- Q4. Difference between tuple and delete command
- Ans.
Tuple is a data structure that stores a fixed number of elements, while delete command is used to remove data from a database table.
Tuple is used to store multiple values in a single variable, while delete command is used to remove specific rows from a database table.
Tuples are immutable, meaning their values cannot be changed once they are set, while delete command permanently removes data from a table.
Example: Tuple ...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Santhosh M S
Interview Preparation Tips
Experience: Each intern was assigned a individual project and mentor.
In the last week of internship there was project presentation and interview.
interview was easy .For me 50% of the questions were about project and some questions about algorithms and DBMS.
More emphasis was given to the quality of work on project.
General Tips: Working in company is complete different from working on course project. learning many new frameworks required for the project was really challenging.
Programming : Tree, Btree, Tries ..
Operating System: Memory Management
Networks: OSI model
DBMS : basics. they dint ask me any. Show case your interest in big data, servers and passion for technology
Skill Tips: Be confident, even if you don't know the exact answer don't give up tell your approaches to interviewer. some times they will also help you. Software Developer some question s you can ask are: what technologies do your company works on. how are freshers will be selected to different teams in the company.
Skills:
College Name: NIT Surathkal
Anonymous
Interview Preparation Tips
Experience: Quantitative, verbal, reasoning and basic technical questions.
Duration: 1 hour
Total Questions: 50
Round: Technical + HR Interview
Experience: Questions based on data structures, algorithms, and object oriented programming concepts.
Tested basic knowledge in Finance sector especially related to the company.
College Name: Delhi Technological University, Delhi
I applied via Naukri.com and was interviewed before May 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL Joins
- Q2. Swap 2 numbers without 3rd variable
- Ans.
Swapping two numbers without using a third variable
Use arithmetic operations to swap the values
Add the two numbers and store the result in the first variable
Subtract the second number from the result and store it in the second variable
Subtract the second variable from the first variable to get the original value of the second variable
Interview Preparation Tips
2nd Round : Technical Interview
3rd Round : Technical Interview and HR questions
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Python programming questions
- Q2. Custom Exceptional Handling
I appeared for an interview in Oct 2020.
(2 Questions)
Round duration - 70 minutes
Round difficulty - Medium
Timing: Window for 2 days
Environment: Online
Time: 50 Min. for 50 MCQ and 20 min for 2 Coding Questions
- Q1.
Number Pattern Problem Statement
Design a seating arrangement for a high-security meeting. There are 'N' rows of tables set up where the first row contains one table, the second row contains two tables, a...
- Ans.
Design a seating arrangement for a high-security meeting with specific table assignments for security personnel and guests.
Create a loop to iterate through each row from 1 to N.
Assign tables on either end of each row to security personnel.
For rows with only one table, assign it to security personnel.
Display the seating arrangement with the number of people at each table.
Example: For 4 rows, the output pattern is 1, 11,...
- Q2.
Insert Interval Problem Statement
You are provided with a list of 'N' non-overlapping intervals, each defined by two integers, 'start' and 'end', sorted in ascending order by 'start' values. Your task is ...
- Ans.
The task is to insert a given interval into a list of non-overlapping intervals while maintaining sorted order.
Iterate through the list of intervals to find the correct position to insert the given interval.
Merge any overlapping intervals with the given interval.
Update the list of intervals accordingly.
Handle edge cases such as when the given interval completely overlaps with existing intervals.
(1 Question)
Round duration - 45 minutes
Round difficulty - Medium
Timing: Morning
Environment: On MS-Teams
- Q1.
Quick Sort Problem Statement
Sort the given array of integers in ascending order using the quick sort algorithm. Quick sort is a divide-and-conquer algorithm where a pivot point is chosen to partition the...
- Ans.
Quick sort is a divide-and-conquer algorithm that sorts an array by choosing a pivot point and partitioning the array into two parts recursively.
Choose a pivot element (e.g., rightmost element) to partition the array into two subarrays.
Recursively apply quick sort to the subarrays until the entire array is sorted.
Time complexity can be optimized to NlogN in the worst case by selecting the pivot strategically.
Ensure the...
Interview Preparation Tips
Tip 1 : For DS and Algo, keep practicing every day on Leetcode, HackerEarth, and make a habit of participating in contests.
Tip 2 : Projects are vital in interviews, have at least 3 projects on Resume, in the field/profile which you're applying for.
Tip 3 : Give Mock Interviews.
Tip 1 : Resume should be short and keep it under 1 page.
Tip 2 : Include skills that you're 100% confident in.
Tip 3 : Highlight your internships and projects section appropriately
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. What do you know about our company?
- Q2. Are you interested in higher Education?
- Ans.
I value higher education for its role in personal growth and professional development in the tech industry.
Higher education provides in-depth knowledge in specialized areas, such as machine learning or cybersecurity.
It offers networking opportunities with peers and industry professionals, which can lead to collaborations and job opportunities.
Pursuing advanced degrees, like a Master's in Computer Science, can enhance c...
MSA msa
Interview Questionnaire
2 Questions
- Q1. This is swap case
- Q2. Str.swapcase()
- Ans.
str.swapcase() returns a new string with all uppercase letters converted to lowercase and vice versa.
Usage: 'Hello World'.swapcase() returns 'hELLO wORLD'.
It affects only alphabetic characters; numbers and symbols remain unchanged.
This method does not modify the original string; it returns a new one.
Example: 'Python 3.8'.swapcase() results in 'pYTHON 3.8'.
Interview Questionnaire
1 Question
- Q1. How to invoke the xml file using LibXML?
- Ans.
To invoke an XML file using LibXML, use the xmlReadFile() function.
Include the libxml/parser.h header file.
Use the xmlReadFile() function to read the XML file and create a xmlDocPtr object.
Use the xmlDocGetRootElement() function to get the root element of the XML document.
Use the xmlNodeGetContent() function to get the content of a node.
Use the xmlFreeDoc() function to free the memory allocated for the xmlDocPtr object...
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Jul 2022. There were 4 interview rounds.
Apt + coding questions, medium difficulty
(1 Question)
- Q1. Basics qs on oops and known programming language
(1 Question)
- Q1. In-depth of oops and live coding questions
(1 Question)
- Q1. Basics qs like y and what
Athenahealth Technology Interview FAQs
Tell us how to improve this page.
Athenahealth Technology Interviews By Designations
- Athenahealth Technology Member Technical Staff Interview Questions
- Athenahealth Technology Issue Resolution Analyst Interview Questions
- Athenahealth Technology Software Developer Interview Questions
- Athenahealth Technology Integration Analyst Interview Questions
- Athenahealth Technology Mts Software Engineer Interview Questions
- Athenahealth Technology Operations Analyst Interview Questions
- Athenahealth Technology Software Engineer Interview Questions
- Athenahealth Technology Associate Member Technical Staff Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Project Engineer Interview Questions
- Devops Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
|
Member Technical Staff
450
salaries
|  ₹8 L/yr - ₹25 L/yr |
|
Senior Member of Technical Staff
211
salaries
| ₹12 L/yr - ₹39 L/yr |
|
Issue Resolution Analyst
205
salaries
| ₹3 L/yr - ₹7.1 L/yr |
|
Operations Analyst
162
salaries
| ₹2.4 L/yr - ₹6.5 L/yr |
|
Senior Operations Analyst
97
salaries
| ₹3.7 L/yr - ₹7.4 L/yr |
Access Healthcare
S&P Global
IKS Health
Straive
- Home >
- Interviews >
- Athenahealth Technology Interview Questions
