i
Infosys
Filter interviews by
Clear (1)
DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.
DBA is responsible for installing, configuring, and upgrading database software.
They monitor database performance and troubleshoot issues.
DBA designs and implements backup and recovery strategies to prevent data loss.
They also manage user access and security permissions within...
Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.
Regularly monitor database performance and usage
Perform routine maintenance tasks such as applying patches and updates
Take regular backups to ensure data integrity and disaster recovery
Implement security measures to protect the database from unauthorized access
Optimize database performanc
I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.
A lean supply chain focuses on minimizing waste and maximizing efficiency in the flow of goods and services.
Focuses on reducing waste in all aspects of the supply chain
Emphasizes efficiency in production, transportation, and distribution
Involves continuous improvement and optimization of processes
Utilizes tools like Just-In-Time inventory management and Kanban systems
Examples include Toyota's production system and Dell
Kaizen is a Japanese business philosophy of continuous improvement, while Kanban is a scheduling system for lean manufacturing.
Kaizen focuses on making small, incremental improvements in processes and systems.
Kaizen involves all employees in the organization and encourages suggestions for improvement.
Kanban is a visual scheduling system that helps manage workflow by limiting work in progress.
Kanban uses cards or signal...
I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Jul 2023. There was 1 interview round.
A config file is a file that contains configuration settings for a software application or system.
Config files are used to store parameters and settings that determine the behavior of an application or system.
They are typically written in plain text format and can be edited using a text editor.
Config files are often used to specify database connection details, server settings, application preferences, etc.
Examples of c...
RAC DBA stands for Real Application Clusters Database Administrator. It is responsible for managing Oracle databases that are part of a cluster.
RAC DBA manages Oracle databases that are part of a cluster
It involves configuring and maintaining the cluster infrastructure
Ensures high availability and scalability of the database
Performs tasks like installation, patching, backup, and recovery in a clustered environment
Infosys interview questions for designations
I applied via Company Website and was interviewed before Apr 2023. There were 2 interview rounds.
Background processes are processes that run in the background of an operating system without direct user interaction.
Background processes in Oracle Database include PMON, SMON, DBW0, LGWR, CKPT, and others.
These processes perform tasks such as managing memory, writing data to disk, and ensuring data consistency.
They help in maintaining the integrity and performance of the database system.
Background processes are essent...
DBWR stands for Database Writer and LGWR stands for Log Writer in Oracle Database.
DBWR writes modified data blocks from the database buffer cache to the data files on disk.
LGWR writes redo log entries from the redo log buffer to the redo log files on disk.
DBWR and LGWR are background processes in Oracle Database responsible for ensuring data integrity and consistency.
DBWR and LGWR work together to ensure that changes m...
A database is a collection of related data, while an instance is the set of memory structures and background processes used to access the database.
Database is the physical or logical container for data, while instance is the set of processes and memory structures used to access the database.
Multiple instances can access the same database, but each instance has its own memory and processes.
Database is persistent, while ...
LGWR stands for Log Writer and is a background process in Oracle database responsible for writing redo log entries to disk.
LGWR ensures that changes made to the database are recorded in the redo log files before committing transactions.
It plays a crucial role in ensuring data integrity and crash recovery.
LGWR writes redo log entries from the log buffer to the redo log files on disk.
It operates continuously in the backg...
Get interview-ready with Top Infosys Interview Questions
A DBA is a database administrator who is responsible for managing and maintaining a company's database system.
Roles include database design, security, backup and recovery, performance tuning, and troubleshooting
Responsibilities include ensuring data integrity, availability, and accessibility
Shift models vary depending on the company's needs, but may include on-call availability and rotating shifts
Examples of database s
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 3 interview rounds.
Control file multiplexing is the process of creating multiple copies of control files to ensure data redundancy.
Create additional copies of control files using the ALTER DATABASE statement
Specify the location and name of the additional control files
Ensure that all control files are accessible and synchronized
Monitor the alert log for any errors related to control files
Data configuration steps involve setting up and organizing data for efficient use.
Identify data sources and types
Determine storage requirements and allocate resources
Define data access and security policies
Configure backup and recovery procedures
Test and validate data configuration
What people are saying about Infosys
Yes, I can remove all the pcs from the lab and keep them in another lab right now.
Ensure all the necessary equipment and tools are available for the move
Coordinate with the lab staff to ensure a smooth transition
Label and document each PC for easy identification and setup in the new lab
Ensure proper packaging and handling to prevent any damage during the move
Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.
The first two numbers of the series are always 0 and 1
The next number is the sum of the previous two numbers
The series goes on infinitely: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...
Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Pr
Algorithm for matrix multiplication
Create a result matrix with dimensions of the two input matrices
Iterate through each row and column of the result matrix
For each element in the result matrix, multiply corresponding row in first matrix with corresponding column in second matrix
Add the products obtained in the previous step to get the final value for the element
I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.
The project involved collecting customer reviews from various sources.
Preprocessing the data by removing stop words, stemming, and tokenizing.
Used Naive Bayes algorithm for sentiment analysis.
The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.
The accuracy of the model was
Developed a web-based project management system for a construction company.
Used PHP and MySQL for backend development
Implemented user authentication and authorization
Designed a responsive UI using Bootstrap
Integrated Google Maps API for location tracking
Enabled file uploads and downloads for project documents
EXTC and IT are not mutually exclusive fields. My knowledge in EXTC complements my skills in IT.
My knowledge in EXTC gives me a strong foundation in electronics and communication, which are essential in the IT industry.
I have also gained programming skills through my coursework and projects in EXTC.
IT is a rapidly growing field with a lot of opportunities, and I believe my skills and knowledge make me a strong candidat...
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for a position that aligns with my career goals
I am excited about the prospect of exploring a new city and culture
I am flexible and adaptable to new environments
I am familiar with several programming languages.
Java
Python
C++
JavaScript
SQL
A leader inspires and motivates while a manager plans and organizes.
Leaders focus on the big picture while managers focus on details
Leaders lead by example while managers delegate tasks
Leaders inspire and motivate while managers enforce rules and policies
Leaders are visionaries while managers are implementers
Examples of leaders: Steve Jobs, Martin Luther King Jr. Examples of managers: Tim Cook, COO of Apple
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for the right job opportunity
I am open to exploring new places and cultures
I understand that relocation may come with challenges, but I am prepared to face them
I am excited about the prospect of starting fresh in a new location
I'm sorry, I don't have that information.
N/A
The TCS aptitude test was challenging but fair.
The test covered a wide range of topics including math, logic, and English.
The questions were designed to test problem-solving skills and critical thinking.
Time management was crucial as there were many questions to answer in a limited time.
Overall, the test was a good indicator of one's aptitude for software engineering.
based on 6 interviews
1 Interview rounds
based on 15 reviews
Rating in categories
Hyderabad / Secunderabad,
Chennai
+15-9 Yrs
Not Disclosed
Technology Analyst
55.3k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50.7k
salaries
| ₹2.8 L/yr - ₹7.8 L/yr |
System Engineer
39.6k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.9k
salaries
| ₹5.1 L/yr - ₹19.6 L/yr |
Senior Associate Consultant
28.2k
salaries
| ₹6.2 L/yr - ₹16.6 L/yr |
TCS
Wipro
Cognizant
Accenture