Study guide

11.5 Database Management Systems (DBMS) & MS Office Suite

SBI PO Probationary Officer

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Introduction & SBI PO Exam Architecture

1.1 SBI PO Exam Structure, Phases & Sectional Timing 1.2 Eligibility, Age Relaxation & Number of Attempts 1.3 Mark Calculation, One-Fourth Negative Marking & Cut-offs 1.4 Descriptive Communication Test (Email, Situation, Report/Précis) 1.5 Phase 3: Psychometric Test, Group Exercise & Interview Preparation 1.6 Recommended Study Plan & Mock Test Strategy

2 Chapter 2: Quantitative Aptitude — Foundation & Speed Math

2.1 Vedic Math, Fast Calculation & Approximation Techniques 2.2 Number Series (Missing & Wrong Number Patterns) 2.3 Quadratic Equations & Quantity Comparisons (Q1 vs Q2) 2.4 Simplification & Order of Operations 2.5 Data Sufficiency in Quantitative Aptitude

3 Chapter 3: Arithmetic & Applied Problem Solving

3.1 Percentages, Profit, Loss & Discount Calculations 3.2 Simple Interest & Compound Interest (Compounding Cycles & Differences) 3.3 Ratio & Proportion, Partnerships & Ages 3.4 Averages, Mixtures & Alligations 3.5 Time, Work, Efficiency & Pipes & Cisterns 3.6 Speed, Distance, Time, Trains & Boats/Streams 3.7 Permutation, Combination & Probability in Banking Exams

4 Chapter 4: Advanced Data Analysis & Data Interpretation (DI)

4.1 Table & Line Graph Data Interpretation 4.2 Bar Chart & Pie Chart Data Interpretation 4.3 Caselet Data Interpretation (Paragraph-based DI & Venn Caselets) 4.4 Missing Data DI & Radar/Spider Graph Interpretation 4.5 Arithmetic-based DI (Profit-Loss, Time-Work, TSD) & Funnel/Scatter DI

5 Chapter 5: Analytical Reasoning

5.1 Syllogisms (Only a few, Some not & Reverse Syllogism) 5.2 Coded & Mathematical Inequalities 5.3 Coding-Decoding (Coded Statements & Mains Patterns) 5.4 Blood Relations & Direction Sense 5.5 Input-Output Machine Rearrangement

6 Chapter 6: Puzzles & Seating Arrangement

6.1 Linear & Circular Seating Arrangement (Single/Parallel Rows & Variable Binding) 6.2 Floor & Box Puzzles (Multi-story, Vacant floor & Stacking Order) 6.3 Matrix & Category Puzzles (Department/Profession Allocation & Constraint Elimination) 6.4 Scheduling Puzzles (Day-Month-Year combinations & Time Slots)

7 Chapter 7: Critical Reasoning

7.1 Statement & Implicit Assumptions 7.2 Statement & Conclusions vs Strong/Weak Arguments 7.3 Statement & Course of Action 7.4 Cause & Effect Analysis 7.5 Critical Reasoning Passages (Strengthen/Weaken & Paradox Resolution)

8 Chapter 8: English Language

8.1 Reading Comprehension: Tone, Inference, Main Idea & Vocab in Context 8.2 Cloze Test & Double/Triple Fillers 8.3 Para Jumbles & Sentence Rearrangement 8.4 Error Spotting & Phrase Replacement (Grammar Rules) 8.5 Word Usage, Synonyms/Antonyms & Contextual Meaning 8.6 Match the Columns & Sentence Connectors/Starters

9 Chapter 9: Banking & Financial Awareness

9.1 Reserve Bank of India (RBI): History, Structure & Functions 9.2 Monetary Policy Framework: MPC, Repo Rate, SDF, MSF, CRR, SLR & Inflation Targeting 9.3 Indian Financial System: Commercial Banks, Small Finance Banks, Payment Banks & NBFCs 9.4 Financial Inclusion & Government Banking Schemes (PMJDY, PMSBY, PMJJBY, APY, MUDRA, KCC) 9.5 Banking Current Affairs & Financial News Dynamics

10 Chapter 10: General & Banking Awareness — Indian Economy, Financial Markets & Regulations

10.1 Economic Indicators: GDP, NNP, WPI, CPI, IIP & National Income 10.2 Forex & International Trade: Balance of Payments, LRS, NEER/REER & World Bank/IMF 10.3 Union Budget & Economic Survey: Fiscal Deficit, CapEx & Revenue Receipts 10.4 Money Market vs Capital Market: T-Bills, Commercial Paper, CD, Stocks, Bonds & SEBI 10.5 Priority Sector Lending (PSL), Non-Performing Assets (NPAs), SARFAESI, IBC & Basel III

11 Chapter 11: Computer Aptitude

11.1 Computer Fundamentals & Hardware Architecture 11.2 Operating Systems & System Software 11.3 Networking Concepts & Internet Protocols 11.4 Cybersecurity & Banking IT Security 11.5 Database Management Systems (DBMS) & MS Office Suite

