GormalOne Full Stack Software Developer Interview Questions, Process, and Tips

Table variables are created in memory and are scoped to the batch, while temporary tables are stored in tempdb and can be accessed across batches.

• Table variables are created using DECLARE statement, while temporary tables are created using CREATE TABLE statement.

• Table variables are limited to the scope of the batch or stored procedure in which they are declared, while temporary tables can be accessed across batches.

• Tab...read more

API is a set of rules and protocols that allows different software applications to communicate with each other. Web services are a type of API that are accessed over a network, typically using HTTP.

• API is a broader term that encompasses all types of interfaces for software communication.

• Web services are a specific type of API that are accessed over a network, often using HTTP protocols.

• APIs can be used for various purp...read more

Communicate two APIs by using HTTP requests to send and receive data between them.

• Use HTTP methods like GET, POST, PUT, DELETE to interact with APIs

• Utilize JSON or XML format to send and receive data

• Implement authentication mechanisms like API keys or OAuth for secure communication

SQL locks are mechanisms used to control access to data in a database to prevent conflicts and ensure data integrity.

• SQL locks are used to prevent multiple users from accessing or modifying the same data simultaneously.

• There are different types of SQL locks such as shared locks, exclusive locks, and update locks.

• Locks can be applied at different levels such as row-level, page-level, or table-level.

• For example, a shared...read more

The SQL execution plan that is more efficient and utilizes indexes is better.

• Look for execution plans that utilize indexes to minimize the number of rows scanned.

• Avoid full table scans if possible, as they can be resource-intensive.

• Consider the use of join algorithms like nested loops, hash joins, or merge joins for optimal performance.

Identity Management System is a system used to manage and control user identities and access permissions within an organization.

• It centralizes user data and permissions

• It allows for single sign-on across multiple systems

• It enhances security by enforcing access controls

• Examples include Active Directory, Okta, and OneLogin