Bank PO / Clerk / RBI - MCQ Practice Questions
Bank exams reward accuracy under time pressure more than depth, and prelims is often decided by a few marks in a twenty minute section. Questions here follow the IBPS PO, IBPS Clerk, SBI PO, SBI Clerk and RBI Grade B pattern across quantitative aptitude, reasoning ability, English language, general and banking awareness, and computer aptitude. Data interpretation sets are included in full rather than as single questions, since that is how they appear in the paper.
519 questions | 100% Free
In computer networking, what does the abbreviation 'DNS' stand for?
Understanding:
We need to identify the correct full form of the networking term DNS.
Step 1: Role of DNS
DNS acts like a phonebook for the internet. It translates human-readable domain names (such as www.rbi.org.in) into numerical IP addresses that computers use to identify each other on the network.
Step 2: Expand the acronym
D – Domain, N – Name, S – System. Every time you type a website address into a browser, a DNS query is made to resolve that name into the correct IP address.
Answer:
The correct full form of DNS is Domain Name System.
Quick Tip:
DNS operates primarily on UDP port 53. Remembering its function as the 'internet's phonebook' is a useful analogy for exam answers.
Which of the following storage devices has the fastest data access speed?
Understanding:
We need to compare the data access speeds of the given storage devices and identify the fastest.
Step 1: Compare storage technologies
Magnetic Tape uses sequential access and is the slowest, used mainly for backups. Optical Discs (DVDs) read data using laser beams and are slower than HDDs. HDDs use spinning magnetic platters and mechanical read/write heads, limiting their speed due to physical movement. SSDs use NAND flash memory with no moving parts, enabling near-instant electronic access.
Step 2: Rank by access speed
SSD > HDD > Optical Disc > Magnetic Tape. SSDs typically achieve read/write speeds of 500 MB/s (SATA) to over 7,000 MB/s (NVMe), far exceeding HDDs which average 80–160 MB/s.
Answer:
Among the given options, the Solid State Drive (SSD) has the fastest data access speed.
Quick Tip:
NVMe SSDs connected via PCIe lanes are significantly faster than SATA SSDs. The absence of moving mechanical parts is the core reason for SSD speed superiority.
Which layer of the OSI model is responsible for end-to-end communication and error recovery between two hosts?
Understanding:
We need to identify which OSI layer handles end-to-end data delivery with error recovery.
Step 1: Recall the OSI model layers
The 7 OSI layers (bottom to top) are: Physical, Data Link, Network, Transport, Session, Presentation, Application.
Step 2: Identify the function of each relevant layer
Data Link Layer (Layer 2): handles node-to-node delivery within the same network segment. Network Layer (Layer 3): handles logical addressing and routing across networks. Session Layer (Layer 5): manages sessions/connections between applications. Transport Layer (Layer 4): provides end-to-end communication, segmentation, flow control, and error recovery using protocols like TCP and UDP.
Step 3: Match the requirement
End-to-end communication with error recovery is precisely the responsibility of the Transport Layer. TCP (Transmission Control Protocol) at this layer ensures reliable delivery through acknowledgements and retransmission.
Answer:
The Transport Layer of the OSI model is responsible for end-to-end communication and error recovery.
Quick Tip:
Remember: Data Link Layer = node-to-node (same network); Network Layer = host-to-host (routing); Transport Layer = end-to-end (reliable delivery). This distinction is a frequent exam trap.
In MS Excel, which of the following functions is used to find the position of a value within a range of cells?
Understanding:
We need to identify the MS Excel function that returns the relative position (row or column number) of a specific value within a given range.
Step 1: Analyse each option
FIND(): returns the starting position of a text string within another text string — it works on text, not cell ranges. SEARCH(): similar to FIND() but case-insensitive; also used for text strings, not ranges. LOOKUP(): retrieves a value from a row or column — it returns the value, not the position. MATCH(): searches for a specified item in a range and returns the relative position of that item within the range.
Step 2: Confirm MATCH() syntax
The syntax is =MATCH(lookup_value, lookup_array, match_type). For example, =MATCH(500, A1:A10, 0) returns the position of 500 in the range A1:A10. MATCH() is commonly combined with INDEX() for powerful lookups.
Answer:
The MATCH() function is used in MS Excel to find the position of a value within a range of cells.
Quick Tip:
The INDEX-MATCH combination is often preferred over VLOOKUP because MATCH can search both rows and columns, and the lookup column does not need to be the leftmost column.
Which of the following protocols is used to securely transfer files over a network using encryption?
Understanding:
We need to identify the protocol designed for secure, encrypted file transfer over a network.
Step 1: Evaluate each option
FTP (File Transfer Protocol): transfers files but sends data in plaintext — no encryption, hence insecure. SMTP (Simple Mail Transfer Protocol): used for sending emails, not for file transfers. HTTP (HyperText Transfer Protocol): used for transmitting web pages; basic HTTP is unencrypted. SFTP (SSH File Transfer Protocol): provides file transfer capability over a secure SSH (Secure Shell) connection, encrypting both commands and data.
Step 2: Confirm SFTP characteristics
SFTP operates on port 22 (same as SSH). It provides authentication and full encryption, making it the standard secure alternative to FTP in banking and government IT environments.
Answer:
SFTP (SSH File Transfer Protocol) is used to securely transfer files over a network using encryption.
Quick Tip:
Do not confuse SFTP with FTPS. FTPS is FTP with SSL/TLS added on top, while SFTP is an entirely different protocol built on SSH. Both are secure but operate differently.
In the context of computers, what does 'Cache Memory' primarily do?
Understanding:
We need to identify the primary function of cache memory in a computer system.
Step 1: Define Cache Memory
Cache memory is a small, extremely fast memory unit located either on the CPU chip itself or very close to it. It acts as a buffer between the CPU and the main memory (RAM).
Step 2: Understand its purpose
The CPU can access cache memory significantly faster than it can access RAM. When the CPU needs data, it first checks the cache. If the data is found (cache hit), it is retrieved almost instantly. If not (cache miss), the CPU fetches it from RAM and stores a copy in cache for future use. This dramatically reduces average memory access time.
Step 3: Rule out other options
Permanent OS storage is the role of ROM/hard drive. Large file storage is handled by secondary storage (HDD/SSD). I/O management is the role of device controllers and the OS kernel.
Answer:
Cache memory primarily stores frequently accessed data and instructions so the CPU can retrieve them faster than from RAM.
Quick Tip:
Cache is organised in levels: L1 (smallest, fastest, on-chip), L2, and L3 (larger, slightly slower). The closer the cache is to the CPU core, the faster but smaller it is.
Which of the following correctly describes a 'Compiler' in computer programming?
Understanding:
We need to identify the correct description of a compiler in the context of computer programming.
Step 1: Define Compiler
A compiler is a special program (system software) that reads the entire source code written in a high-level language (such as C, C++, or Java) and translates it completely into machine code (binary) or an intermediate code before the program is executed.
Step 2: Distinguish from an Interpreter
An interpreter translates and executes the source code line-by-line at runtime — this matches option A, which describes an interpreter, not a compiler. Compiled programs generally run faster because translation is done beforehand.
Step 3: Rule out other options
A hardware unit for floating-point arithmetic is called an FPU (Floating Point Unit). Memory allocation management is handled by the OS memory manager or garbage collectors, not a compiler.
Answer:
A compiler translates the entire high-level source code into machine code before the program is executed.
Quick Tip:
Examples of compiled languages: C, C++, Fortran. Examples of interpreted languages: Python, JavaScript (traditionally). Java uses both — compiled to bytecode, then interpreted/JIT-compiled by the JVM.
Which of the following keyboard shortcuts is used to permanently delete a file in Windows (bypassing the Recycle Bin)?
Understanding:
We need to identify the Windows keyboard shortcut that deletes a file permanently without sending it to the Recycle Bin.
Step 1: Standard delete behaviour
When a user presses the Delete key alone, the selected file is moved to the Recycle Bin, from where it can be restored. This is a soft delete.
Step 2: Permanent delete shortcut
Pressing Shift + Delete bypasses the Recycle Bin entirely and permanently removes the file from the file system. Windows displays a confirmation prompt warning the user that the file cannot be recovered from the Recycle Bin.
Step 3: Rule out other options
Ctrl + D in many applications moves items to the Recycle Bin (similar to plain Delete) or bookmarks a page in browsers. Alt + Delete and Ctrl + Shift + D are not standard Windows file deletion shortcuts.
Answer:
The keyboard shortcut Shift + Delete permanently deletes a file in Windows, bypassing the Recycle Bin.
Quick Tip:
Files deleted with Shift + Delete may still be recoverable using data recovery software if the disk sectors have not been overwritten. True permanent deletion requires dedicated disk-wiping tools.
In database management, which of the following SQL commands is used to remove an existing table along with all its data from a database permanently?
Understanding:
We need to identify the SQL command that removes an entire table (its structure and all its data) permanently from the database.
Step 1: Differentiate the SQL commands
DELETE: a DML (Data Manipulation Language) command that removes specific rows from a table based on a WHERE clause. The table structure remains intact and the operation can be rolled back. TRUNCATE: a DDL command that removes all rows from a table instantly but keeps the table structure. It cannot be rolled back in most databases. DROP: a DDL (Data Definition Language) command that permanently removes the entire table — both its structure (schema) and all its data — from the database. It cannot be rolled back. REMOVE: not a valid standard SQL command.
Step 2: Match to the requirement
The question asks for removal of the table itself (not just its rows), so the correct command is DROP.
Answer:
The SQL command DROP is used to permanently remove an existing table along with all its data and structure from a database.
Quick Tip:
Remember the hierarchy: DELETE removes rows (can use WHERE), TRUNCATE removes all rows (keeps structure), DROP removes the entire table. DELETE is DML; TRUNCATE and DROP are DDL commands.