Citicorp
200+ Swiggy Interview Questions and Answers
Q1. Ways To Make Coin Change
Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make the c...read more
Q2. Non-Decreasing Array Problem Statement
Given an integer array ARR
of size N
, determine if it can be transformed into a non-decreasing array by modifying at most one element.
An array is defined as non-decreasin...read more
Q3. 1)Why do we use redefines 2) In a sortt if we have - Copy, Include, Omit, sort what is the order of processing. 3 ) How do we achieve loop in cobol. 1) What is the structure of cobol. ) What are sort DD Stateme...
read moreAnswering questions related to COBOL, SORT utility, and file usage.
1) Redefines are used in COBOL to allow multiple data items to occupy the same storage space.
2) The order of processing in a SORT statement is: Copy, Include, Omit, Sort.
3) Looping in COBOL can be achieved using PERFORM or EVALUATE statements.
4) The structure of COBOL consists of divisions, sections, paragraphs, and sentences.
5) SORT DD Statements in SORT utility define the input and output files for sorting, ...read more
Q4. A fish using 6 sticks was drawn in a specific direction and was asked to rotate in 180 degrees moving minimum number of sticks possible
Rotate fish drawn with 6 sticks in 180 degrees with minimum stick movement.
Identify the axis of rotation
Move the sticks on one side of the axis to the other side
Ensure that the fish shape is maintained
Only move the necessary sticks to achieve the rotation
Q5. Why do you think almost all the IITs are populated mostly by students from the telugu states?
Historical and cultural factors contribute to the high representation of Telugu students in IITs.
Historically, Telugu-speaking regions have placed a strong emphasis on education and have a high literacy rate.
The Telugu states have a large population, which increases the likelihood of more students applying to IITs.
There are also many coaching centers in the Telugu states that prepare students for the IIT entrance exam.
The culture of migration for education and employment oppo...read more
Q6. Guesstimate to find number of Credit Cards in India
Guesstimate the number of credit cards in India.
Estimate the population of India
Determine the percentage of people who have credit cards
Consider the average number of credit cards per person
Factor in the growth rate of credit card usage
Consider the number of credit card issuers in India
Q7. Which test is used in logistic regression to check the significance of the variable
The Wald test is used in logistic regression to check the significance of the variable.
The Wald test calculates the ratio of the estimated coefficient to its standard error.
It follows a chi-square distribution with one degree of freedom.
A small p-value indicates that the variable is significant.
For example, in Python, the statsmodels library provides the Wald test in the summary of a logistic regression model.
Q8. How to improving the quality and service industries?
Improving the quality and service industries involves focusing on customer satisfaction, continuous improvement, and employee training.
Implementing customer feedback systems to identify areas for improvement
Investing in employee training and development programs to enhance skills and knowledge
Establishing quality control measures to ensure consistent service delivery
Adopting technology solutions to streamline processes and enhance efficiency
Encouraging a culture of continuous...read more
Q9. Are exceptions can be written in a catch block seperated by commas,?
Yes, multiple exceptions can be caught in a single catch block separated by commas.
Multiple exceptions can be caught in a single catch block separated by commas.
This can be useful when handling different types of exceptions in a similar way.
For example: catch (IOException | SQLException ex) { // handle exception }
Q10. 3. How has the Indian Economy performed in the past 2 years?
The Indian economy has experienced mixed performance in the past 2 years.
GDP growth rate has fluctuated
Demonetization and GST implementation impacted the economy
Unemployment rate has been a concern
Inflation has remained relatively low
Foreign direct investment has increased
Agricultural sector faced challenges due to weather conditions
Q11. Citi bank has to enter Indian Market where should it set up its offices?
Citi bank should set up its offices in major cities like Mumbai, Delhi, and Bangalore.
Citi bank should consider the economic and political stability of the region.
The bank should also consider the availability of skilled workforce and infrastructure.
Major cities like Mumbai, Delhi, and Bangalore have a large customer base and a well-established financial sector.
Setting up offices in multiple cities can help the bank reach a wider audience and diversify its operations.
Q12. What is R square and how R square is different from Adjusted R square
R square is a statistical measure that represents the proportion of the variance in the dependent variable explained by the independent variables.
R square is a value between 0 and 1, where 0 indicates that the independent variables do not explain any of the variance in the dependent variable, and 1 indicates that they explain all of it.
It is used to evaluate the goodness of fit of a regression model.
Adjusted R square takes into account the number of predictors in the model an...read more
Q13. Types of swift and how it read it. Like its fields.
Swift is a messaging system used for financial transactions. It has different types and fields for message processing.
Swift messages are categorized into 5 types - MT0xx, MT1xx, MT2xx, MT3xx, and MT9xx
Each type has its own set of fields for message processing
For example, MT103 is used for Single Customer Credit Transfer and has fields like Sender's Reference, Receiver's Reference, Amount, Currency, etc.
Q14. Can you describe a time when you identified a critical business problem through data analysis, and how you used analytics to influence a strategic decision within your organisation? What was the impact of your...
read moreI identified a critical business problem through data analysis and used analytics to influence a strategic decision.
Identified a decrease in customer retention rates through data analysis of customer feedback and purchase history
Used predictive analytics to identify key factors contributing to customer churn, such as pricing changes and product availability
Presented findings to senior management and recommended implementing a targeted marketing campaign to retain at-risk cust...read more
Q15. What is fast wrto performance?hashmap or treemap and why
HashMap is faster than TreeMap wrto performance due to its constant time complexity for most operations.
HashMap has O(1) time complexity for most operations while TreeMap has O(log n) time complexity.
HashMap is implemented using an array of buckets while TreeMap is implemented using a Red-Black Tree.
HashMap is preferred for frequent read operations while TreeMap is preferred for frequent write operations.
HashMap is unordered while TreeMap is ordered based on the natural order...read more
Q16. 1) How do you achieve concurrency in your current job, and write code for it? 2) Write code for Rest API using Springboot, need to write Entity, Service, Repository, and Controller classes? 3)Volatile keywords,...
read moreAnswers to common Java Developer interview questions
1) Concurrency is achieved using multithreading in Java. Use threads, executors, or synchronized blocks. Example: using ExecutorService to run multiple tasks concurrently.
2) Rest API in Springboot: Entity class defines database table, Service class contains business logic, Repository class interacts with database, Controller class handles HTTP requests.
3) Volatile keyword provides visibility guarantee but does not support sy...read more
Q17. 6. What is difference between procedure and function
Procedure is a set of instructions that performs a specific task, while function returns a value after performing a task.
Procedure does not return a value, while function does.
Functions can be called from within expressions, while procedures cannot.
Functions can have parameters passed to them, while procedures can have both parameters and arguments.
Examples of procedures include printing to the console, while examples of functions include calculating a sum or finding the leng...read more
Q18. What are accounting ratios? When is it useful?
Accounting ratios are financial metrics used to analyze and evaluate a company's financial performance.
Accounting ratios are calculated by comparing different financial figures from a company's financial statements.
They provide insights into a company's liquidity, profitability, efficiency, and solvency.
Examples of accounting ratios include the current ratio, return on equity, gross profit margin, and debt-to-equity ratio.
These ratios are useful for investors, creditors, and ...read more
Q19. Why do you think this works? What are the drawbacks?
This question is asking for an analysis of the effectiveness and drawbacks of a certain approach or solution.
The question is asking for an evaluation of why a particular approach or solution is effective.
The answer should also include an analysis of the drawbacks or limitations of the approach.
Examples and evidence should be provided to support the analysis.
The response should demonstrate critical thinking and the ability to assess the pros and cons of a given solution.
Q20. What are the golden rules of accounting?
The golden rules of accounting are fundamental principles that guide the recording and reporting of financial transactions.
The first golden rule is the Personal Account rule, which states that all personal accounts are debited for the receiver and credited for the giver.
The second golden rule is the Real Account rule, which states that all real accounts are debited for what comes in and credited for what goes out.
The third golden rule is the Nominal Account rule, which states...read more
Q21. Calculate the total no.of accounts that a new bank card get.
The total number of accounts a new bank card can get depends on various factors such as customer demand, marketing efforts, and eligibility criteria.
The number of accounts can vary based on the type of bank card (e.g., credit card, debit card)
Customer demand and marketing efforts play a significant role in acquiring new accounts
Eligibility criteria, such as credit score and income, may determine the number of accounts a customer can open
Examples: A new credit card may attract...read more
Q22. What computer languages are you proficient in?
I am proficient in multiple computer languages including Java, Python, and C++.
Java
Python
C++
Q23. Tell me some more points.If I give you Rs.100, where will you invest it and why?
I would invest Rs.100 in a diversified mutual fund to minimize risk and maximize returns.
Investing in a diversified mutual fund allows for spreading the risk across multiple companies and sectors.
Mutual funds are managed by professionals who have expertise in selecting the right investment opportunities.
By investing in a mutual fund, I can benefit from the power of compounding and potentially earn higher returns over time.
Some examples of popular mutual funds include HDFC Equ...read more
Q24. explain corporate actions and it’s types with examples
Corporate actions are events initiated by a company that can affect its stock price and shareholders.
Types of corporate actions include dividends, stock splits, mergers and acquisitions, spin-offs, and rights issues.
Dividends are payments made to shareholders from a company's profits.
Stock splits increase the number of shares outstanding while decreasing the price per share.
Mergers and acquisitions involve the combination of two or more companies.
Spin-offs occur when a compan...read more
Q25. 1. What are the Java 8 Features you've worked with?
Java 8 introduced several new features including lambda expressions, functional interfaces, and streams.
Lambda expressions allow for more concise and functional programming style.
Functional interfaces enable the use of lambda expressions.
Streams provide a powerful way to process collections of data in a functional manner.
Default methods in interfaces allow for adding new methods to existing interfaces without breaking compatibility.
Optional class helps to handle null values m...read more
Q26. Can I write a try catch block inside a catch Block
Yes, it is possible to write a try catch block inside a catch block.
This is called nested try-catch block.
It is useful when we want to handle different types of exceptions in different ways.
Example: try { //code } catch (ExceptionType1 e1) { try { //code } catch (ExceptionType2 e2) { //code } } }
It is important to avoid excessive nesting as it can make the code difficult to read and maintain.
Q27. What is object-oriented programming (OOP), and can you explain the concepts of shallow copy and deep copy? Additionally, what technology stack would you choose for a project, and what are the reasons behind you...
read moreOOP is a programming paradigm based on the concept of objects, with shallow copy creating a new object with references to the original, and deep copy creating a new object with copies of the original's values.
OOP is a programming paradigm that focuses on objects and classes.
Shallow copy creates a new object that references the original object's data.
Deep copy creates a new object with copies of the original object's data.
Example: Shallow copy in Python - using the copy() meth...read more
Q28. How do you reverse the digits of an integer in an optimal way?
To reverse the digits of an integer, convert it to a string, reverse the string, and convert it back to an integer.
Convert the integer to a string
Reverse the string
Convert the reversed string back to an integer
Q29. Narrate an incidence when you faced difficult challenge in terms of limited resources while leading a team. How did you encounter it?
Q30. How to check outliers in a variable, what treatment should you use to remove such outliers
Outliers can be detected using statistical methods like box plots, z-score, and IQR. Treatment can be removal or transformation.
Use box plots to visualize outliers
Calculate z-score and remove data points with z-score greater than 3
Calculate IQR and remove data points outside 1.5*IQR
Transform data using log or square root to reduce the impact of outliers
Q31. Give one instance of how you bounced back from a failure?
After failing to secure a job, I took up a freelance project and built my skills. Eventually, I landed a better job.
Took up a freelance project to build skills
Networked with professionals in the field
Continued to apply for jobs while working on the project
Improved skills and gained confidence
Landed a better job eventually
Q32. 10. What is difference between soft link and hard link
Soft links are pointers to the original file while hard links are additional names for the same file.
Soft links are created using the 'ln -s' command while hard links are created using the 'ln' command.
Soft links can point to files on different file systems while hard links cannot.
Deleting the original file will render a soft link useless while a hard link will still work.
Soft links have different inode numbers while hard links have the same inode number as the original file.
Q33. What is swaps , equitys , bonds , mbs , rmbs , cmbs, ETF , valuations
Swaps, equities, bonds, MBS, RMBS, CMBS, ETFs, and valuations are all financial instruments used in investment management.
Swaps are agreements between two parties to exchange cash flows based on a notional amount.
Equities are ownership shares in a company.
Bonds are debt securities issued by companies or governments.
MBS, RMBS, and CMBS are types of mortgage-backed securities.
ETFs are exchange-traded funds that track an index or a basket of assets.
Valuations are the process of ...read more
Q34. In an urn there are 100 balls. 60 white, 40 black, 50 spotted 50 non-spotted. What is the probability that a white ball chosen at random will be spotted?
Q35. What are the drawbacks of the traffic analysis done these days(civil engineering traffic analysis)
Traffic analysis drawbacks include limited scope, lack of real-time data, and potential inaccuracies.
Limited scope of analysis may not account for all variables affecting traffic
Lack of real-time data may result in outdated or incomplete analysis
Potential inaccuracies in data collection or analysis can lead to flawed conclusions
Traffic analysis may not account for non-motorized modes of transportation
Traffic analysis may not consider the impact of weather or special events on...read more
Q36. 2. How to replace male with female in Oracle
To replace male with female in Oracle, use the UPDATE statement with the SET clause.
Use the UPDATE statement with the SET clause to replace male with female in Oracle
Example: UPDATE employees SET gender='female' WHERE gender='male'
Make sure to specify the table name and column name correctly
Use WHERE clause to specify the condition for replacement
Q37. How to check multicollinearity in Logistic regression
Multicollinearity in logistic regression can be checked using correlation matrix and variance inflation factor (VIF).
Calculate the correlation matrix of the independent variables and check for high correlation coefficients.
Calculate the VIF for each independent variable and check for values greater than 5 or 10.
Consider removing one of the highly correlated variables or variables with high VIF to address multicollinearity.
Example: If variables A and B have a correlation coeff...read more
Q38. What is the relationship between the price of gold and equity price?
The relationship between the price of gold and equity price is generally inverse.
Gold is often considered a safe haven investment, so when the equity market is performing poorly, investors tend to flock to gold, driving up its price.
Conversely, when the equity market is performing well, investors may shift their focus away from gold, causing its price to decrease.
There can be exceptions to this relationship depending on various factors such as economic conditions, geopolitica...read more
Q39. Guestimation- Assume 7 banks are hiring in top 10 b-schools. How many do you think would be hired in all by the banks, across campuses
Approximately 70-80 students would be hired by the 7 banks across top 10 b-schools.
The number of students hired by each bank may vary depending on their requirements and the quality of candidates available at each campus.
Assuming an average of 10 students per bank per campus, the total number of students hired would be around 70-80.
However, this is just a rough estimate and the actual number may be higher or lower depending on various factors such as competition from other re...read more
Q40. Can you explain how logistic regression handles binary classification, and how you would interpret the coefficients in the model? Additionally what metrics would you prioritise to evaluate the model?
Logistic regression is a statistical model used for binary classification, interpreting coefficients and evaluating metrics.
Logistic regression is a statistical model that predicts the probability of a binary outcome based on one or more predictor variables.
It uses the logistic function to map the input features to a probability between 0 and 1.
The coefficients in the model represent the impact of each predictor variable on the log-odds of the outcome.
Interpreting the coeffic...read more
Q41. What operational issues will you face or need to check after placing the banners?
Operational issues to check after placing banners in banking
Ensure banners are placed in compliance with regulations and policies
Check if banners are visible and readable from a distance
Ensure banners do not obstruct any important information or signage
Check if banners are securely fastened and will not fall or cause harm
Ensure banners are placed in appropriate locations to reach target audience
Check if banners are properly lit and visible during all hours of operation
Q42. What will you consider in moving from a monolithic application to Microservices platform and what strategies you will use ?
Considerations and strategies for moving from monolithic to Microservices platform
Identify and decouple independent components of the monolithic application
Implement API gateway for managing communication between microservices
Use containerization tools like Docker for deployment and scaling
Implement service discovery mechanisms for dynamic service registration and discovery
Implement fault tolerance and resilience mechanisms like circuit breakers and retries
Implement monitorin...read more
Q43. What tools and technologies have you previously worked on?
I have worked with various tools and technologies including Java, Python, SQL, and Tableau.
Proficient in Java programming language
Experience with Python scripting and data analysis libraries
Skilled in SQL for database management and querying
Familiarity with Tableau for data visualization and reporting
Q44. Describe Reconciliation and it's journal entries?
Reconciliation is the process of comparing two sets of records to ensure their accuracy and consistency.
Reconciliation is used in various fields such as accounting, finance, and banking.
It involves comparing two sets of data, such as bank statements and company records, to identify any discrepancies.
The goal of reconciliation is to ensure that the records are in agreement and to identify and resolve any errors or discrepancies.
Journal entries are used to record the adjustment...read more
Q45. What are the return types of an action method in MVC?
The return types of an action method in MVC can be ViewResult, PartialViewResult, JsonResult, RedirectResult, RedirectToRouteResult, ContentResult, FileResult, HttpNotFoundResult, HttpStatusCodeResult, etc.
ViewResult - returns a view to the browser
PartialViewResult - returns a partial view to the browser
JsonResult - returns JSON-formatted data
RedirectResult - redirects to a specified URL
RedirectToRouteResult - redirects to a specified route
ContentResult - returns a user-defin...read more
Q46. Difference between Internal and External table in Hive
Internal tables store data in a Hive-managed warehouse while external tables store data outside of Hive.
Internal tables are managed by Hive and are stored in a Hive warehouse directory
External tables are not managed by Hive and can be stored in any location accessible by Hive
Dropping an internal table also drops the data while dropping an external table only drops the metadata
Internal tables are faster for querying as they are stored in a Hive-managed warehouse
External tables...read more
Q47. How will you handle an out-of-memory exception?
Handle out-of-memory exception by analyzing heap dump and optimizing code.
Analyze heap dump to identify memory leaks
Optimize code to reduce memory usage
Increase heap size if necessary
Use memory profiling tools like JProfiler or VisualVM
Avoid creating unnecessary objects
Use caching to reduce object creation
Implement garbage collection strategies
Q48. How will you handle a irated customer ?
I will handle an irate customer by remaining calm, empathizing with their concerns, and finding a solution to their problem.
Stay calm and composed
Listen actively to the customer's concerns
Empathize with their frustration
Apologize for any inconvenience caused
Offer a solution or alternatives
Follow up to ensure customer satisfaction
Q49. 4.what is difference between delete and truncate
Delete removes specific rows while truncate removes all rows from a table.
Delete is a DML command while truncate is a DDL command.
Delete is slower than truncate as it logs each row deletion while truncate does not.
Delete can be rolled back while truncate cannot be rolled back.
Delete can have a WHERE clause to specify which rows to delete while truncate removes all rows.
Delete does not reset the identity of the table while truncate resets the identity of the table.
Q50. There are 25 horses and 5 tracks. Only by relative comparison in each race, find the minimum no of races needed to find the top three horses
25 horses, 5 tracks, find top 3 horses in minimum races using relative comparison.
Divide horses into 5 groups of 5 each
Conduct 5 races with each group, select the fastest 3 horses from each race
Take the fastest 3 horses from each group and conduct a final race to determine the top 3 horses
Q51. 8. Write command to replace Sam with vam on 5th line
Command to replace Sam with vam on 5th line
sed '5s/Sam/vam/' filename.txt
awk 'NR==5 {sub(/Sam/, "vam")} 1' filename.txt
Q52. Why does a company need a bank?Tell some more points
A company needs a bank for various financial services and support.
Banks provide a range of financial services such as loans, credit facilities, and overdrafts to help companies manage their cash flow and fund their operations.
Banks offer secure and convenient payment solutions like checking accounts, online banking, and electronic fund transfers, which are essential for businesses to receive and make payments.
Companies can benefit from banks' expertise in managing investments...read more
Q53. Optimizing in how to find a name multiple times from a string
Use regular expressions to efficiently find multiple occurrences of a name in a string.
Create a regular expression pattern for the name
Use the pattern with the 'match' method to find all occurrences
Store the results in an array of strings
Q54. NAV calculation. What to do if a wrong NAV is released.
If a wrong NAV is released, steps should be taken to rectify the error and communicate the correct NAV to stakeholders.
Identify the reason for the error in NAV calculation.
Rectify the error by recalculating NAV using correct data.
Communicate the correct NAV to all stakeholders and investors.
Implement measures to prevent similar errors in the future, such as improving data validation processes.
Review and update NAV calculation procedures if necessary.
Q55. Difference between shallow and deep comparision in Strings with code example.
Shallow and deep comparison in Strings with code example
Shallow comparison checks if two String variables refer to the same object in memory
Deep comparison checks if two String variables have the same sequence of characters
Shallow comparison can be done using the '==' operator
Deep comparison can be done using the 'equals()' method
Example: String str1 = 'hello'; String str2 = 'hello'; str1 == str2; //shallow comparison returns true
Example: String str1 = 'hello'; String str2 = ...read more
Q56. How will you optimize the performance while reading a huge file with more than 100 columns and 1 lac rows?
Use efficient file reading techniques like memory mapping, parallel processing, and columnar storage.
Utilize memory mapping to directly access file data without loading it into memory
Implement parallel processing to read and process data concurrently for faster performance
Consider using columnar storage to optimize data retrieval for specific columns
Use appropriate data structures and algorithms for efficient data processing
Q57. What do you think about the economic slowdown? Factors and solutions.
The economic slowdown is a complex issue with multiple factors and requires a multi-pronged approach for solutions.
Factors include global trade tensions, political instability, and technological disruptions.
Solutions may involve government intervention through fiscal and monetary policies, investment in infrastructure, and support for small businesses.
Private sector initiatives such as innovation and diversification can also contribute to economic growth.
Collaboration between...read more
Q58. Difference BTW for loop and while loop.which is better?
A for loop is used when the number of iterations is known, while a while loop is used when the number of iterations is unknown.
For loop is better when the number of iterations is known
While loop is better when the number of iterations is unknown
For loop is more concise and easier to read for simple iterations
While loop is more flexible and can handle complex conditions
Q59. 5.what is cursor and explain type of cursor
A cursor is a database object used to manipulate data in a result set.
A cursor is used to traverse through a result set one row at a time.
There are two types of cursors: static and dynamic.
Static cursors are read-only and scroll forward only.
Dynamic cursors are updatable and can scroll in any direction.
Cursors can be used in stored procedures, triggers, and functions.
Q60. How to maintain sequencing of messages in Kafka at the Consumer side ?
Maintain message sequencing in Kafka at Consumer side
Use a single partition for the topic to ensure messages are consumed in order
Set 'enable.auto.commit' to false and manually commit offsets after processing each message
Implement a custom message handler to handle out-of-sequence messages
Use message timestamps to reorder messages if necessary
Q61. What precautions should be taken so that incorrect payment not goes to client account?
To prevent incorrect payments to client accounts, precautions such as verification of account details, implementing dual authorization, and regular reconciliation should be taken.
Verify client account details before processing payments
Implement dual authorization process for payment approvals
Regularly reconcile payment records with client accounts to identify discrepancies
Use secure payment systems with built-in validation checks
Train staff on proper payment processing proced...read more
Q62. How do you segment customers for a specific travel friendly credit card
Segment customers based on travel habits, preferences, and spending patterns to offer a tailored travel friendly credit card.
Segment customers by frequency of travel (e.g. frequent flyers, occasional travelers)
Segment customers by preferred travel destinations (e.g. domestic vs international)
Segment customers by travel spending habits (e.g. luxury travelers, budget travelers)
Offer benefits and rewards tailored to each segment to attract and retain customers
Q63. Why do you think the coding profile suits you?
I believe the coding profile suits me because of my strong analytical skills, problem-solving abilities, and passion for technology.
I have a strong background in mathematics and logic, which are essential for coding.
I enjoy solving complex problems and finding efficient solutions.
I have experience in programming languages such as Python and Java.
I have successfully completed coding projects in the past, demonstrating my ability to write clean and efficient code.
I am constantl...read more
Q64. Different use cases on Xceptor and Automation Anywhere
Xceptor is used for data extraction and Automation Anywhere is used for automating repetitive tasks.
Xceptor is used in financial services for data extraction and processing.
Automation Anywhere is used for automating repetitive tasks like data entry, invoice processing, etc.
Xceptor can be used for reconciling trades and managing risk in financial services.
Automation Anywhere can be used for automating HR processes like onboarding and offboarding employees.
Xceptor can be used f...read more
Q65. Design Weather app ? What design pattern you will use to build this app ?
Design a weather app using the Model-View-ViewModel (MVVM) design pattern.
Use MVVM design pattern to separate the presentation layer from the business logic and data access.
Model: Represents the data and business logic.
View: Represents the UI components.
ViewModel: Acts as a mediator between the Model and View, handling user interactions and updating the UI.
Use data binding to automatically synchronize the View with the ViewModel.
Implement a repository pattern to handle data r...read more
Q66. What is Indexes in database, What is runtime polymorphism in Java, Exception handling in Java, Questions related to inheritances and Design patterns. Difference between Map and Set
Q67. How to check for all the imposed constraints on a table
To check imposed constraints on a table
Use SQL query to check for constraints on a table
Query 'sp_helpconstraint' to get all constraints on a table
Check 'sys.check_constraints' and 'sys.default_constraints' tables for more details
Q68. How to bind input value to input label in real time in angular?
Use ngModel to bind input value to input label in real time in Angular.
Use ngModel directive in Angular to bind input value to input label in real time.
Example:
Q69. 11. write command to display biggest file on server
Use the 'du' command to display biggest file on server.
Open terminal or SSH into server
Navigate to directory to search from
Run 'du -a . | sort -n -r | head -n 1' command
The output will display the biggest file on the server
Q70. Spar vs PA. What is beta? Risk ratios of mutual funds. Attribution analysis. AVP's
Q71. how to deal if the distribution of a variable is skewed
To deal with skewed distribution of a variable, transformations like log, square root, or box-cox can be applied.
Apply log transformation to reduce right skewness
Apply square root transformation to reduce left skewness
Apply box-cox transformation for a more generalized approach
Consider removing outliers before applying transformations
Q72. Practical use of linked list, classes and structures
Linked lists, classes, and structures are used to organize and manage data in a flexible and efficient manner.
Linked lists are used to store and manipulate collections of data where the order is important.
Classes and structures are used to define custom data types with their own properties and methods.
Linked lists can be implemented using classes or structures to create nodes that hold data and references to other nodes.
They are commonly used in various applications such as i...read more
Q73. What is difference between syndication and consortium
Syndication involves multiple parties working together to finance a project, while a consortium is a group of companies collaborating on a specific project or goal.
Syndication typically involves financial institutions coming together to provide funding for a large project or investment.
Consortiums are often formed by companies in the same industry to work together on research and development projects or to achieve a common goal.
Syndication is more focused on financing, while ...read more
Q74. Challenges faced during code releases during my job
Challenges faced during code releases
Ensuring all code changes are thoroughly tested
Coordinating with different teams for a smooth release
Handling unexpected issues during release
Ensuring minimal downtime for users
Managing rollback plans in case of failures
Q75. 3.write to query to display 3rd highest salary
Query to display 3rd highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to limit the result to the third row
Use a subquery to exclude the top two salaries
Q76. What does Java 17 introduce to optimise multithreadng ?
Java 17 introduces Sealed Classes to optimise multithreading.
Sealed classes restrict which classes can be subclasses, allowing for better control over multithreading.
By limiting the subclasses, developers can ensure thread safety and prevent unexpected behavior.
Example: 'sealed class Shape permits Circle, Rectangle, Triangle;' restricts the subclasses of Shape to only Circle, Rectangle, and Triangle.
Q77. Corporate actions and their effects on stock price?
Corporate actions can have significant impact on stock price.
Corporate actions include stock splits, dividends, mergers, acquisitions, spin-offs, etc.
Positive corporate actions can lead to an increase in stock price while negative actions can lead to a decrease.
Investors often analyze corporate actions to make informed investment decisions.
Example: Apple's stock price increased after a 4-for-1 stock split in 2020.
Example: Tesla's stock price decreased after a 5-for-1 stock sp...read more
Q78. Tell me what is chargeback and credit card fraud
Chargeback is a dispute between a customer and a merchant over a transaction. Credit card fraud is unauthorized use of a credit card.
Chargeback occurs when a customer disputes a transaction and requests a refund from the merchant's bank.
Credit card fraud is when someone uses another person's credit card without their permission.
Examples of credit card fraud include skimming, phishing, and identity theft.
Fraud specialists investigate and prevent both chargeback and credit card...read more
Q79. Which corporation action event will not impact shareholders?
Stock split will not impact shareholders.
Stock split increases the number of shares outstanding but does not change the total value of the company.
Shareholders will own more shares at a lower price per share.
Stock split does not affect the market capitalization of the company.
Example: If a company announces a 2-for-1 stock split, shareholders will receive an additional share for each share they own, but the overall value of their investment remains the same.
Q80. Using the concept of IRR how would you decide whether to take up a project or not?
IRR helps in determining the profitability of a project and whether to take it up or not.
Calculate the IRR of the project
Compare the IRR with the required rate of return
If IRR is greater than the required rate of return, take up the project
If IRR is less than the required rate of return, reject the project
Consider other factors like risk, cash flow, and payback period before making a final decision
Q81. 7.write command to display secod last line of file
Display second last line of a file using command line.
Use the tail command with -n option to display last two lines of the file.
Then use head command with -n option to display the second last line.
Example: tail -n 2 file.txt | head -n 1
Q82. Write a program to find whether a number is divisible by 13
Program to check if a number is divisible by 13
Use the modulo operator (%) to check if the number is divisible by 13
If the remainder is 0, then the number is divisible by 13
Example: num % 13 == 0
Q83. Effect of currency depreciation
Currency depreciation can have various effects on the economy and businesses.
Currency depreciation can make exports cheaper and imports more expensive, leading to an increase in exports and a decrease in imports.
It can boost tourism as foreign visitors find the destination more affordable.
Currency depreciation can also increase the cost of imported goods and raw materials, potentially leading to inflation.
It can make foreign investments more attractive as the returns are high...read more
Q84. Where can you optimise in civil engineering
Optimisation in civil engineering can be achieved through various methods.
Using advanced technology to reduce construction time and costs
Implementing sustainable and eco-friendly practices
Improving project management and communication
Optimising design and materials for maximum efficiency
Reducing waste and improving recycling practices
Q85. What was the complex issue you have faced And you resolved that Various standard selenium interview questions. Page object model
I faced a complex issue with a flaky test case due to dynamic elements, resolved by implementing dynamic waits.
Identified the root cause of the flakiness - dynamic elements causing timing issues
Implemented dynamic waits using WebDriverWait in Selenium to handle the dynamic elements
Utilized explicit waits with expected conditions like elementToBeClickable or visibilityOfElementLocated
Regularly reviewed and updated the dynamic waits to ensure test stability
Q86. Insights to be provided in PPT? How will you evaluate perfomance of a unit
Insights on unit performance evaluation in PPT include key metrics, trends, and recommendations.
Include key performance indicators (KPIs) such as revenue, profit margin, customer satisfaction, and employee productivity.
Present trends over time to show improvements or declines in performance.
Provide recommendations for areas of improvement based on the analysis of the unit's performance data.
Use visual aids such as charts, graphs, and tables to enhance understanding and engage...read more
Q87. Estimate the number of atm in India
There are approximately 200,000 ATMs in India.
As of March 2021, there were around 200,000 ATMs in India.
The number of ATMs in India has been steadily increasing over the years.
ATMs are operated by various banks and financial institutions in India.
The Reserve Bank of India regulates the functioning of ATMs in the country.
Q88. Problem Solving: How to cut cake into 8 pieces with three slice
To cut a cake into 8 pieces with three slices, make two perpendicular cuts through the center of the cake.
Make the first cut horizontally through the center of the cake, dividing it into two equal halves.
Make the second cut vertically through the center of the cake, perpendicular to the first cut, dividing it into quarters.
Make the third cut horizontally through the center of the cake, perpendicular to the second cut, dividing it into eighths.
Q89. How will you create reusable loading logic in angular
Create a service with a loading state and methods to show/hide loading indicators
Create a loading service with a boolean property 'isLoading'
Add methods in the service to set isLoading to true/false
Inject the loading service in components where loading indicators are needed
Q90. What is design thinking and how it can be incorporated in banking?
Design thinking is a problem-solving approach that focuses on understanding users' needs and creating innovative solutions.
Design thinking involves empathy, ideation, prototyping, and testing.
In banking, design thinking can be used to create customer-centric products and services.
For example, banks can use design thinking to improve the user experience of their mobile apps or to create new financial products that meet the needs of underserved communities.
Design thinking can a...read more
Q91. How does Bank BS differ from traditional companies?
Bank BS differs from traditional companies in its focus on financial services and regulations.
Bank BS primarily deals with financial services such as lending, investments, and wealth management.
Bank BS is heavily regulated by government authorities and must adhere to strict financial regulations.
Traditional companies operate in various industries and sectors, focusing on producing goods or providing services unrelated to finance.
Traditional companies may have more flexibility...read more
Q92. What are variable reducing techniques
Variable reducing techniques are methods used to identify and select the most relevant variables in a dataset.
Variable reducing techniques help in reducing the number of variables in a dataset.
These techniques aim to identify the most important variables that contribute significantly to the outcome.
Some common variable reducing techniques include feature selection, dimensionality reduction, and correlation analysis.
Feature selection methods like backward elimination, forward ...read more
Q93. Why is liquidity important and is it necessay in short term or long term perspective.
Liquidity is important for financial stability and is necessary in both short term and long term perspectives.
Liquidity ensures that a company can meet its short term obligations and expenses.
It allows for flexibility in managing cash flow and taking advantage of investment opportunities.
In the long term, liquidity is important for sustaining operations, growth, and weathering economic downturns.
Examples include having enough cash on hand to pay bills, access to lines of cred...read more
Q94. What was the data flow of you last project?
The data flow of my last project involved collecting, processing, analyzing, and visualizing data from multiple sources.
Collected raw data from various sources such as databases, APIs, and user inputs
Processed the data using ETL tools to clean, transform, and integrate it for analysis
Analyzed the processed data using statistical methods and machine learning algorithms
Visualized the results through interactive dashboards and reports for stakeholders
Implemented data governance ...read more
Q95. Importance of Balance of Payment
Balance of payment is important for assessing a country's economic health and its international transactions.
Balance of payment helps in understanding a country's trade position with the rest of the world.
It provides insights into the inflow and outflow of foreign currency, which impacts exchange rates.
A positive balance of payment indicates that a country is earning more from exports than spending on imports.
A negative balance of payment suggests that a country is importing ...read more
Q96. Explain derivatives , What is Trade life cycle, explain options.
Derivatives are financial instruments whose value is derived from an underlying asset. Trade life cycle refers to the stages involved in a trade from initiation to settlement. Options are financial contracts that give the holder the right, but not the obligation, to buy or sell an asset at a specified price within a specific time period.
Derivatives are financial instruments that derive their value from an underlying asset, such as stocks, bonds, commodities, or currencies.
Tra...read more
Q97. what are all the steps do you follow to prevent from PRD INC
Steps to prevent PRD INC
Regularly update software and security patches
Implement strong access controls and authentication measures
Conduct regular security audits and penetration testing
Educate employees on cybersecurity best practices
Implement data encryption and backup procedures
Q98. Explain about spring boot features ,java 8 features and microservices Architecture?
Q99. What do you know about reconciliation. Explain the meaning of Nostro & Vostro Accounts.
Reconciliation involves comparing two sets of records to ensure they are in agreement. Nostro and Vostro accounts are accounts held by banks on behalf of each other.
Reconciliation is the process of comparing two sets of records to ensure they are in agreement.
Nostro accounts are accounts held by a bank in a foreign currency at another bank.
Vostro accounts are accounts held by a foreign bank in the local currency at a domestic bank.
Reconciliation Analysts are responsible for i...read more
Q100. 9. Write command to display blank line in file
Command to display blank line in file
Use echo command with empty quotes to create a blank line in a file
Syntax: echo '' >> filename
Alternatively, use printf command with newline character
Syntax: printf ' ' >> filename
Top HR Questions asked in Swiggy
Interview Process at Swiggy
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month