GormalOne Interview Questions and Answers

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

Q1. Scope function in kotlin.
Ans. 
Scope functions in Kotlin are functions that allow you to execute a block of code within the context of an object.
• Scope functions include let, run, with, apply, and also.

• They help in reducing boilerplate code and improving code readability.

• For example, using 'apply' to initialize properties of an object.
Answered by AI
Add your answer
Q2. Work manger, Component of android
Add your answer

Q1. Basic of android
Add your answer
Q2. Basics of kotlin
Ans. 
Kotlin is a modern, statically typed programming language used for Android development, known for its conciseness and safety features.
• Kotlin is fully interoperable with Java, allowing developers to use existing Java libraries.

• It supports null safety, reducing the risk of NullPointerExceptions. Example: 'var name: String? = null' allows null values.

• Kotlin has concise syntax, such as type inference. Example: 'val age = 2...read more
Answered by AI
Add your answer
Q3. What is coroutines? Launch mode of coroutines.
Ans. 
Coroutines are a way to perform asynchronous operations in a sequential manner. Launch modes include launch, async, and runBlocking.
• Coroutines are lightweight threads that can be used for asynchronous programming in Kotlin.

• Launch mode 'launch' starts a new coroutine and does not return any result.

• Launch mode 'async' starts a new coroutine and returns a 'Deferred' object that can be used to retrieve the result.

• Launch mo...read more
Answered by AI
Add your answer
Q4. OOPs concept of core java.
Ans. 
OOPs concept in core Java refers to the principles of Object-Oriented Programming such as Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability of a method to do different things based on the object it is acting upon.

• Abstraction:...read more
Answered by AI
Add your answer
Q5. LifeCycle of android.
Ans. 
The Android lifecycle refers to the series of states an activity or fragment goes through from creation to destruction.
• Android components like activities, services, and broadcast receivers have lifecycles.

• The main lifecycle methods include onCreate(), onStart(), onResume(), onPause(), onStop(), and onDestroy().

• Understanding the lifecycle is crucial for managing resources and handling state changes.

• Example: An activity ...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