ICICI Securities Branch Head Interview Questions and Answers

SQL performance techniques

• Use indexes to speed up queries

• Avoid using SELECT * and only select necessary columns

• Use stored procedures to reduce network traffic

• Avoid using subqueries and instead use JOINs

• Use EXPLAIN to analyze query performance

• Normalize database tables to reduce redundancy

• Use connection pooling to reduce overhead

• Avoid using cursors and use set-based operations instead

A Linux shell script can be used to read and parse a flat file.

• Use the 'read' command to read the file line by line

• Use 'cut' command to parse the data based on delimiter

• Use 'awk' command to filter and manipulate data

• Use 'sed' command to search and replace data

• Use 'grep' command to search for specific patterns in the file

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