Programming Concepts and System Design

What is the purpose of a loop in programming?

Which data structure is best suited for implementing a queue?

What is the primary function of the Transmission Control Protocol (TCP)?

Which phase is typically involved in the software development lifecycle?

Which of the following is a common method to enhance cybersecurity in web applications?

What is the primary goal of software scalability?

What is a primary advantage of microservices architecture over monolithic architecture?

Which SQL query retrieves employee names with salaries above $50,000?

Core Concepts (Multiple Choice)

Loop Purpose: A loop repeats a specific block of code.
Data Structure for Queue: A linked list is best for implementing a queue.
Transmission Control Protocol (TCP) Function: TCP's primary function is reliable data transfer.

Practical Coding (Programming Exercises)

Python Even Number Sum Function: A Python function (sum_of_evens) calculates the sum of even numbers in a list.
SQL Employee Salary Query: An SQL query retrieves employee names whose salary exceeds $50,000. The query uses SELECT name FROM employees WHERE salary > 50000;

System Design (Essay)

Microservices vs. Monolithic Architecture: Microservices break an application into independent services, whereas monolithic architecture bundles all components into one codebase.
Cloud Migration Advantages/Challenges: Cloud migration advantages include scalability and cost-effectiveness. Challenges include security concerns and data transfer costs.
Scalability Definition: Scalability is a system's ability to handle increased load.
Scalable Application Strategies: Strategies for a scalable application include load balancing, horizontal scaling, and caching.

This quiz explores fundamental programming concepts such as loops and data structures, practical coding exercises in Python and SQL, and system design principles comparing microservices with monolithic architecture. Test your knowledge on these essential topics in computer science!