ICICI Securities Sales Officer Interview Questions and Answers for Freshers

Banking involves accepting deposits and lending money. Major items in banking balance sheet include assets, liabilities, and equity.

• Banks accept deposits from customers and use the funds to make loans to other customers

• Assets on a bank's balance sheet include cash, loans, and investments

• Liabilities on a bank's balance sheet include deposits and borrowings

• Equity on a bank's balance sheet represents the value of the bank...read more

HashMap is a data structure that stores key-value pairs, while Concurrency Map allows for safe concurrent access.

• HashMap internally uses an array of linked lists to store key-value pairs.

• Concurrency Map implementations like ConcurrentHashMap use locks or other mechanisms to allow safe concurrent access.

• HashMap allows for null keys and values, while ConcurrentHashMap does not allow null keys or values.

• Concurrency Map im...read more

Optimizing SQL Joins involves using proper indexing, limiting the result set, and avoiding unnecessary joins.

• Use indexes on columns involved in join conditions to improve performance

• Limit the result set by using WHERE clause to filter out unnecessary rows before joining

• Avoid unnecessary joins by only joining the tables that are needed for the query

Optimizing performance involves setting clear goals, providing feedback, offering training and development opportunities, and fostering a positive work environment.

• Set clear goals and expectations for employees

• Provide regular feedback and recognition for good performance

• Offer training and development opportunities to help employees improve their skills

• Create a positive work environment that promotes collaboration and c...read more