National Australia Bank Senior Analyst II Interview Questions and Answers

Aptitude test contains Logical Reasoning Questions, Analytical Skills questions, and some general Questions, there are no coding questions for it

Q1. First Question is to introduce yourself
Add your answer
Q2. Want to explain me my data science project I explained it in good way
Add your answer
Q3. Gave some scenario that how your project will work for these secnarios
Add your answer
Q4. Asks me about the polymorphism and its example
Add your answer
Q5. Asks about my family background
Add your answer
Q6. Asks whether I am able to relocate
Add your answer

Q1. Can we use POST method instead of get method
Ans. 
Yes, POST method should be used for sending sensitive data or when data length exceeds URL limit.
• POST method should be used when sending sensitive data like passwords or personal information.

• POST method should be used when the data length exceeds the URL limit, as GET has a limit on the amount of data that can be sent.

• GET method should be used for retrieving data from the server without changing anything on the server.
Answered by AI
Add your answer
Q2. Difference between where and having clauses in sql
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• Having clause is used with GROUP BY statement to filter groups based on a condition

• Where clause is applied before grouping, having clause is applied after grouping

• Example: SELECT * FROM table_name WHERE column_name...read more
Answered by AI
Add your answer
Q3. What are the aggregate functions in SQL
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.

• SUM - calculates the sum of values in a column

• AVG - calculates the average of values in a column

• COUNT - counts the number of rows in a result set

• MIN - finds the minimum value in a column

• MAX - finds the maximum value in a column
Answered by AI
Add your answer
Q4. What is the difference between path params and query params
Ans. 
Path params are part of the URL path, while query params are appended to the URL after a '?'
• Path params are used to identify a specific resource in the URL path, while query params are used to filter or sort the resources

• Path params are defined in the URL path itself, such as /users/{id}, while query params are appended to the URL, such as /users?sort=asc

• Path params are typically used for mandatory parameters, while qu...read more
Answered by AI
Add your answer
Q5. Write a SQL query on inner join (given with a table and data)
Ans. 
SQL query using inner join to retrieve data from two tables
• Use INNER JOIN to combine rows from two tables based on a related column

• Specify the columns to select from each table

• Add a condition to match the related columns in the ON clause
Answered by AI
Add your answer
Q6. Application module to find bugs
Ans. 
One way to find bugs in an application module is through thorough testing and using debugging tools.
• Conduct thorough testing of the application module to identify bugs

• Use debugging tools like breakpoints, logging, and profiling to pinpoint and fix bugs

• Implement automated testing to catch bugs early in the development process
Answered by AI
Add your answer

Q1. About previous project
Add your answer
Q2. Python code and some sql quries
Add your answer

Q1. Mostly Resume based questions
Add your answer
Q2. Are you ok with the location
Add your answer

Q1. Who is the vice president of india
Add your answer
Q2. Resume based questions against
Add your answer

Banking related and communication skills along with technical

Q1. What is lending process
Ans. 
Lending process involves the steps taken by financial institutions to evaluate, approve, and disburse loans to borrowers.
• Borrower submits loan application with required documents

• Financial institution evaluates borrower's creditworthiness

• Loan is approved or denied based on evaluation

• If approved, terms and conditions are set including interest rate and repayment schedule

• Funds are disbursed to borrower
Answered by AI
Add your answer
Q2. What is australian market
Ans. 
The Australian market refers to the financial market in Australia where securities are bought and sold.
• The Australian market includes the Australian Securities Exchange (ASX) where stocks, bonds, and other securities are traded.

• It is influenced by factors such as the country's economic performance, government policies, and global market trends.

• Key industries in the Australian market include mining, finance, healthcare,...read more
Answered by AI
Add your answer

Q1. Accounting entries for Bond
Ans. 
Accounting entries for bonds involve recording the issuance, interest expense, and amortization of premium or discount.
• Record issuance of bonds at face value as a liability and cash received as an asset

• Recognize interest expense over time using effective interest rate method

• Amortize premium or discount on bonds using straight-line or effective interest rate method
Answered by AI
Add your answer
Q2. What is Credit Default Swap
Ans. 
A Credit Default Swap (CDS) is a financial derivative contract that allows an investor to hedge against the risk of default on a debt instrument.
• CDS is essentially a form of insurance against the default of a borrower or issuer of a debt security.

• The buyer of a CDS makes periodic payments to the seller in exchange for protection against default on a specified debt obligation.

• If the borrower defaults, the seller of the ...read more
Answered by AI
Add your answer

Q1. What is data analyst
Ans. 
A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.
• Collects data from various sources

• Cleans and processes data to ensure accuracy

• Analyzes data using statistical methods and tools

• Interprets data to identify trends and patterns

• Presents findings and recommendations to stakeholders
Answered by AI
Add your answer
Q2. Asked question regarding project mention
Add your answer