ICICI Bank Interview Questions and Answers

Optimizing database query performance involves indexing, minimizing data retrieval, using efficient query syntax, and optimizing server resources.

• Create indexes on frequently queried columns to speed up data retrieval

• Minimize the amount of data being retrieved by using specific WHERE clauses

• Use efficient query syntax such as JOINs instead of subqueries for better performance

• Optimize server resources by allocating enough memory and CPU power for the database server

A stack is a data structure that follows the Last In First Out (LIFO) principle, while a queue follows the First In First Out (FIFO) principle.

• Stack: Elements are added and removed from the top of the stack. Example: stack of plates.

• Queue: Elements are added at the rear and removed from the front of the queue. Example: people waiting in line.

• Stack: Operations include push (add) and pop (remove).

• Queue: Operations include enqueue (add) and dequeue (remove).

A program to reverse a string involves iterating through the characters of the string and appending them in reverse order.

• Iterate through the characters of the string from end to start.

• Append each character to a new string in reverse order.

• Return the reversed string.

An IP address is a unique numerical label assigned to each device connected to a computer network.

• IP addresses are used to identify and locate devices on a network.

• There are two types of IP addresses - IPv4 (e.g. 192.168.1.1) and IPv6 (e.g. 2001:0db8:85a3:0000:0000:8a2e:0370:7334).

• IP addresses can be static (manually assigned) or dynamic (assigned by a DHCP server).

Defensive security is a proactive approach to protecting systems and data from cyber threats by implementing measures to prevent attacks.

• Focuses on preventing security breaches rather than reacting to them

• Includes measures such as firewalls, antivirus software, encryption, and access controls

• Involves regular security assessments and updates to stay ahead of potential threats

Offensive security refers to the proactive and aggressive approach to identifying and mitigating security vulnerabilities in systems.

• Offensive security involves actively attempting to exploit vulnerabilities in systems to identify weaknesses.

• It includes techniques such as penetration testing, social engineering, and red teaming.

• The goal of offensive security is to improve the overall security posture of a system by identifying and fixing vulnerabilities before malicious actor...read more

HR processes involve recruitment, onboarding, training, performance management, and employee relations.

• Recruitment: Attracting, screening, and selecting qualified candidates for job openings.

• Onboarding: Orienting new employees to the organization, its culture, and their roles.

• Training: Providing learning opportunities to enhance employee skills and knowledge.

• Performance Management: Setting goals, evaluating performance, and providing feedback to employees.

• Employee Relations: ...read more