infosys share infosys dividend infosys careers infosys news infosys india infosys products infosys company infosys moneycontrol
C & C++ Questions
Question: Explain some important differences between C & C++.
Answer: For the interview, you will be checked only for your basic knowledge and key differences like –
| C | C++ |
| C is a procedural language, hence there is no concept of classes, objects, inheritance, encapsulation, and polymorphism. | C++ is an Object-Oriented language. Polymorphism, encapsulation and inheritance are the essences of OOPS. |
| Dynamic memory allocation is done through malloc() and calloc() functions | Memory allocation is done using the ‘new’ operator. |
| Main function can be called from any other functions. | Main function cannot be called from any other functions. |
| No operator and function overloading | It is easy to implement function overloading and operator overloading in C++ |
| You cannot run C++ code in C | You can run most of the C code in C++ |
| For input and output scanf and printf functions are used respectively. | Cin and cout are respectively used for input and output. |
| Reference variables, virtual and friend functions are not supported | These are supported fully |
| Exception handling is not supported | Full support for exception handling |
For your own curiosity, you can read this articale to learn in-depth about the differences.
Question: What are the differences between C++ and Java? Which one do you think is better and why?
Answer: Both are based on OOPS concept. Following are the basic differences –
| C++ | JAVA |
| Platform dependent language | You can write the code and run it anywhere. Java is platform-independent. |
| Used for system programming, for example OSs are written in C++. | Used for application programming, like mobile and web-based applications. |
| Supports both pass by value and pass by reference | Can pass variables only by the value |
| Developers can explicitly write code for pointers. | Java uses pointers internally. Developers can’t write programs i.e. there is restricted support for pointers |
| Supports operator overloading | No support for operator overloading |
| Supports multiple inheritances | Doesn’t support multiple inheritances. (can be achieved through an interface) |
When asked your opinion on which is better, there is no right or wrong answer. You can say what you like about C++ or Java more. For example, I don’t like pointers and Java doesn’t have it, so I can vote for Java. On the other hand, C++ supports operator overloading and passing by reference while Java doesn’t, so I can like C++ more because of this flexibility. This question is just to test if you can analyze and weigh the pros and cons of each.
Frequently Asked Database (SQL) Interview Questions
Question: What is a database schema?
Answer: Schema is a logical representation or structure of the entire database. It defines how the data is organized, associated and stored in the database.
Question: What is RDBMS?
Answer: Relational Database Management System (RDBMS) is a set of programs that helps a developer to interact with the database for creating, updating or deleting data. This is done through queries (SQL). For example, each data element can be a row in the table.
Question: What is the difference between unique key, foreign key and
primary key?
Answer:
Primary key – identifies each row in a table. For example, in the student table, student_id can be the primary key used to access the details of student. student_id will always be different for different students. Can’t be null.
Unique key – set of one or more fields that collectively identify a database record. This should not include the primary key. Unique key can have one null value. For example, student_name and batch_number can be collectively used to identify top students in last 3 years.
Foreign key – a column that references the column of another table to establish the relationship between two tables. Most of the times, the primary key in one table is the foreign key in another. For example, the book table can have student_id as a foreign key that will determine the details of the books a student has taken.
Question: What are clustered indexes?
Answer: Indexes are used to speed the query time to improve performance. Think of it as an index in a book, which makes it easy for you to navigate to a particular page or chapter. Clustered index maintains the physical order of the data in a table. For example, if a clustered index is created on the student_id column of student table, student with student_id 5, will be stored as the 5th row and with id 10 will be in the 10th row, irrespective of the order in which the data is inserted.
Question: What are SQL joins? How to use them to fetch data from multiple tables?
Answer: Joins are used to get results from multiple tables using primary and foreign keys of the related tables. Example –
| table – student | table - books |
| student_id (primary key) | book_id (primary key) |
| student_name | book_title |
| student_batch | student_id (foreign key) |
| student_department | book_author |
Now, to get the name of the books that a student has taken, we can simply write a query as –
select student.student_name, student.student_batch, book.book_title, book.book_author from student, book where student.student_id = book.student_id;
The results will be –
| student_name | student_batch | book_title | book_author |
| Karan | 2008 | C++ for beginners | Yashwant Kanetkar |
| Karan | 2008 | Java for dummies | Kathy Sierra |
Question: What are SQL triggers?
Answer: Triggers are stored procuduse that are invoked when some event like insert, update or delete happens in the database on a particular table.
For More SQL Interview Questions Read
Frequently Asked HTML Interview Questions
Question: What is the full form of HTML?
Answer: Hypertext Mark-up Language.
Question: Name some common tags used in HTML.
Answer:,- main contant
Question: What is a frame?
Answer: Frames can divide the html page into separate windows. Each frame is a different html document loaded using ‘src’ attribute.
HR Questions for Freshers
Question: Tell me about yourself.
Answer: You can start with your name, education, previous experiences (If any)
Question: Some questions from your resume – regarding projects, previous projects etc…
Answer: Take interest to give more details and answer the follow-up questions, if any.
Question: What is the most difficult challenge you have faced working in a team/project?
Answer: This could be an individual issue like a code problem that you sat on for a couple of days, or an external issue like getting approval for some project.
Question: What are your strengths and weaknesses?
Answer: Be honest. Support your answers with examples of how you have demonstrated the said strength or weakness. For example, “I can’t switch to another task unless I complete the current one. I have experienced it in previous projects. “
Question: Why do you think Infosys is a good choice for your career?
Answer: This is a tricky one. As a fresher, your first thought would be to clear any interview that fetches you a job. For this question, you have to do some homework. Go through the Infosys website, read about what they do, find out how your career goals match their vision and talk about that. Tell them how you can grow as an individual in the company while providing your best services to the company.
Question: What do you know about Infosys?
Answer: Again, you should visit the Infosys, read about their founder, CEO, work culture, infrastructure, the training campus and other interesting information that has attracted you into attending this interview.
Question: What are your long-term career goals?
Answer: Talk about where you see yourself in the next 5 or 10 years. It can be as simple as buying a new house or seeing yourself as the project head in the Netherlands. This helps the interviewer know about your personal ambitions.
Question: Why should we hire you?
Answer: You can tell about the values you can bring to the company and the qualities you possess that can help the company grow. For example, you look at a project from a bigger perspective – how will it impact the business, how can any change bring more success to the customer and so on.
Don’t just say you are a team player or a smart-worker. Tell something that is unique to you.
HR Questions for Experienced Candidates
The below set of questions can be asked in the technical round also. In that case, you will not have a separate HR round and when you meet the HR, he will directly ask you about your salary expectations and other general stuff. These questions are subjective and there is no right or wrong answer. Everyone has different ways of handling others. The main test here is the communication skills – how transparent and open are you for resolving issues. Would you set up a meeting and calmly explain your points with facts, or would you just sulk and complain? Would you ask for help when you are stuck or get worked up because you want to do-it-all by yourself? These are personal views and you have to build your own answer as these will be a show of your personality.
- If you have a difference of opinion with your immediate manager, how will you explain your point of view to him?
- If you had to change one thing in your past, what would that be?
- If there is a conflict between you and your team member, how will you resolve it amicably?
- Have you resolved differences between two team members who report to you? How will you do so in the future?
- Have you handled any teams before? How would you motivate your employees?
- Let us say your manager gives you a high priority task, your onsite coordinator calls you up and says he wants a task done urgently and your team members are facing a critical issue which needs your immediate attention. What would you do?
All is well that ends well…
Other than these, general questions regarding your salary expectations, work timings, and flexibility, location, a personal profile will be asked. HR will also tell you about the company’s growth, future plans, and overall work culture. Just go with confidence, think positively, and be honest. You can crack it!
Wanna prepare more? Here is the best book to crack any programming interview:
Geographical presence
Infosys has 82 sales and marketing offices and 123 development centres across the world as of 31 March 2018, with major presence in India, United States, China, Australia, Japan, Middle East and Europe.[23][24]
In 2019, 60%, 24%, and 3% of its revenues were derived from projects in North America, Europe, and India, respectively. The remaining 13% of revenues were derived from the rest of the world.[25]
Acquisitions
| Name of the acquired company | Based in | Acquisition cost | Acquisition date | The business of an acquired company |
|---|---|---|---|---|
| Expert Information Services | Australia | US$23 million | Dec 2003 | IT service provider |
| McCamish Systems | USA | US$38 million | Dec 2009 | Insurance and financial services |
| Portland Group | Australia | AUD 37 million | Jan 2012 | Strategic sourcing and category management |
| Lodestone Holding AG | Switzerland | US$345 million | Sep 2012 | Management consultancy |
| Panaya | Israel | US$200 million | Mar 2015 | Automation technology |
| Skava | USA | US$120 million | Apr 2015 | Digital experience solutions |
| Noah-Consulting | USA | US$70 million | Nov 2015 | Information management consulting services |
| Skytree | USA | Undisclosed amount | Apr 2017 | Machine learning |
| Brilliant Basics | UK | GBP 7.5 million | Aug 2017 | Product design and customer experience |
| Fluido Oy | Finland | EUR 65 million | Oct 2018 | Salesforce advisor and consulting partner |
| WongDoody | USA | US$75 million | Jan 2019 | Advertising and creative strategy services |
| Stater N.V. | Netherlands | EUR 127.5 million | Apr 2019 | Mortgage services |
| Simplus | USA-AU | TBD | Feb 2020 | Salesforce Partner |
| Kaleidoscope | USA | US$42 million | Sep 2020 | Product design and development |
| GuideVision | Czechia | EUR 30 million | Oct 2020 | ServiceNow partner |
COMMENTS