What is the main principle of Object-Oriented Programming (OOP)?

  • Abstraction
  • Encapsulation
  • Inheritance
  • Polymorphism
Encapsulation is one of the main principles of Object-Oriented Programming (OOP). It refers to the bundling of data (attributes) and methods (functions) that operate on the data into a single unit or class. Encapsulation helps in hiding the internal complexities of an object and allows access to only the necessary parts through well-defined interfaces. This concept promotes modularity, reusability, and easier maintenance of code in OOP.

The _______ index stores a copy of the indexed columns along with the index data structure.

  • Clustered
  • Composite
  • Non-Clustered
  • Unique
A clustered index stores a copy of the indexed columns along with the index data structure itself. This arrangement of data storage directly corresponds to the order of the indexed columns, making retrieval of data faster when queries align with the index order. However, it's important to note that a table can only have one clustered index, typically on the primary key column.

___________ is a cryptographic technique used to verify the integrity of data transmitted over a network.

  • Decryption
  • Encryption
  • Hashing
  • SSL/TLS
Hashing is used to ensure data integrity by generating a fixed-size hash value for a given input data. This hash value can be compared to verify data integrity during transmission or storage.

What are the main differences between 802.11a, 802.11b, and 802.11g wireless standards?

  • Operates in the 2.4 GHz frequency band
  • Operates in the 5 GHz frequency band
  • Provides a maximum data rate of up to 54 Mbps
  • Uses Orthogonal Frequency Division Multiplexing (OFDM) for improved performance
802.11a operates in the 5 GHz band, providing faster data rates but shorter range. 802.11b operates in the 2.4 GHz band with slower speeds but better range. 802.11g combines elements of both for improved speed and range.

What is regression testing and why is it important in software development?

  • Checks for user acceptance criteria
  • Repeats test cases after code changes
  • Tests new features for bugs
  • Verifies unchanged code behavior
Regression testing involves re-running test cases to ensure that new changes haven't adversely affected existing functionalities. It verifies that the code behavior remains unchanged post-modifications. This is crucial in software development to catch bugs introduced inadvertently during updates and to maintain overall system reliability and stability. It also helps in ensuring that new features don't break existing functionalities.

Explain the role of the Adapter design pattern in software architecture.

  • Facilitating communication between incompatible interfaces
  • Implementing flexible behavior modification
  • Managing concurrent access
  • Optimizing memory usage
The Adapter design pattern allows objects with incompatible interfaces to work together. It acts as a bridge between the client and the target class, enabling communication and interaction. This pattern is useful when integrating existing systems that have incompatible interfaces or when designing reusable libraries that need to work with multiple interfaces.

You're designing a social networking platform where users can have complex relationships with other users and entities. Which type of NoSQL database would you choose and why?

  • Columnar database
  • Document database
  • Graph database
  • Key-value database
Graph databases are ideal for handling complex relationships as they excel in managing interconnected data. Nodes represent entities like users, and edges represent relationships between them. This structure is well-suited for social networks where users have varied connections. Document databases are better suited for semi-structured data and may not handle complex relationships as effectively as graph databases. Columnar databases are optimized for analytical queries, not for complex relationship handling. Key-value databases are efficient for simple data retrieval but lack the structure needed for complex relationships.

In database normalization, the process of organizing data to minimize redundancy and dependency is called ___________.

  • Data normalization
  • Data standardization
  • Data structuring
  • Data validation
Data normalization involves structuring data in a database to reduce redundancy and dependency. This process ensures that each piece of data is stored in only one place and eliminates the potential for inconsistent information. It helps improve data integrity, reduce storage space, and streamline data retrieval and manipulation processes.

Explain the role of the Transport layer in the OSI Model.

  • Ensuring error-free delivery of data packets
  • Establishing a connection between devices
  • Providing logical addressing for devices
  • Segmenting and reassembling data packets
The Transport layer in the OSI Model is responsible for segmenting and reassembling data packets to ensure reliable and efficient communication between end systems. It also handles flow control, error checking, and data integrity to guarantee that information is delivered accurately.

Discuss the pros and cons of using server-side rendering (SSR) with React and Angular.

  • Angular SSR may have a steeper learning curve due to Angular's more extensive framework and setup requirements.
  • Angular SSR provides similar benefits, rendering pages on the server for faster initial loading and improved search engine visibility.
  • SSR with React can be complex to set up and may require additional server resources for rendering.
  • Server-side rendering (SSR) in React improves initial load times and enables better SEO by serving pre-rendered content.
Server-side rendering (SSR) offers advantages like improved performance and SEO, but it also comes with challenges such as setup complexity and resource requirements. Both React and Angular support SSR, and developers must weigh the pros and cons carefully based on project requirements and their team's expertise to decide whether to implement SSR in their applications.