Reserve Bank Information Technology Interview Questions, Process, and Tips

Object oriented programming, logical technical

Q1. What is joins , ddl,dml,ddl,TCL command
Ans. 
Joins are used to combine rows from two or more tables based on a related column. DDL, DML, and TCL are SQL commands for data manipulation and transaction control.
• Joins are used in SQL to retrieve data from multiple tables based on a related column.

• DDL (Data Definition Language) commands are used to define the structure of database objects like tables, indexes, etc.

• DML (Data Manipulation Language) commands are used to ...read more
Answered by AI
Add your answer

Test time 35 min, based on Python SQL Stats

Q1. Explain ML algorithms
Ans. 
ML algorithms are mathematical models used to identify patterns and make predictions from data.
• ML algorithms can be supervised, unsupervised, or semi-supervised

• Supervised algorithms include linear regression, decision trees, and neural networks

• Unsupervised algorithms include k-means clustering and principal component analysis

• Semi-supervised algorithms combine elements of both supervised and unsupervised learning

• ML algo...read more
Answered by AI
Add your answer
Q2. Explain SQL joins, explain join in a given situation
Ans. 
SQL joins are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query.

• Common types of joins are inner join, left join, right join, and full outer join.

• Joining tables can be done using the JOIN keyword and specifying the columns to join on.

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;

• Joins can be used to c...read more
Answered by AI
Add your answer

Q1. Explain projects you have worked
Add your answer
Q2. The algorithm used in the project (in my case LSTM)
Ans. 
The algorithm used in the project is LSTM.
• LSTM stands for Long Short-Term Memory and is a type of recurrent neural network.

• It is commonly used for sequential data analysis such as time series forecasting, speech recognition, and natural language processing.

• LSTM networks have the ability to remember long-term dependencies and avoid the vanishing gradient problem.

• They consist of memory cells, input gates, output gates, a...read more
Answered by AI
Add your answer
Q3. Why LSTM? how does it work?
Ans. 
LSTM is a type of recurrent neural network that can handle long-term dependencies.
• LSTM stands for Long Short-Term Memory.

• It uses gates to control the flow of information.

• It can remember information for a longer period of time compared to traditional RNNs.

• It is commonly used in natural language processing and speech recognition tasks.

• LSTM has been shown to be effective in predicting stock prices and weather patterns.
Answered by AI
Add your answer

There will be 1 test which inlcude functional questions and general apti questions. Its tough. Duration was 43 mins

Q1. There were 2 interviewers. Questions will be based on whatever is in Resume and functional questions relevant to the JD
Add your answer

Q1. This round was with 1 senior person and again question based on the project which are handled and about functionality
Add your answer

Q1. This was with Vertical head. It was only for 3-4 mins and was more of personal questions. About youself, family, career background etc.
Add your answer

Q1. No question, thank you very much.
Add your answer

Q1. Need certificate only, thank you very much.
Add your answer
Q2. About myself, thank you very much.
Add your answer
Q3. House address, thank you very much.
Add your answer
Q4. Educational qualification, thank you very much.
Add your answer