Composite indexes combine multiple columns into a single index, allowing for efficient retrieval based on multiple criteria. Therefore, option 2, "Multiple," accurately describes composite indexes.

The Agile Manifesto emphasizes individuals and interactions over processes and tools, valuing working software over comprehensive documentation, customer collaboration over contract negotiation, and responding to change over following a plan. These principles guide Agile teams in prioritizing people and adaptability in software development.

The correct option is Planning. The first phase in the SDLC is Planning, where project goals, scope, requirements, and resources are defined.

The SELECT DISTINCT keyword is used in SQL to retrieve only unique values from a specified column in a table. When you use SELECT DISTINCT, the query results will eliminate duplicate values, presenting only distinct values in the result set. This is particularly useful when you want to analyze or display unique entries without redundancy. It's important to note that SELECT DISTINCT operates on a single column or a combination of columns, and it can be combined with other clauses like WHERE for more specific filtering. Understanding how to use SELECT DISTINCT helps in generating accurate and concise reports or data analysis results.

Journaling in a file system involves recording changes to data in a journal before actually writing them to the main storage. This technique enhances reliability by preventing data loss in case of unexpected system crashes or power failures. When a system crashes, the journal can be used to replay transactions that were not yet committed to the main storage, ensuring data consistency and integrity. As a result, journaling helps maintain the reliability and consistency of file systems, making them more resilient to failures and ensuring data integrity.

Flexbox and Grid are two layout models in CSS used for designing web layouts. Flexbox is a one-dimensional layout method for laying out items in rows or columns, while Grid is a two-dimensional layout method for complex layouts.

Security challenges in containerization include isolation breaches and vulnerabilities such as kernel exploits. Mitigation involves using secure container images, implementing strict network policies, and regularly updating containers and underlying systems.

The CSS box model describes the structure of an HTML element by breaking it down into four components: content, padding, border, and margin. Content refers to the actual content within the element, while padding adds space between the content and the border. The border outlines the content and padding, and margin provides space outside the border. Understanding the box model is essential for layout design and spacing in CSS.

The correct option is Implementation. This phase is where the actual coding takes place based on the design specifications developed in the previous phases. Developers write, compile, and debug the code to ensure it meets the defined requirements. Additionally, testing activities are initiated during this phase to identify and fix defects early in the development process. Once the implementation phase is complete, the software is ready for testing and quality assurance processes before deployment.

SQL indexes are used to improve data retrieval speed by creating a sorted reference to data in a table. This reduces the time required to search and fetch specific records, especially in large datasets. Indexes don't impact storage space significantly but rather optimize data access, ensuring faster query performance. Indexes also contribute to enhancing data security by facilitating efficient data retrieval for authorized users.

A switch's basic function in a network is to forward data packets to specific devices based on their MAC addresses. Unlike hubs, which broadcast data to all connected devices, switches maintain a MAC address table to determine where to send incoming packets. This improves network efficiency by reducing unnecessary traffic and collisions. Switches operate at Layer 2 (Data Link Layer) of the OSI model.

Option 1 suggests using interfaces to define contracts, ensuring a consistent interface for module interactions, which facilitates code reusability and maintainability. This approach allows different team members to work on modules independently while adhering to a predefined interface, promoting code consistency and reducing dependencies between modules. Interfaces also enhance flexibility by enabling polymorphic behavior and easy integration of new modules into the system without affecting existing functionalities.