Part 2 — Answer key

Compare your answers after you have finished Part 1.

1. In a basic Proprofs general knowledge quiz on web technology, which protocol is most commonly used to transfer web pages from a server to a browser?
   HTTP
2. HTML is primarily used to define the structure and content of web pages that browsers display to users.
   True
3. In a Proprofs quiz gk question about networking hardware, which device connects multiple networks together and forwards packets between them based on IP addresses?
   Router
4. In a general knowledge quiz Proprofs might host about SQL, which command removes all rows from a table while keeping the table structure intact?
   TRUNCATE TABLE
5. In a Proprofs quiz gk question about cloud models, which option gives customers the least direct control over the underlying operating system?
   Software as a Service (SaaS)
6. In a gk quiz Proprofs might run on algorithms, what does the "O" represent in the notation O(n) when describing time complexity?
   Order of growth of time or space as input size increases
7. Storing Proprofs quiz user passwords in plain text is acceptable as long as the database is protected by a strong firewall.
   False
8. A developer updating the grading script for a Proprofs quiz finds that the Python program now crashes only when a certain input is processed, even though the file loads without syntax errors. Which type of error is most likely occurring?
   Runtime exception
9. You manage user logins for a Proprofs general knowledge quiz site and want to reduce the risk of brute-force password attacks. Which configuration is most effective?
   Lock an account after several consecutive failed login attempts
10. Users in another region report that a Proprofs general knowledge quiz loads slowly, even though your server bandwidth is not fully used. Which network metric most directly measures the time it takes for a packet to travel from their device to your server and back?
    Latency
11. You are optimizing the layout of a Proprofs gk quiz page so it works well on phones, tablets, and desktops. Which web design approach directly ensures the layout adapts to different screen widths?
    Use a responsive layout with fluid grids and CSS media queries
12. You want to deploy a quiz application so it can automatically scale with traffic spikes on a cloud provider while minimizing server management tasks. Which option best matches this goal?
    Use a PaaS managed application platform to host the app
13. In a relational database, a foreign key in one table typically references the primary key in another table to enforce referential integrity.
    True
14. In a public cloud model, every customer always runs on dedicated physical hardware that is never shared with other customers.
    False
15. Users are intermittently reporting slow access to a Proprofs general knowledge quiz hosted in the cloud. Which network conditions could directly increase page load time? Select all that apply.
    High latency between users and the server; Bandwidth congestion on the server's outbound link; Significant packet loss on the network path
16. Your quiz platform's results table has grown very large, and SELECT queries filtered by category_id and difficulty have become slow. Without changing application code, which database design change is most likely to improve query performance?
    Add a composite index on category_id and difficulty
17. Your Proprofs quiz admin login is being targeted by credential stuffing attacks using leaked username and password pairs. Which measure best reduces the impact of such attacks on user accounts?
    Enable multi-factor authentication for user accounts
18. An administrator is securing the backend of a Proprofs quiz gk application against SQL injection. Which practices specifically help prevent SQL injection attacks? Select all that apply.
    Use parameterized queries or prepared statements for database access; Validate and whitelist all user input before using it in queries; Limit the database user's privileges to only required operations
19. You are deploying a Proprofs quiz API to a cloud provider and want high availability during traffic spikes and outages. Which choices contribute directly to higher availability? Select all that apply.
    Set up health checks and automated failover through a load balancer; Configure auto-scaling groups with health-based scaling policies; Run instances in multiple availability zones within the same region
20. You are designing an analytics system for millions of Proprofs quiz result records using a columnar database. Which design choices align well with column-oriented analytical workloads? Select all that apply.
    Store data in a column-oriented format rather than row-major format; Use a wide denormalized fact table for query-heavy metrics; Apply compression algorithms to columns with similar data types
21. You are optimizing backend code that evaluates answers for a busy Proprofs general knowledge quiz. Which refactorings are likely to improve performance of the hottest execution paths without changing behavior? Select all that apply.
    Remove unnecessary object allocations inside tight loops; Cache results of expensive pure functions that get called repeatedly; Replace nested loops over large lists with hash map lookups where appropriate
22. Arrange the following events in the correct order for how a user's browser loads and displays a Proprofs quiz web page after the user clicks the quiz link.
    Correct order: User enters the quiz URL or clicks the quiz link and the browser resolves the domain via DNS → The browser establishes a TCP connection to the web server, often upgraded to TLS → The browser sends an HTTP request for the quiz page and related resources → The web server processes the request and sends back an HTTP response with HTML, CSS, and JavaScript → The browser parses the response, downloads additional resources, and renders the quiz interface for the user