Wepsol Senior Software Engineer Interview Questions and Answers

TypeScript is a superset of JavaScript that adds static typing and other features to help developers write more robust code.

• TypeScript is developed and maintained by Microsoft.

• It compiles down to plain JavaScript.

• It helps catch errors at compile time rather than runtime.

OOPs concepts are the fundamental principles of object-oriented programming.

• Encapsulation - binding data and functions together

• Inheritance - creating new classes from existing ones

• Polymorphism - ability of objects to take on multiple forms

• Abstraction - hiding implementation details from users

Design patterns are reusable solutions to common software problems. One example is the Singleton pattern.

• Creational patterns: Singleton, Factory, Abstract Factory, Builder

• Structural patterns: Adapter, Bridge, Composite, Decorator, Facade, Flyweight, Proxy

• Behavioral patterns: Chain of Responsibility, Command, Interpreter, Iterator, Mediator, Memento, Observer, State, Strategy, Template Method, Visitor

• Singleton pattern e...read more

Triggers respond to database events; procedures are reusable code blocks; packages group related procedures/functions.

• Triggers are automatically executed in response to specific events (e.g., INSERT, UPDATE).

• Example of a trigger: A trigger that logs changes to a table whenever a row is updated.

• Procedures are named blocks of code that can be executed explicitly by calling them.

• Example of a procedure: A procedure that ca...read more

ACID properties ensure reliable transactions in databases: Atomicity, Consistency, Isolation, Durability.

• Atomicity: Transactions are all-or-nothing. Example: If a bank transfer fails, both accounts remain unchanged.

• Consistency: Transactions bring the database from one valid state to another. Example: A transaction must not violate any database rules.

• Isolation: Concurrent transactions do not affect each other. Example: ...read more

Cursors are database objects used to retrieve and manipulate data row by row.

• 1. Implicit Cursors: Automatically created by SQL for single SQL statements. Example: SELECT * FROM employees;

• 2. Explicit Cursors: Defined by the programmer for complex queries. Example: DECLARE cursor_name CURSOR FOR SELECT * FROM orders;

• 3. Forward-only Cursors: Can only move forward through the result set. Example: Used for simple read opera...read more