GormalOne Interview Questions and Answers for Freshers

Q1. Difference between Table variable and Temporary Table
Ans. 
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
Answered by AI
Add your answer
Q2. Difference between API and Web Services
Ans. 
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
Answered by AI
Add your answer
Q3. How to Communicate Two API
Ans. 
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
Answered by AI
Add your answer
Q4. What is SQL Locks
Ans. 
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
Answered by AI
Add your answer
Q5. Which SQL execution plan is better
Ans. 
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.
Answered by AI
Add your answer
Q6. What is Identity Management System
Ans. 
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
Answered by AI
Add your answer
Q7. Create Web API Project .Net Core for EmployeeApp which contain id, name salary etc... CRUD operation.
Ans. 
Create a .NET Core Web API for managing employee data with CRUD operations.
• 1. Set up a new .NET Core Web API project using 'dotnet new webapi -n EmployeeApp'.

• 2. Define an Employee model class with properties: Id, Name, Salary.

• 3. Create an EmployeeController with methods for Create, Read, Update, and Delete operations.

• 4. Use Entity Framework Core for data access and create a DbContext for the Employee model.

• 5. Implement...read more
Answered by AI
Add your answer

Basic DSA + Tech stack

Advanced questions related to Tech stack and project

Basic DSA + project discussion

Q1. Aptitude questions
Add your answer

Q1. One on one with Founder
Add your answer