Computer set 1 MCQs
Practice interactive objective questions for this topic. Select an option to instantly verify your answer and read detailed explanations.
Q.151
What causes Excel to return a #SPILL! error?
A
Dividing a number by zero
B
An active array formula attempts to output multiple results, but adjacent cells are not empty
C
A macro attempts to access a protected sheet
D
A formula contains an unrecognized text string
Q.152
Why is heavy use of the OFFSET function generally discouraged in large, complex Excel models?
A
It rounds decimal places inaccurately
B
It cannot reference other worksheets
C
It is a volatile function that recalculates upon any sheet change, drastically slowing down performance
D
It has a hard limit of 255 nested arguments
Q.153
When setting up Custom Data Validation in Excel, what must the logical output of the custom formula evaluate to in order to allow data entry?
A
An exact numeric match
B
A blank string
C
A positive integer
D
TRUE
Q.154
Which legacy Excel function is heavily utilized for conditional multi-criteria counting and summing because it processes arrays without needing Ctrl+Shift+Enter?
A
SUMPRODUCT
B
COUNTBLANK
C
AGGREGATE
D
SUBTOTAL
Q.155
What is the primary characteristic of a 'Calculated Field' within an Excel PivotTable?
A
It alters the source data table permanently
B
It creates a new mathematical field derived from existing pivot fields without adding columns to the source data
C
It links external databases to the pivot cache
D
It automatically generates predictive forecast charts
Q.156
How can a user control multiple Excel PivotTables simultaneously using a single Slicer interface?
A
By writing a VBA loop script
B
By merging the source tables into one sheet
C
By using the 'Report Connections' setting on the Slicer to link it to multiple pivot tables sharing the same cache
D
By grouping the pivot tables with Ctrl + G
Q.157
What functional language operates 'under the hood' of Excel's Power Query (Get & Transform Data) tool?
A
Python
B
VBA
C
DAX
D
M language
Q.158
If you apply a Conditional Formatting formula `=$A1>100` to the range A1:C10, what specific visual result will occur?
A
An entire row (columns A through C) will be highlighted if the value in column A of that row is greater than 100
B
Only the cells in column A will be highlighted
C
The entire grid will highlight if cell A1 exceeds 100
D
It will fail with an error because absolute references are disabled in conditional formatting
Q.159
Which 'hidden' Excel function is famously used to calculate the exact difference between two dates in total years, months, or days?
A
NETWORKDAYS
B
DATEDIF
C
YEARFRAC
D
WORKDAY.INTL
Q.160
In multi-core processor hierarchy, what is the standard architectural relationship between L2 and L3 Cache?
A
Both L2 and L3 are located on the motherboard, not the CPU die
B
L3 is smaller and faster than L2
C
L2 cache is typically dedicated to an individual core, while L3 cache is shared across all cores
D
L2 holds instructions and L3 exclusively holds floating-point data
Q.161
What performance issue does a NUMA (Non-Uniform Memory Access) architecture design address in multi-socket server motherboards?
A
Hard drive bottlenecking
B
Network packet loss
C
Graphics rendering latency
D
The bottleneck of multiple CPUs fighting for bandwidth on a single shared memory bus
Q.162
In virtual memory management, what specifically triggers a 'Page Fault' interrupt?
A
A program attempts to access a virtual memory address that is currently mapped to a physical disk rather than RAM
B
Two programs attempt to write to the exact same RAM address simultaneously
C
The CPU cache exceeds safe thermal limits
D
An application requests more memory than physically installed
Q.163
What critical data integrity feature was popularized by the Ext4 and NTFS file systems to survive unexpected power losses?
A
Defragmentation
B
Journaling
C
Hardware encryption
D
Wear leveling
Q.164
How does the ZFS file system's 'Copy-on-Write' mechanic prevent data corruption during saves?
A
It copies data to a cloud server simultaneously
B
It writes changes to the SSD cache only
C
It never modifies active data blocks in place; it writes the new data to an empty block and updates pointers
D
It requires dual hard drives to function
Q.165
What is the specific purpose of the TRIM command issued by modern operating systems to Solid State Drives?
A
To compress large video files automatically
B
To limit the maximum read speed to save battery
C
To encrypt deleted files so they cannot be recovered
D
To inform the SSD controller which data blocks are no longer considered in use and can be wiped internally
Q.166
In OS resource allocation, what theoretical problem does the 'Banker's Algorithm' solve?
A
Deadlock avoidance by simulating allocation to ensure the system remains in a safe state
B
Network congestion control
C
CPU scheduling priority inversion
D
Cryptocurrency wallet encryption
Q.167
What fundamental conceptual difference exists between a Mutex and a Semaphore in thread synchronization?
A
A Mutex works over networks, Semaphores are local
B
A Mutex involves strict ownership (only the thread that locked it can unlock it), while a Semaphore is just a signaling counter
C
A Mutex does not halt the CPU, Semaphores do
D
A Mutex is hardware-based, Semaphores are software-based
Q.168
During a heavy process context switch, why must the Translation Lookaside Buffer (TLB) usually be flushed?
A
To clear temporary internet files
B
To reset the CPU thermal limits
C
Because the old virtual-to-physical memory address mappings belong to the previous process and are invalid for the new one
D
To force the hard drive to spin down
Q.169
In a Linux filesystem hierarchy, how does a Hard Link behave differently from a Soft (Symbolic) Link?
A
A hard link points directly to the file's underlying inode, meaning the link survives even if the original file name is deleted
B
A hard link can point across different physical disk partitions
C
A hard link is used exclusively for directories
D
A hard link encrypts the target file
Q.170
What is the most definitive hardware solution to cure an operating system suffering from severe 'Thrashing'?
A
Upgrading the graphics card
B
Increasing the CPU clock multiplier
C
Replacing the motherboard battery
D
Installing additional physical RAM modules
Q.171
Why do modern relational databases and file systems like NTFS heavily rely on B-Tree (Balanced Tree) data structures?
A
They provide beautiful graphical UI representations
B
They compress text data by 80%
C
They maintain sorted data and allow searches, sequential access, and insertions in logarithmic time, minimizing disk I/O reads
D
They inherently encrypt data blocks
Q.172
How do modern secure web connections (TLS/HTTPS) utilize 'Hybrid Encryption'?
A
They alternate between encrypting every other packet
B
They use slow asymmetric encryption to securely exchange a fast symmetric session key, then use symmetric for the bulk data
C
They use quantum computing mixed with classical algorithms
D
They hash the data first and then compress it
Q.173
In cryptographic hash functions, what mathematical concept does the 'Birthday Attack' exploit to find hash collisions?
A
Prime factorization algorithms
B
The inherent predictability of pseudo-random number generators
C
Brute-forcing sequentially starting from the user's birthdate
D
The statistical probability that in a group of random items, finding two that match is much easier than matching a specific predetermined item
Q.174
What is the primary mechanism of a Cross-Site Request Forgery (CSRF) attack?
A
Tricking an authenticated user's web browser into executing an unwanted, forged action on a trusted site without their knowledge
B
Injecting malicious SQL commands into a login form
C
Overloading a server with ping requests
D
Eavesdropping on a public WiFi network
Q.175
What is the core philosophy underlying Zero Trust Network Access (ZTNA) models?
A
All internet traffic is illegal by default
B
Only users connected to the physical corporate LAN are trusted
C
No entity, whether inside or outside the network perimeter, is trusted by default; strict identity verification is required for every request
D
Passwords are entirely replaced by biometric data
Q.176
How does a 'Pass-the-Hash' attack subvert traditional Windows authentication protocols?
A
By guessing passwords using a dictionary file
B
By capturing the hashed version of a password and using it directly to authenticate, bypassing the need to crack or know the plaintext password
C
By physically stealing the domain controller server
D
By tricking the user into typing their password into a fake portal
Q.177
Why are algorithms like Bcrypt and Argon2 heavily favored over fast algorithms like MD5 or SHA-256 for storing user passwords?
A
They compress the password string to save database space
B
They can be easily reversed if the user forgets their password
C
They are exclusively used by government agencies
D
They intentionally utilize 'key stretching' to make computations slow and resource-intensive, crippling brute-force hardware attacks
Q.178
What critical post-compromise protection does 'Perfect Forward Secrecy' (PFS) provide in secure communication channels?
A
It ensures that if the server's long-term private key is stolen today, past recorded communications cannot be decrypted
B
It prevents the user from taking screenshots of the application
C
It forces passwords to expire every 30 days
D
It deletes emails permanently after reading
Q.179
How does Steganography fundamentally differ from traditional Cryptography?
A
Steganography is mathematical, whereas cryptography is physical
B
Steganography is only used for audio files
C
Cryptography obscures the meaning of a message, while steganography hides the very existence of the message
D
Cryptography relies on passwords, steganography relies on biometrics
Q.180
In the lifecycle of a cyberattack or Advanced Persistent Threat (APT), what does 'Lateral Movement' describe?
A
Physically relocating stolen hardware
B
The process of an attacker moving progressively through a network from an initial compromised low-level device to higher-value internal servers
C
Selling stolen data on the dark web
D
Bouncing an IP address across different countries to evade tracking