i
Infosys
Filter interviews by
Cursors are used in PL/SQL to retrieve and process multiple rows from a result set.
Cursors are like pointers to a result set returned by a SELECT statement.
They allow us to fetch and process rows one by one.
Cursors are typically used in loops to iterate through the result set.
They can be explicit or implicit, with explicit cursors requiring more code.
Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM
Indexes are data structures that improve the speed of data retrieval operations on a database table.
Indexes are created on columns in a database table to quickly retrieve rows based on the values in those columns.
They can be unique, allowing only unique values to be stored in the indexed column.
Indexes can significantly improve the performance of SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
Ex...
What people are saying about Infosys
I applied via Recruitment Consultant and was interviewed in Nov 2021. There were 5 interview rounds.
I was interviewed before May 2023.
Provide various round for aptitude test
Provided various round of coding test questions
I was interviewed before Jan 2024.
I was interviewed in Dec 2024.
I applied via Company Website and was interviewed in Dec 2024. There were 5 interview rounds.
An aptitude test is an assessment to measure a candidate mental aptitude/mental ability
I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.
5 years of experience in web development
Strong background in computer science
Passionate about software development
My strongest points include problem-solving skills, attention to detail, and ability to work well in a team.
Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.
Attention to detail - I am meticulous in my work and strive for perfection in every task.
Team player - I collaborate effectively with colleagues, communicate openly, and contribute positively to group projects.
I regularly use Java, Python, and SQL in my work as a Software Developer.
Java
Python
SQL
A group discussion is a structured conversation in which participants share their ideas, perspectives, and solutions on a specific topic.
I am motivated to seek employment at Wipro because of their reputation for innovation and opportunities for growth.
Impressed by Wipro's track record of delivering cutting-edge solutions
Excited about the chance to work with a diverse and talented team
Eager to take advantage of Wipro's professional development programs
My long-term career goal is to become a lead software developer and eventually move into a management role.
Advance to a lead software developer position
Gain experience in managing a team of developers
Develop strong leadership and communication skills
Continue learning new technologies and staying updated with industry trends
Assignment details refer to the specifics of an assignment, including any documents and/or emails or subsequent correspondence between the company and the client.
I applied via Walk-in
There are various types of constraints in DOT NET development, including primary key, foreign key, unique, check, and default constraints.
Primary key constraints ensure each record in a table is unique.
Foreign key constraints enforce referential integrity between tables.
Unique constraints ensure that all values in a column are distinct.
Check constraints validate the data before it is inserted or updated.
Default constra...
Independent class can be instantiated while abstract class cannot be instantiated directly.
Independent class can be directly instantiated using the 'new' keyword.
Abstract class cannot be instantiated directly, it can only be used as a base class for other classes.
Independent class does not require any derived class to implement its members.
Abstract class can have abstract methods that must be implemented by derived cla
Seeking new challenges, growth opportunities, and a better work-life balance.
Looking for new challenges and opportunities to learn and grow.
Seeking a better work-life balance.
Interested in working with new technologies or in a different industry.
Wanting to advance my career and take on more responsibilities.
Company restructuring or changes in management.
posted on 25 Jan 2025
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
Technology Analyst
56.2k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
System Engineer
39.2k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.3k
salaries
| ₹4.3 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture