Master Computer Science & IT concepts: DBMS & SQL, Data Structures, Computer Networks, Operating Systems, Software Engineering, OOPs, and Network Security with detailed technical explanations.
Select your option below. Marking scheme: +1.00 positive, -0.25 negative.
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?
What is the primary function of the ARP in an IPv4 local network?
Which FTP transfer mode reduces data size during transmission to improve bandwidth efficiency?
What is the correct postfix expression for the infix expression: $(a+b)*(c-d)$?
In a hash table, the load factor primarily represents which of the following?
Which of the following is commonly used to block or allow network ports such as HTTP and SSH?
Which of the following correctly describes a feature of IMAP in email communication systems?
Which networking device commonly supports traffic monitoring features such as port mirroring, enabling packet analyzers operating in promiscuous mode to inspect network traffic?
In MySQL, which of the following statements correctly creates a trigger that executes automatically before inserting a row into the Employee table?
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?
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?
Which of the following threats is least effectively controlled by a traditional hardware firewall?
In Tuple Relational Calculus (TRC), which of the following expressions correctly retrieves all tuples from the Employee relation where the attribute salary is strictly greater than $50,000$?
What is the primary purpose of the GROUP BY clause in SQL?
Which of the following sorting algorithms has the same time complexity in the best, average, and worst cases?
In the Cyber Kill Chain model, which phase involves combining a malicious payload with a specific exploit or vulnerability to prepare for attack delivery?
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?
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?
Which type of SQL JOIN automatically matches rows from two tables using columns that have the same name in both tables?
Among the following in-place comparison-based sorting algorithms, which algorithm generally performs the minimum number of swaps in the worst case?
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?
What is the hexadecimal equivalent of the binary number: $10111010_2$?
What is the primary purpose of the $ symbol in Unix/Linux shell scripting?
What is the primary purpose of /bin/bash in Linux systems?
What is the primary purpose of memoization in Dynamic Programming?