11.5 Database Management Systems (DBMS) & MS Office Suite

Key Takeaways Explain This Topic AI

DBMS architecture provides data independence across Physical, Conceptual, and External schemas, enforcing ACID properties (Atomicity, Consistency, Isolation, Durability) for financial transactions.

SQL commands are categorized into DDL (CREATE, ALTER, DROP), DML (SELECT, INSERT, UPDATE, DELETE), DCL (GRANT, REVOKE), and TCL (COMMIT, ROLLBACK, SAVEPOINT).

MS Excel cell referencing dictates calculation behavior: relative references (A1) shift when copied, absolute references ($A$1) stay fixed, and mixed references ($A1 or A$1) fix either column or row.

Key Excel functions for financial analysis include VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, and nested IF logical evaluations.

Essential MS Office shortcuts boost speed in banking exams: F2 edits cells, F4 toggles absolute references in Excel, F5 runs slideshows in PowerPoint, and Mail Merge automates customer communications in Word.

Last updated: July 2026

Database Management Systems (DBMS) & MS Office Suite

Database Management Systems store, query, and manage millions of core customer financial records reliably. Concurrently, office productivity applications like MS Excel, MS Word, and MS PowerPoint are used daily by bank officers for financial modeling, audit reporting, and operational correspondence. SBI PO Mains frequently tests DBMS concepts, SQL query syntax, MS Excel formula logic, and keyboard shortcuts.

1. DBMS Architecture & The Relational Model (RDBMS)

A DBMS is specialized system software used to create, manage, and query structured databases.

  • The ANSI-SPARC 3-Schema Architecture +-----------------------------------------------------------------+
  • | ANSI-SPARC 3-SCHEMA ARCHITECTURE |
  • | |
  • | External Level [ View 1 ] [ View 2 ] [ View 3 ] |
  • | \ | / |
  • | Logical Level +---------------------------------------+ |
  • | | Conceptual Schema | |
  • | | (Entities, Attributes, Relationships) | |
  • | +---------------------------------------+ |
  • | | |
  • | Physical Level +---------------------------------------+ |
  • | | Internal Schema | |
  • | | (Physical Storage Blocks & Indexing) | |
  • | +---------------------------------------+ |
  • +-----------------------------------------------------------------+

Physical / Internal Level: Describes how data blocks and index structures are physically stored on storage hardware.

Conceptual / Logical Level: Describes what data is stored and the relationships between entities (Tables, Primary Keys, Foreign Keys).

External / View Level: User-specific views restricting data exposure based on user access privileges.

Data Independence: The ability to modify schema at one level without forcing changes at the next higher level (Physical Data Independence vs. Logical Data Independence).

Key Relational Database Terminology

Relation: A database Table.

Tuple: A single Row (Record) in a table.

Attribute: A single Column (Field) in a table.

Cardinality: The total number of rows (tuples) in a relation.

Degree: The total number of columns (attributes) in a relation.

Primary Key: A minimal attribute set that uniquely identifies every tuple in a table (must be UNIQUE and NOT NULL).

Foreign Key: An attribute in a table that references the Primary Key of another table, establishing Referential Integrity.

Transaction ACID Properties in Banking

Every core banking fund transfer (e.g., transferring ₹10,000 from Account A to Account B) must satisfy ACID properties:

Atomicity ("All or Nothing"): The transaction executes completely or is entirely rolled back. Money cannot be debited from Account A without being credited to Account B.

Consistency: Database transitions strictly from one valid state to another, maintaining all schema constraints.

Isolation: Concurrent transactions execute independently without interfering with each other (managed via locking protocols).

Durability: Once committed, transaction results persist permanently in non-volatile storage, even during system crashes.

2. Structured Query Language (SQL) Command Categories

SQL is the standard language for relational database management systems.

SQL Category Full Category Name Primary Functions & Commands

DDL Data Definition Language Defines, alters, and drops database schema structures.; CREATE , ALTER , DROP , TRUNCATE , RENAME

DML Data Manipulation Language Manages and manipulates data records inside tables.; SELECT , INSERT , UPDATE , DELETE

  • DCL Data Control Language Manages user access permissions and security privileges.; GRANT , REVOKE
  • TCL Transaction Control Language Manages database transaction state changes.; COMMIT , ROLLBACK , SAVEPOINT
  • Sample SQL Query Example for Banking

To retrieve all customer accounts with a balance exceeding ₹1,00,000 sorted by account branch: SELECT Account_No, Customer_Name, Balance, Branch_Code

  • FROM Customer_Accounts
  • WHERE Balance > 100000
  • ORDER BY Branch_Code ASC;
  • 3. MS Excel Architecture, Formulas & Financial Functions

An MS Excel workbook consists of worksheets structured into a grid of 1,048,576 Rows (numbered 1 , 2 , 3... 1, 2, 3... 1 , 2 , 3... ) and 16,384 Columns (lettered A , B . . . X F D A, B... XFD A , B ... XF D ).

