Advanced Computer Awareness – 50 MCQs with Answers & Explanations
Advanced Computer Awareness MCQs
A) RAM
B) Cache Memory
C) Hard Disk
D) Optical Disk
Explanation: Cache memory is located very close to the CPU and stores frequently used data and instructions to reduce access time.
Q2. Which protocol translates a domain name such as example.com into an IP address?
A) FTP
B) HTTP
C) DNS
D) SMTP
Explanation: The Domain Name System (DNS) maps human-readable domain names to IP addresses.
Q3. In the OSI model, routing is primarily associated with which layer?
A) Physical Layer
B) Data Link Layer
C) Network Layer
D) Transport Layer
Explanation: The Network Layer is responsible for logical addressing and routing packets between different networks.
Q4. Which of the following is an asymmetric cryptographic algorithm?
A) AES
B) DES
C) RSA
D) 3DES
Explanation: RSA uses a public key and a private key, making it an asymmetric encryption algorithm.
Q5. Which SQL command removes a table, including its structure, from a database?
A) DELETE
B) REMOVE
C) DROP
D) CLEAR
Explanation: DROP TABLE removes the table and its associated data. DELETE removes rows while leaving the table structure intact.
Q6. Which data structure follows the LIFO principle?
A) Queue
B) Stack
C) Tree
D) Graph
Explanation: LIFO means Last In, First Out. The most recently inserted element is removed first.
Q7. Which data structure normally follows the FIFO principle?
A) Stack
B) Queue
C) Tree
D) Heap
Explanation: FIFO means First In, First Out. The first element inserted is normally the first one removed.
Q8. What is the main purpose of virtual memory?
A) To increase processor clock speed
B) To extend apparent memory using secondary storage
C) To permanently store BIOS settings
D) To replace the CPU cache
Explanation: Virtual memory allows the operating system to use disk or SSD space as an extension of physical RAM.
Q9. Which CPU component performs arithmetic and logical operations?
A) Control Unit
B) ALU
C) Register Unit
D) Cache Controller
Explanation: The Arithmetic Logic Unit performs arithmetic calculations and logical comparisons.
Q10. Which component primarily coordinates and controls the execution of instructions?
A) ALU
B) Control Unit
C) RAM
D) SSD
Explanation: The Control Unit directs the CPU's operations and coordinates instruction execution.
Q11. Which attack attempts to make a service unavailable by overwhelming it with traffic from many sources?
A) Phishing
B) DDoS
C) Keylogging
D) Spoofing
Explanation: A Distributed Denial-of-Service attack uses multiple systems or sources to flood a target service with traffic.
Q12. Which of the following is an example of a relational database management system?
A) MySQL
B) Photoshop
C) Linux
D) Chrome
Explanation: MySQL is a relational database management system that organizes data into tables.
Q13. In a relational database, what uniquely identifies each row in a table?
A) Foreign Key
B) Primary Key
C) Candidate Field
D) Index Page
Explanation: A primary key uniquely identifies each record in a relational table.
Q14. Which SQL clause is used to filter rows before grouping?
A) ORDER BY
B) GROUP BY
C) WHERE
D) HAVING
Explanation: WHERE filters individual rows before grouping. HAVING is generally used to filter groups after GROUP BY.
Q15. Which SQL clause is generally used to filter grouped results?
A) WHERE
B) HAVING
C) SELECT
D) DISTINCT
Explanation: HAVING filters groups produced by GROUP BY, particularly when aggregate functions are involved.
Q16. Which protocol is commonly used for sending email?
A) SMTP
B) FTP
C) POP3
D) DNS
Explanation: SMTP, or Simple Mail Transfer Protocol, is primarily used to send email between mail clients and servers and between mail servers.
Q17. Which protocol is commonly used to retrieve email while keeping messages synchronized on the server?
A) SMTP
B) IMAP
C) FTP
D) HTTP
Explanation: IMAP allows email to remain stored on the server and synchronizes messages across devices.
Q18. Which protocol is designed primarily for transferring files between computers?
A) FTP
B) SMTP
C) DNS
D) DHCP
Explanation: FTP stands for File Transfer Protocol and is designed for transferring files over a network.
Q19. Which protocol automatically assigns IP configuration to devices on a network?
A) DNS
B) DHCP
C) FTP
D) ARP
Explanation: DHCP automatically provides network configuration such as IP addresses and related parameters to clients.
Q20. What is the primary purpose of ARP in an IPv4 local network?
A) Convert domain names into IP addresses
B) Map an IPv4 address to a MAC address
C) Encrypt network traffic
D) Assign IP addresses automatically
Explanation: ARP, or Address Resolution Protocol, is used to discover the MAC address associated with an IPv4 address on a local network.
Q21. Which device primarily operates at the Network Layer and forwards packets between networks?
A) Hub
B) Switch
C) Router
D) Repeater
Explanation: Routers forward packets between different networks using logical IP addressing.
Q22. Which device traditionally broadcasts incoming data to all connected ports?
A) Router
B) Hub
C) Switch
D) Firewall
Explanation: A traditional hub repeats incoming signals to all ports rather than selectively forwarding frames.
Q23. Which addressing scheme is associated with the Data Link Layer?
A) IP Address
B) MAC Address
C) URL
D) Port Number
Explanation: MAC addresses identify network interfaces at the Data Link Layer.
Q24. Which OSI layer is responsible for end-to-end delivery and reliability?
A) Network Layer
B) Transport Layer
C) Session Layer
D) Physical Layer
Explanation: The Transport Layer provides mechanisms for end-to-end communication, including reliability and flow control when supported by the protocol.
Q25. Which protocol is connection-oriented and provides reliable byte-stream delivery?
A) UDP
B) IP
C) TCP
D) ICMP
Explanation: TCP establishes a connection and provides reliable, ordered delivery of a byte stream.
Q26. Which protocol is connectionless and generally has lower overhead than TCP?
A) TCP
B) UDP
C) FTP
D) SMTP
Explanation: UDP is connectionless and does not provide TCP-style guaranteed delivery or ordering.
Q27. What does HTTPS add to HTTP?
A) File compression only
B) Encryption and authentication through TLS
C) Faster CPU processing
D) Additional storage
Explanation: HTTPS uses HTTP over TLS, helping protect data in transit and authenticate the server.
Q28. Which type of malware can encrypt files and demand payment for their recovery?
A) Spyware
B) Ransomware
C) Adware
D) Rootkit
Explanation: Ransomware commonly encrypts files or locks systems and demands payment from victims.
Q29. Which malware is designed primarily to secretly monitor a user's activities?
A) Spyware
B) Firewall
C) Worm
D) Compiler
Explanation: Spyware secretly collects information about a user's activity and may transmit it to another party.
Q30. What is the main purpose of multi-factor authentication (MFA)?
A) Increase internet speed
B) Provide multiple independent authentication factors
C) Increase storage capacity
D) Compress files
Explanation: MFA requires two or more different types of authentication factors, improving account security.
Q31. Which of the following is an example of biometric authentication?
A) Password
B) PIN
C) Fingerprint
D) Username
Explanation: Fingerprints are biometric characteristics used to verify a person's identity.
Q32. Which type of encryption uses the same key for encryption and decryption?
A) Symmetric encryption
B) Asymmetric encryption
C) Hashing
D) Digital signature
Explanation: Symmetric encryption uses the same secret key, or corresponding secret material, for encryption and decryption.
Q33. Which of the following is primarily a hashing algorithm rather than an encryption algorithm?
A) AES
B) RSA
C) SHA-256
D) DES
Explanation: SHA-256 is a cryptographic hash function that produces a fixed-length digest.
Q34. What is the main property of a cryptographic hash function?
A) It is designed to be easily reversible
B) It produces a fixed-length digest from input data
C) It always compresses files
D) It assigns IP addresses
Explanation: A cryptographic hash function transforms input into a fixed-length digest and is designed to make reversing the process computationally infeasible.
Q35. Which technology is commonly used to create a secure encrypted tunnel over an untrusted network?
A) VPN
B) DNS
C) DHCP
D) FTP
Explanation: A Virtual Private Network can create an encrypted connection over an untrusted network such as the public internet.
Q36. What is the main purpose of a compiler?
A) Execute only one instruction
B) Translate source code into another form, typically machine code or an intermediate form
C) Manage network traffic
D) Store passwords
Explanation: A compiler translates a program written in a high-level language into a form suitable for execution.
Q37. Which translator executes a program statement-by-statement rather than producing a complete machine-code program in one step?
A) Compiler
B) Interpreter
C) Assembler
D) Linker
Explanation: An interpreter generally reads and executes source instructions progressively rather than compiling the entire program ahead of execution.
Q38. Which language is commonly considered an interpreted, high-level programming language?
A) Python
B) Assembly
C) Machine Code
D) Binary
Explanation: Python is a high-level language commonly executed through an interpreter implementation, although modern implementations may also use compilation to intermediate forms.
Q39. Which of the following best describes an algorithm?
A) A physical computer component
B) A step-by-step procedure for solving a problem
C) A type of database
D) A network cable
Explanation: An algorithm is a finite sequence of well-defined steps designed to solve a problem or perform a task.
Q40. Which data structure is commonly used to implement recursion?
A) Stack
B) Queue
C) Graph
D) Hash table
Explanation: Function calls and recursive calls are commonly managed using a call stack.
Q41. Which sorting algorithm has an average-case time complexity of O(n log n)?
A) Bubble Sort
B) Selection Sort
C) Merge Sort
D) Linear Search
Explanation: Merge Sort has O(n log n) time complexity in its average and worst cases.
Q42. Binary search requires the data to be:
A) Randomly arranged
B) Sorted
C) Encrypted
D) Duplicated
Explanation: Binary search repeatedly divides a sorted search space into halves to locate an element efficiently.
Q43. What is the average time complexity of binary search?
A) O(n)
B) O(n²)
C) O(log n)
D) O(1)
Explanation: Binary search eliminates approximately half of the remaining search space at each step.
Q44. Which database property ensures that a transaction is treated as an indivisible unit?
A) Consistency
B) Atomicity
C) Isolation
D) Durability
Explanation: Atomicity means a transaction either completes fully or has no effect.
Q45. In the ACID properties of a database, what does “D” stand for?
A) Data
B) Dependency
C) Durability
D) Distribution
Explanation: Durability means committed transaction results should persist even after failures such as a system crash.
Q46. Which technology allows multiple virtual machines to run on a single physical computer?
A) Virtualization
B) Defragmentation
C) Encryption
D) Spooling
Explanation: Virtualization allows a physical machine's resources to be divided among multiple virtual environments.
Q47. Which cloud service model provides virtualized computing resources such as servers and storage?
A) SaaS
B) PaaS
C) IaaS
D) DaaS
Explanation: Infrastructure as a Service provides virtualized infrastructure resources such as computing, networking, and storage.
Q48. Which cloud model provides users with ready-to-use software over the internet?
A) IaaS
B) PaaS
C) SaaS
D) BIOS
Explanation: Software as a Service delivers software applications through the internet, usually without requiring users to manage the underlying infrastructure.
Q49. Which of the following is a key characteristic of a deadlock in an operating system?
A) All processes finish immediately
B) Processes wait indefinitely for resources held by one another
C) CPU temperature increases
D) Files are automatically deleted
Explanation: A deadlock can occur when processes are permanently waiting for resources held by other waiting processes.
Q50. Which statement about IPv4 and IPv6 is correct?
A) IPv4 uses 128-bit addresses
B) IPv6 uses 32-bit addresses
C) IPv4 uses 32-bit addresses and IPv6 uses 128-bit addresses
D) Both use 64-bit addresses
Explanation: IPv4 uses 32-bit addressing, while IPv6 expands the address space to 128 bits.