Attempt CAIIB IT and Digital Banking Module B Quiz & Download PDF

1. In the context of Information Systems used in banking, a Transaction Processing System (TPS) at a bank processes millions of ATM withdrawals, fund transfers, and account inquiries daily. Which of the following characteristics BEST describes the operational requirement of a TPS in a banking environment?

2. A bank’s Management Information System (MIS) produces a weekly report showing branch-wise NPA (Non-Performing Asset) percentages, loan disbursement targets vs. actuals, and staff productivity metrics. This report is used by Regional Managers to monitor performance. Which level of management does this MIS report PRIMARILY serve, and what is its key characteristic?

3. A bank’s credit risk department uses a Decision Support System (DSS) to evaluate whether to approve a large corporate loan of Rs. 500 crore. The DSS models various scenarios such as interest rate fluctuations, borrower’s financial ratios under stress conditions, and macroeconomic factors. The final decision, however, is made by the Credit Committee. Which statement MOST accurately describes the role of DSS in this scenario?

4. The Chairman and Managing Director (CMD) of a large public sector bank uses an Executive Information System (EIS) to monitor the bank’s overall performance. Which of the following features would be MOST characteristic of this EIS implementation in the banking context?

5. A bank deploys a Group Decision Support System (GDSS) for its Board-level Annual Credit Policy discussions, with directors participating from multiple cities. The system supports electronic voting, anonymous idea submission, and structured brainstorming. Which of the following benefits is MOST specifically attributable to the GDSS over a conventional video-conference meeting?

6. A bank’s IT department is implementing a core banking upgrade project. The Project Manager notes that the project has a Planned Value (PV) of Rs. 80 lakh, an Earned Value (EV) of Rs. 60 lakh, and Actual Cost (AC) of Rs. 75 lakh at the end of Month 4. What is the Cost Performance Index (CPI) and Schedule Performance Index (SPI), and what do these indicate about the project’s status?

7. In the context of the Software Capability Maturity Model (CMM/CMMI), a bank’s IT department conducts ad-hoc software development with no documented processes, and project success depends entirely on individual heroics. During audits, the team cannot produce process documentation. At which CMM maturity level does this bank’s IT function operate, and what is the PRIMARY risk?

8. A bank is designing a new Data Centre to house its Core Banking Solution (CBS) servers. The IT infrastructure team is evaluating Tier classifications as per the Uptime Institute standard. The bank requires 99.982% availability with concurrent maintainability (ability to perform maintenance without shutting down) and fault tolerance. Which Data Centre Tier classification meets these requirements, and what is its defining characteristic?

9. In a Relational Database Management System (RDBMS) used in banking, a query retrieves customer loan data as follows: SELECT c.CustomerID, c.Name, l.LoanAmount FROM Customers c INNER JOIN Loans l ON c.CustomerID = l.CustomerID WHERE l.LoanAmount > 1000000. Which of the following accurately describes what this SQL query does and what type of join is used?

10. A bank’s database administrator is designing the Loans table and notices that the following functional dependencies exist: LoanID → CustomerID, LoanAmount, InterestRate, BranchID; BranchID → BranchName, BranchAddress; CustomerID → CustomerName, CustomerAddress. Currently all attributes are in a single table: Loans(LoanID, CustomerID, CustomerName, LoanAmount, InterestRate, BranchID, BranchName, BranchAddress). What normalisation problem exists and how should it be resolved?

11. In database normalisation, a bank’s transaction table has been designed as: Transactions(TransactionID, AccountNumber, AccountHolderName, TransactionDate, TransactionType, Amount, BranchCode, BranchCity). An analyst determines that {TransactionID} → all other attributes, and {AccountNumber} → AccountHolderName, and {BranchCode} → BranchCity. To convert this table to Third Normal Form (3NF), which of the following decompositions is CORRECT and lossless?

12. In Oracle Database architecture used in banking CBS environments, which of the following CORRECTLY describes the relationship between an Oracle Instance and an Oracle Database, and what happens when an Oracle instance is started?

13. A large nationalised bank is considering building a Data Warehouse to consolidate data from its CBS, trade finance system, treasury system, and HRMS. The Chief Information Officer argues that the existing CBS OLTP database can serve all analytical needs. Which argument MOST accurately explains why a separate Data Warehouse is justified for the bank?

14. A bank’s Data Warehouse architect is designing the schema for an analytical system. The fact table ‘LoanFact’ contains LoanAmount, EMIAmount, InterestEarned, and foreign keys to dimension tables: TimeDim, CustomerDim, BranchDim, and ProductDim. ProductDim further links to ProductCategoryDim and ProductSubCategoryDim. Which schema design does this represent, and what is its key advantage and disadvantage compared to a Star Schema?

15. In the context of Data Warehouse architecture, Bill Inmon and Ralph Kimball proposed two different approaches to building enterprise data warehouses. A bank is choosing between these approaches. Which statement MOST accurately contrasts the Inmon and Kimball methodologies?

16. A bank’s Business Intelligence (BI) team is implementing an Expert System to assess credit risk for SME loans. The system uses a knowledge base containing lending rules (e.g., ‘IF DSCR < 1.25 AND leverage ratio > 3 THEN classify as HIGH RISK’) and an inference engine. During implementation, a domain expert notices the system gives incorrect risk ratings for certain industry sectors. What is the PRIMARY limitation of Expert Systems that this scenario illustrates?

17. A bank deploys an Artificial Neural Network (ANN) model to detect fraudulent credit card transactions in real time. The model is trained on 5 years of transaction data. After deployment, the bank’s fraud team notices the model fails to detect a new pattern of fraud involving contactless tap transactions at petrol stations. What phenomenon does this MOST likely illustrate, and what is the recommended solution?

18. In the context of Data Mining used in banking, a bank applies the Apriori algorithm to its credit card transaction database and discovers the association rule: {ATM_Withdrawal, Fuel_Purchase} → {Restaurant_Dining} with support = 0.12, confidence = 0.68, and lift = 2.3. How should the bank’s analytics team interpret this rule and what is the significance of the lift value?

19. A bank’s Data Science team is building a customer churn prediction model using Decision Tree classification. The dataset has 100,000 customer records with 92,000 non-churners and 8,000 churners. After training, the model achieves 95% accuracy but the business team finds it useless for identifying at-risk customers. What is the MOST likely explanation for this paradox?

20. In OLAP (Online Analytical Processing) used in banking Data Warehouses, which operation is being performed when a bank analyst starts with total NPA data for the entire bank, then examines NPA data by zone, then by state, then by district, and finally by individual branch?