-
Q.1Professional Knowledge
A packet of size L bits is transmitted from a source to a destination through N intermediate routers using store-and-forward packet switching. Each link has a transmission rate of R bits per second. Ignoring propagation, processing, and queuing delays, what is the total transmission delay?
- 𝑅 𝐿
- 𝑁𝐿 𝑅
- (𝑁+1)𝐿 𝑅
- (𝑁−1)𝐿 𝑅
- 𝐿 𝑁𝑅
Show answer
Correct answer: option3 — (𝑁+1)𝐿 𝑅
-
Q.2Professional Knowledge
Which of the following operations are valid on pointers in C++?
- Pointer multiplication
- Pointer division
- Pointer addition and pointer subtraction with integers
- Pointer modulus operation
- Pointer exponentiation
Show answer
Correct answer: option3 — Pointer addition and pointer subtraction with integers
-
Q.3Professional Knowledge
What is the time complexity of the classical Dynamic Programming approach using nested loops for the LIS problem?
- O(n)
- O(n log n)
- O(n²)
- O(log n)
- O(n³)
Show answer
Correct answer: option3 — O(n²)
-
Q.4Professional Knowledge
Which file mode in Python is primarily used to append new content to an existing file without deleting the previous data?
- r
- w
- x
- a
- rb
Show answer
Correct answer: option4 — a
-
Q.5Professional Knowledge
In C++, which of the following correctly describes the purpose of endl and setw?
- endl formats output width, while setw inserts a new line
- endl inserts a new line, while setw sets the output field width
- endl reads input data, while setw displays output
- endl allocates memory, while setw controls loops
- endl performs type conversion, while setw handles exceptions
Show answer
Correct answer: option2 — endl inserts a new line, while setw sets the output field width
-
Q.6Professional Knowledge
Which Linux command option is commonly used with ls to display files sorted by their last modified time?
- ls -a
- ls -l
- ls -r
- ls -t
- ls -s
Show answer
Correct answer: option4 — ls -t
-
Q.7Professional Knowledge
Which of the following is NOT a valid file system format used in operating systems?
- NTFS
- exFAT
- FAT32
- FAT84
- ReFS
Show answer
Correct answer: option4 — FAT84
-
Q.8Professional Knowledge
Which OLAP operation is used to extract a smaller subset of data from a multidimensional data cube by selecting specific dimension values?
- Drill-up
- Roll-up
- Slice
- Pivot
- Drill-through
Show answer
Correct answer: option3 — Slice
-
Q.9Professional Knowledge
Which type of testing in the Software Development Life Cycle (SDLC) is primarily performed to verify that the software satisfies business and compliance requirements?
- Unit Testing
- Integration Testing
- Blackbox Testing
- Acceptance Testing
- Regression Testing
Show answer
Correct answer: option4 — Acceptance Testing
-
Q.10Professional Knowledge
Which data warehouse schema is designed such that multiple fact tables share common dimension tables?
- Star Schema
- Snowflake Schema
- Hierarchical Schema
- Fact Constellation Schema
- Relational Schema
Show answer
Correct answer: option4 — Fact Constellation Schema
-
Q.11Professional Knowledge
Which OOP concept focuses on hiding internal implementation details and exposing only the necessary functionality to the user?
- Inheritance
- Abstraction
- Encapsulation
- Polymorphism
- Overloading
Show answer
Correct answer: option2 — Abstraction
-
Q.12Professional Knowledge
What will be the output of the following Python code? names = ["Aman", "Rahul", "Peter"] names.insert(1, "John") print(names[1])
- Aman
- Rahul
- Peter
- John
- Error
Show answer
Correct answer: option4 — John
-
Q.13Professional Knowledge
What will be the output of the following Python code? a = (1,2,3,4,5) print(a[-4:-1])
- (2, 3, 4)
- (3, 4, 5)
- (3, 4)
- (2, 3, 4, 5)
- (1, 2, 3)
Show answer
Correct answer: option1 — (2, 3, 4)
-
Q.14Professional Knowledge
Which of the following statements correctly distinguishes Composition from Aggregation in Object- Oriented Programming (OOP)?
- Aggregation represents stronger dependency than Composition
- In Composition, the child object depends on the lifecycle of the parent object
- Composition allows child objects to exist independently of the parent
- Aggregation and Composition both represent identical relationships
- Composition is used only for multiple inheritance relationships
Show answer
Correct answer: option2 — In Composition, the child object depends on the lifecycle of the parent object
-
Q.15Professional Knowledge
What is the primary use of a global variable in C++?
- To store values that can be accessed only inside a loop
- To create variables that exist only during function execution
- To allow data to be accessed from multiple functions in a program
- To permanently store data inside a file
- To declare variables that cannot be modified
Show answer
Correct answer: option3 — To allow data to be accessed from multiple functions in a program
-
Q.16Professional Knowledge
What will be the output of the following C code? #include<stdio.h> int main() { int a = 1; a += 3; printf("%d", a + a); return 0; }
- 4
- 6
- 8
- 10
- 2
Show answer
Correct answer: option3 — 8
-
Q.17Professional Knowledge
Which of the following is commonly used in programming languages to store and represent a sequence of characters?
- String
- Stack
- Queue
- Tree
- Graph
Show answer
Correct answer: option1 — String
-
Q.18Professional Knowledge
Which of the following is syntactically valid in a standard Bash shell script for iterating through a list of values using a for loop?
- for(i=0; i<5; i++) { }
- for i in 1 2 3 4 5 do echo $i done
- foreach i = 1 to 5 echo $i end
- loop i from 1 to 5 print $i
- for i = 1:5 echo $i endfor
Show answer
Correct answer: option2 — for i in 1 2 3 4 5 do echo $i done
-
Q.19Professional Knowledge
Which command in the Windows Recovery Environment is specifically used to repair the Master Boot Record?
- bootcfg /repair
- bootrec /fixmbr
- diskpart /mbr
- sfc /repairboot
- chkdsk /fixboot
Show answer
Correct answer: option2 — bootrec /fixmbr
-
Q.20Professional Knowledge
Given Python Code import re text = "IBPS_SO_IT_2024" result = re.findall(r'[A-Z]+', text) print(result[1]) What will be the output of the above code?
- IBPS
- SO
- IT
- 2024
- _
Show answer
Correct answer: option2 — SO
-
Q.21Professional Knowledge
Which operator is used in Python to directly check whether a key exists in a dictionary?
- find() operator
- search() method
- in operator
- index() method
- contains() function
Show answer
Correct answer: option3 — in operator
-
Q.22Professional Knowledge
Which of the following is used in Python to access command-line arguments passed to a program?
- os.path
- sys.argv
- input.argv
- args.sys
- command.line
Show answer
Correct answer: option2 — sys.argv
-
Q.23Professional Knowledge
Next-Generation Firewalls primarily belong to which generation of firewall technology?
- First Generation Firewall
- Second Generation Firewall
- Third Generation Firewall
- Fourth Generation Firewall
- Fifth Generation Firewall
Show answer
Correct answer: option3 — Third Generation Firewall
-
Q.24Professional Knowledge
Which security approach permits only predefined approved inputs or entities while rejecting all others by default?
- Packet Sniffing
- Blacklisting
- Input Masking
- Whitelisting
- Traffic Shaping
Show answer
Correct answer: option4 — Whitelisting
-
Q.25Professional Knowledge
Which of the following SQL queries correctly selects records where the First_Name contains a specific pattern, the Last_Name also matches a pattern using LIKE, and the City does not match a given pattern using NOT LIKE?
- SELECT * FROM Employee WHERE First_Name LIKE '%A%' AND Last_Name LIKE '%K%' AND City NOT LIKE '%Delhi%';
- SELECT * FROM Employee WHERE First_Name = '%A%' AND Last_Name = '%K%' AND City != '%Delhi%';
- SELECT * FROM Employee WHERE First_Name IN '%A%' AND Last_Name IN '%K%' AND City NOT IN '%Delhi%';
- SELECT * FROM Employee WHERE First_Name LIKE '%A%' OR Last_Name LIKE '%K%' OR City NOT LIKE '%Delhi%';
- SELECT * FROM Employee WHERE First_Name NOT LIKE '%A%' AND Last_Name LIKE '%K%' AND City LIKE '%Delhi%';
Show answer
Correct answer: option1 — SELECT * FROM Employee WHERE First_Name LIKE '%A%' AND Last_Name LIKE '%K%' AND City NOT LIKE '%Delhi%';
-
Q.26Professional Knowledge
Which networking mechanism translates private internal IP addresses into public IP addresses, allowing devices on a local network to communicate with external networks while concealing internal addressing?
- VPN
- Router
- Proxy Server
- NAT
- Firewall
Show answer
Correct answer: option4 — NAT
-
Q.27Professional Knowledge
What is the primary function of the ARP in an IPv4 local network?
- To assign IP addresses dynamically
- To resolve domain names into IP addresses
- To determine the MAC address corresponding to an IP address
- To encrypt network communication
- To forward packets between different networks
Show answer
Correct answer: option3 — To determine the MAC address corresponding to an IP address
-
Q.28Professional Knowledge
Which FTP transfer mode reduces data size during transmission to improve bandwidth efficiency?
- Stream Mode
- Compression Mode
- Encapsulation Mode
- Multiplexing Mode
- Fragmentation Mode
Show answer
Correct answer: option2 — Compression Mode
-
Q.29Professional Knowledge
What is the correct postfix expression for the infix expression: (a+b)∗(c−d)
- ab+cd-*
- +ab-cd*
- ab*cd+-
- abcd+*-
- ab+*cd-
Show answer
Correct answer: option1 — ab+cd-*
-
Q.30Professional Knowledge
In a hash table, the load factor primarily represents which of the following?
- Number of collisions per bucket
- Ratio of stored elements to the total number of slots
- Number of hash functions used
- Total memory occupied by the hash table
- Maximum size of a hash key
Show answer
Correct answer: option2 — Ratio of stored elements to the total number of slots
-
Q.31Professional Knowledge
Which of the following is commonly used to block or allow network ports such as HTTP and SSH?
- Compiler
- Firewall
- Load Balancer
- Web Browser
- Database Serve
Show answer
Correct answer: option2 — Firewall
-
Q.32Professional Knowledge
Which of the following correctly describes a feature of IMAP in email communication systems?
- Emails are automatically deleted from the server after downloading
- Using IMAP, users can manage server-side mailbox properties such as read status and folders.
- Emails can be transferred only within local networks
- Emails are accessible only in offline mode
- IMAP allows email synchronization without user authentication
Show answer
Correct answer: option2 — Using IMAP, users can manage server-side mailbox properties such as read status and folders.
-
Q.33Professional Knowledge
Which networking device commonly supports traffic monitoring features such as port mirroring, enabling packet analyzers operating in promiscuous mode to inspect network traffic?
- Repeater
- Hub
- Switch
- Bridge
- Router
Show answer
Correct answer: option3 — Switch
-
Q.34Professional Knowledge
In MySQL, which of the following statements correctly creates a trigger that executes automatically before inserting a row into the Employee table?
- CREATE TRIGGER trg_before_insert BEFORE INSERT ON Employee FOR EACH ROW SET @x = 1;
- CREATE TABLE trg_before_insert BEFORE INSERT ON Employee;
- TRIGGER trg_before_insert ON Employee BEFORE INSERT;
- CREATE VIEW trg_before_insert BEFORE INSERT ON Employee;
- CREATE INDEX trg_before_insert ON Employee(Before_Insert);
Show answer
Correct answer: option1 — CREATE TRIGGER trg_before_insert BEFORE INSERT ON Employee FOR EACH ROW SET @x = 1;
-
Q.35Professional Knowledge
What is the name of the cyber attack in which an attacker overwhelms a web server by sending a very large number of HTTP requests?
- Packet Sniffing
- HTTP Flooding
- DNS Spoofing
- Session Hijacking
- Port Scanning
Show answer
Correct answer: option2 — HTTP Flooding
-
Q.36Professional Knowledge
When a foreign key constraint is enforced in a relational database, which condition must normally be satisfied while inserting a non-NULL value into the foreign key column?
- The value can be inserted without checking the referenced table.
- The value must match an existing value in the referenced primary key or unique key column.
- A new primary key value is automatically generated in the parent table.
- The foreign key checks only uniqueness of the inserted value.
- The foreign key column must always contain NULL values.
Show answer
Correct answer: option2 — The value must match an existing value in the referenced primary key or unique key column.
-
Q.37Professional Knowledge
Which of the following threats is least effectively controlled by a traditional hardware firewall?
- Unauthorized port access
- Malicious inbound traffic
- External intrusion attempts
- Data theft by authorized internal users
- Unauthorized external network access
Show answer
Correct answer: option4 — Data theft by authorized internal users
-
Q.38Professional Knowledge
In TRC, which of the following expressions correctly retrieves all tuples from the Employee relation where the attribute salary is strictly greater than 50,000?
- {t∣Employee(t)∨t.salary>50000}
- 𝜎𝑠𝑎𝑙𝑎𝑟𝑦>50000(𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑒)
- {t.salary>50000∣Employee(t)}
- {t∣Employee(t)→t.salary>50000}
- {t∣Employee(t)∧t.salary>50000}
Show answer
Correct answer: option5 — {t∣Employee(t)∧t.salary>50000}
-
Q.39Professional Knowledge
What is the primary purpose of the GROUP BY clause in SQL?
- To sort rows in ascending or descending order
- To group rows with identical values in specified columns for aggregate processing
- To permanently remove duplicate rows from a table
- To filter rows before retrieval
- To combine records from multiple tables
Show answer
Correct answer: option2 — To group rows with identical values in specified columns for aggregate processing
-
Q.40Professional Knowledge
Which of the following sorting algorithms has the same time complexity in the best, average, and worst cases?
- Merge Sort
- Quick Sort
- Bubble Sort
- Insertion Sort
- None of the above
Show answer
Correct answer: option1 — Merge Sort
-
Q.41Professional Knowledge
In the Cyber Kill Chain model, which phase involves combining a malicious payload with a specific exploit or vulnerability to prepare for attack delivery?
- Footprinting
- Weaponization
- Enumeration
- Hardening
- Sandboxing
Show answer
Correct answer: option2 — Weaponization
-
Q.42Professional Knowledge
A Binary Search Tree (BST) is constructed by inserting the following elements in the given order: 46, 72, 39, 58, 21, 13, 65, 87, 99 What will be the inorder traversal of the BST?
- 46, 39, 21, 13, 72, 58, 65, 87, 99
- 13, 21, 39, 46, 58, 65, 72, 87, 99
- 99, 87, 72, 65, 58, 46, 39, 21, 13
- 13, 39, 21, 46, 58, 72, 65, 87, 99
- 21, 13, 39, 46, 65, 58, 72, 99, 87
Show answer
Correct answer: option2 — 13, 21, 39, 46, 58, 65, 72, 87, 99
-
Q.43Professional Knowledge
Which web security attack causes a logged-in user’s browser to send unauthorized requests to a trusted web application without the user’s intentional consent?
- Phishing
- SQL Injection
- CSRF
- Spoofing
- Session Hijacking
Show answer
Correct answer: option3 — CSRF
-
Q.44Professional Knowledge
Which type of SQL JOIN automatically matches rows from two tables using columns that have the same name in both tables?
- Inner Join
- Cross Join
- Self Join
- Natural Join
- Left Join
Show answer
Correct answer: option4 — Natural Join
-
Q.45Professional Knowledge
Among the following in-place comparison-based sorting algorithms, which algorithm generally performs the minimum number of swaps in the worst case?
- Bubble Sort
- Quick Sort
- Selection Sort
- Insertion Sort
- Merge Sort
Show answer
Correct answer: option3 — Selection Sort
-
Q.46Professional Knowledge
Which SQL feature allows calculations to be performed across a group of related rows while still returning each individual row separately, typically using the PARTITION BY clause?
- Nested Query
- Window Function
- Trigger Function
- Scalar Function
- Aggregate Constraint
Show answer
Correct answer: option2 — Window Function
-
Q.47Professional Knowledge
What is the hexadecimal equivalent of the binary number: 10111010
- BA
- 9A
- A9
- AB
- B8
Show answer
Correct answer: option1 — BA
-
Q.48Professional Knowledge
What is the primary purpose of the $ symbol in Unix/Linux shell scripting?
- To terminate a running process
- To define comments in a shell script
- To access the value of a variable or perform command substitution
- To declare loop variables in Bash
- To redirect output to another file
Show answer
Correct answer: option3 — To access the value of a variable or perform command substitution
-
Q.49Professional Knowledge
What is the primary purpose of /bin/bash in Linux systems?
- To manage disk partitions
- To execute shell commands and shell scripts
- To configure network interfaces
- To store system log files
- To compile C programs automatically
Show answer
Correct answer: option2 — To execute shell commands and shell scripts
-
Q.50Professional Knowledge
What is the primary purpose of memoization in Dynamic Programming?
- To reduce memory allocation during execution
- To store intermediate results of repeated subproblems
- To increase recursion depth in algorithms
- To execute multiple functions simultaneously
- To convert iterative solutions into recursive solutions
Show answer
Correct answer: option2 — To store intermediate results of repeated subproblems
-
Q.51Professional Knowledge
In MySQL, which query correctly returns the salary appearing in the nth row after sorting all salaries in descending order from the Employees table?
- SELECT SALARY FROM Employees ORDER BY SALARY DESC LIMIT n, 1;
- SELECT SALARY FROM Employees ORDER BY SALARY ASC LIMIT n-1, 1;
- SELECT SALARY FROM Employees ORDER BY SALARY DESC LIMIT 1, n-1;
- SELECT SALARY FROM Employees ORDER BY SALARY DESC LIMIT n-1, 1;
- SELECT MAX(SALARY) FROM Employees WHERE SALARY < n;
Show answer
Correct answer: option4 — SELECT SALARY FROM Employees ORDER BY SALARY DESC LIMIT n-1, 1;
-
Q.52Professional Knowledge
Which of the following firewall monitors the state of every connection on the network and allows or blocks packets according to this context, providing stronger security?
- Proxy Firewall
- Static Packet Firewall
- Circuit-Level Gateway
- Dynamic Packet Filtering Firewall
- Application Gateway
Show answer
Correct answer: option4 — Dynamic Packet Filtering Firewall
-
Q.53Professional Knowledge
In SQL implementations that support the INSTR() function, what is the default starting index for the first character, and what value is returned if the specified substring is not found in the target string?
- Starts from 1; returns NULL if not found
- Starts from 0; returns -1 if not found
- Starts from 1; returns -1 if not found
- Starts from 0; returns 0 if not found
- Starts from 1; returns 0 if not found
Show answer
Correct answer: option5 — Starts from 1; returns 0 if not found
-
Q.54Professional Knowledge
Consider the following transactions operating on database items X and Y with initial values: X=200,Y=100 Transaction T₁ · Read X · X := X − 10 · Write X Transaction T₂ · Read Y · Y := Y + 20 · Write Y Both transactions execute completely and exactly once in any serial order without rollback or failure. What will be the final values of X and Y?
- X = 190, Y = 120
- X = 210, Y = 120
- X = 190, Y = 100
- X = 200, Y = 100
- X = 210, Y = 80
Show answer
Correct answer: option1 — X = 190, Y = 120
-
Q.55Professional Knowledge
Which ACID property ensures that a transaction is executed entirely or not executed at all, so that partial updates are not permanently applied if a failure occurs during execution?
- Consistency
- Isolation
- Recoverability
- Atomicity
- Durability
Show answer
Correct answer: option4 — Atomicity
-
Q.56Professional Knowledge
Consider the relation: R(Roll_No, Student_ID, Course_ID) with the following functional dependencies: · {Roll_No, Course_ID} → {Student_ID} · {Student_ID, Course_ID} → {Roll_No} · Student_ID → Roll_No The above dependencies completely describe all functional dependencies of the relation. Identify the highest normal form satisfied by the relation.
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form
- Fourth Normal Form
Show answer
Correct answer: option3 — Third Normal Form
-
Q.57Professional Knowledge
In TRC, which of the following mathematical notations is used as a quantifier to express that at least one tuple in the relation satisfies a specific condition?
- ∀
- ∃
- σ
- π
- ∪
Show answer
Correct answer: option2 — ∃
-
Q.58Professional Knowledge
In most standard SQL implementations, which of the following statements regarding DROP and TRUNCATE commands is incorrect?
- DROP removes both the table structure and table data.
- TRUNCATE removes all rows while preserving the table structure.
- TRUNCATE is generally faster than DELETE for removing all rows from a table.
- TRUNCATE can always be reversed using ROLLBACK regardless of the DBMS implementation.
- DROP removes associated indexes and constraints along with the table.
Show answer
Correct answer: option4 — TRUNCATE can always be reversed using ROLLBACK regardless of the DBMS implementation.
-
Q.59Professional Knowledge
In DBMS, which referential integrity action of a foreign key constraint automatically deletes related child records when the corresponding parent record is deleted?
- Restrict
- Commit
- Rollback
- Cascade
- Savepoint
Show answer
Correct answer: option4 — Cascade
-
Q.60Professional Knowledge
A rogue wireless access point that closely imitates a legitimate Wi-Fi network in order to trick users and capture their credentials is an example of which attack?
- Man-in-the-middle attack
- Evil twin attack
- DNS spoofing attack
- ARP poisoning attack
- Smurf attack
Show answer
Correct answer: option2 — Evil twin attack
Option number of the correct answer for each question.