Cell Reference Types

Relative Reference ( A1 ): Adjusts automatically when copied across rows or columns.

Absolute Reference ( $A$1 ): Both column and row are locked using dollar signs ( $ ). Formula references remain fixed regardless of where the formula is copied.

Mixed Reference ( $A1 or A$1 ): Locks either the column ( $A1 ) or the row ( A$1 ) while allowing the other to adjust dynamically.

Shortcut: Press F4 while selecting a cell reference in the formula bar to cycle through reference modes ( A1 -> $A$1 -> A$1 -> $A1 ).

Essential Financial & Analytical Excel Functions

Function Formula Syntax Operational Description

SUMIF =SUMIF(range, criteria, [sum_range]) Adds all numbers in a range that meet a specific condition.

COUNTIF =COUNTIF(range, criteria) Counts the number of non-blank cells that meet a condition.

VLOOKUP =VLOOKUP(lookup_val, table_array, col_index, [range_lookup]) Searches vertically down the first column of a table and returns a value from the specified column index.

XLOOKUP =XLOOKUP(lookup_val, lookup_array, return_array) Modern replacement for VLOOKUP/HLOOKUP; searches in any direction without column index restrictions.

INDEX-MATCH =INDEX(return_range, MATCH(lookup_val, lookup_range, 0)) Flexible lookup combination avoiding VLOOKUP static column layout limitations.

IF (Nested) =IF(cond1, val1, IF(cond2, val2, val3)) Evaluates logical tests sequentially and returns corresponding values.

Step-by-Step Worked Excel Calculation

Scenario: A bank analyst evaluates quarterly branch loan performance data in Excel:

  • Cell A2 : Loan Amount = 500000
  • Cell B2 : Interest Rate = 0.08 (8%)
  • Cell C2 : Customer Risk Score = 750
  • Cell D2 contains the formula: =IF(C2 >= 700, A2 * B2, A2 * B2 * 1.5)

Step-by-Step Evaluation:

Evaluate condition C2 >= 700 : 750 >= 700 is TRUE .

Execute TRUE branch formula: A2 * B2 -> 500000 * 0.08 = 40000 .

Result displayed in Cell D2 = 40,000 .

If the formula in D2 is copied down to cell D3 (where A3 = 200000 , B3 = 0.08 , C3 = 650 ):

Evaluate condition C3 >= 700 : 650 >= 700 is FALSE .

Execute FALSE branch formula: A3 * B3 * 1.5 -> 200000 * 0.08 * 1.5 = 24000 .

  • 4. MS Word & MS PowerPoint Essentials
  • Key Concepts in MS Word

Mail Merge: Combines a main document (e.g., loan sanction letter template) with a structured data source (e.g., customer database) to automatically generate personalized bulk correspondence.

Header & Footer: Text or graphics printed at the top/bottom of every page.

Macros: Recorded sequences of commands and keystrokes using VBA (Visual Basic for Applications) to automate repetitive formatting tasks.

Key Concepts in MS PowerPoint

Slide Master: Top slide in a hierarchy that stores information about the theme, layout, backgrounds, and fonts of a presentation. Editing the Slide Master updates all associated slides globally.

Slide Transition vs. Animation: Transitions control visual movement between slides; Animations control movement of individual elements on a single slide.

5. Important MS Office Keyboard Shortcuts Table

  • Shortcut Key MS Word Function MS Excel Function MS PowerPoint Function
  • F2 Move text Edit active cell contents Rename object
  • F4 Repeat last action Cycle absolute/relative cell references ( $ ) Repeat last action
  • F5 Go To dialog Go To dialog Start Slide Show from beginning
  • Shift + F5 Move to previous revision Search / Find Start Slide Show from current slide
  • F7 Run Spell Check Run Spell Check Run Spell Check
  • Ctrl + Z Undo last action Undo last action Undo last action
  • Ctrl + Y Redo last action Redo last action Redo last action
  • Ctrl + Home Go to document start Move to cell A1 Select first slide
  • Ctrl + End Go to document end Move to last used cell Select last slide
  • Ctrl + Shift + L Apply bulleted list Toggle AutoFilter on/off N/A
  • Alt + F11 Open VBA Editor Open VBA Editor Open VBA Editor
  • Exam Strategies & Common Traps

TRUNCATE vs. DELETE Trap: DELETE is a DML command that can be rolled back and deletes rows conditionally. TRUNCATE is a DDL command that removes all rows quickly, releases storage space, and cannot be rolled back easily.

Excel Reference Dragging: Relative references shift when copied. Absolute references ( $A$1 ) never shift. Mixed references ( $A1 vs A$1 ) lock only the column or row containing the $ symbol.

COUNT vs. COUNTA: COUNT counts numeric values only. COUNTA counts all non-empty cells (including text and error codes).