PYQ Bank — Bank PO / Clerk

HTTPS is the secure version of HTTP that uses SSL/TLS encryption to protect data transmission between a client and server.

The padlock icon in browsers indicates an HTTPS connection, ensuring that sensitive information like passwords and financial data are encrypted. HTTP transmits data in plain text without encryption, making it insecure for sensitive transactions. FTP and SMTP are used for different purposes (file transfer and email sending respectively) and do not provide the same level of security for web browsing.

Normalization is a systematic process in database design that organizes data to eliminate redundancy and anomalies, ensuring data integrity and consistency.

While normalization increases the number of tables (through decomposition into higher normal forms like 1NF, 2NF, and 3NF), it reduces data duplication and prevents insertion, update, and deletion anomalies.

The trade-off involves more tables but cleaner data, whereas denormalization (option A) is sometimes done intentionally for performance but increases redundancy.

Consolidating tables (option C) contradicts normalization principles, and option D describes data security rather than database design.

The most effective approach to reduce merge conflicts is implementing a disciplined workflow with feature branches, smaller and frequent commits, and regular integration (continuous integration practices).

Small commits with clear messages make changes easier to understand and integrate, while feature branches isolate work and reduce the scope of conflicts.

Option A severely limits productivity and collaboration, which defeats the purpose of version control systems.

Option C adds overhead without addressing the root cause of conflicts.

Option D eliminates branching benefits and makes concurrent development nearly impossible, leading to bottlenecks rather than preventing conflicts.

IaaS (Infrastructure as a Service) provides virtualized computing resources like servers, storage, and networking over the internet, requiring organizations to manage applications, data, and middleware.

PaaS (Platform as a Service) abstracts the infrastructure layer and provides a ready-made development and deployment environment with pre-configured middleware, databases, and development tools, shifting more infrastructure management responsibility to the provider.

The key distinction is the level of abstraction and management responsibility; PaaS handles more backend infrastructure, allowing developers to focus purely on application development.

Option A incorrectly describes IaaS as storage-only, option C confuses cost with features, and option D ignores the substantial architectural differences between these service models.

A stack overflow occurs when a program attempts to use more memory on the call stack than is available, typically caused by infinite recursion, excessive recursion depth, or deeply nested function calls.

The call stack has a limited size, and each function call adds a frame to it; when this limit is exceeded, a stack overflow error occurs.

The best prevention is to identify recursive patterns and replace them with iterative solutions, use tail recursion (which some compilers optimize), or implement safeguards like recursion depth limits.

Option A incorrectly attributes this to RAM insufficiency, option B confuses heap with stack memory, and option D overlooks that global variables are stored in the data segment, not the call stack.

HTTPS (HyperText Transfer Protocol Secure) uses SSL/TLS encryption to secure data transmission between a client and server. HTTP transmits data in plain text without encryption, making it insecure. FTP is used for file transfer and SMTP for email, neither of which are designed as secure protocols for general web communication. HTTPS is the standard protocol for secure web browsing and is indicated by the lock icon in browsers.

Normalization is a technique used to organize data in a database to minimize redundancy and dependency, thereby improving data integrity and consistency.

While it may sometimes affect query performance, its primary purpose is to eliminate anomalies and maintain data quality.

Storage capacity and encryption are not the main objectives of normalization; rather, it focuses on logical data organization through various normal forms (1NF, 2NF, 3NF, etc.).

VPN (Virtual Private Network) creates an encrypted tunnel for data transmission, allowing secure remote access to company resources from anywhere.

This is crucial for work-from-home scenarios and protecting sensitive corporate data.

While VPNs may slightly reduce speed due to encryption overhead, speed enhancement is not their primary purpose. VPNs complement firewalls rather than replace them, and they don't significantly reduce bandwidth costs.

The security and accessibility features are the key advantages.

Cache memory is significantly faster than RAM and works as an intermediary between the CPU and main memory (RAM), storing frequently accessed data and instructions.

The CPU checks cache first before accessing slower RAM, thereby reducing average memory access time and improving performance.

Cache is more expensive per unit capacity than RAM, which is why computers have limited cache (kilobytes to megabytes) compared to RAM (gigabytes).

This hierarchical memory structure is fundamental to modern computer architecture.

Symmetric encryption uses a single shared key for both encryption and decryption, making it fast but requiring secure key exchange beforehand.

Asymmetric encryption uses a public-private key pair, eliminating the need to securely transmit keys beforehand, making it ideal for secure initial communication and digital signatures.

Although asymmetric encryption is computationally expensive, it is preferred in scenarios like SSL/TLS handshakes, email encryption, and digital signatures where secure key distribution is essential.

In practice, hybrid approaches combine both methods for optimal security and performance.