i
GormalOne
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
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...
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...
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...
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
I applied via LinkedIn and was interviewed before Jun 2023. There were 5 interview rounds.
Basic DSA + Tech stack
Advanced questions related to Tech stack and project
Basic DSA + project discussion
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2020. There was 1 interview round.
Dagger is required for dependency injection in Android development.
Dagger helps in managing dependencies and reduces boilerplate code.
It provides compile-time safety and improves code readability.
Dagger also helps in testing and modularizing the codebase.
It is widely used in Android development for building scalable and maintainable apps.
The garbage collector in Android automatically manages memory by reclaiming unused objects.
Garbage collector identifies objects that are no longer referenced by the program.
It frees up memory occupied by these objects, making it available for future use.
The process involves marking objects as reachable or unreachable, and then reclaiming memory from unreachable objects.
Garbage collection can be triggered automatically ...
To set equal spacing between childs of constraint layout, use the chain style property.
Create a chain of the views that need equal spacing using the chain style property.
Set the chain style to spread inside the constraint layout.
Adjust the margins of the views to control the spacing.
Use the layout_constraintHorizontal_chainStyle or layout_constraintVertical_chainStyle attribute to set the chain style.
Example: app:layou
I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.
I applied via Referral and was interviewed in Jun 2024. There was 1 interview round.
Data structures commonly used in Android projects include arrays, lists, maps, and sets.
Arrays are used to store a collection of elements of the same data type.
Lists such as ArrayList and LinkedList are used to store a collection of elements that can be accessed by index.
Maps like HashMap and LinkedHashMap are used to store key-value pairs.
Sets like HashSet and TreeSet are used to store unique elements.
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
Lifecycle methods of activity are callback methods that allow you to manage the state of an activity throughout its lifecycle.
onCreate() - called when the activity is first created
onStart() - called when the activity is becoming visible to the user
onResume() - called when the activity will start interacting with the user
onPause() - called when the activity is going into the background, but is still visible
onStop() - ca...
An inline function is a function that is expanded in place at the point of call, rather than being called as a separate function.
Inline functions are typically used for small, frequently called functions to reduce the overhead of function calls.
They are defined with the 'inline' keyword in C++.
Inline functions can improve performance by avoiding the overhead of function call stack operations.
Example: inline int square(
I was interviewed in Aug 2024.
Lifecycle methods of activity are used to manage the state of an activity throughout its lifecycle.
onCreate() - called when the activity is first created
onStart() - called when the activity is becoming visible to the user
onResume() - called when the activity will start interacting with the user
onPause() - called when the activity is going into the background, but still visible
onStop() - called when the activity is no l...
Move all zeroes to the end of an array of strings.
Iterate through the array and keep track of the count of zeroes encountered.
Swap non-zero elements with the first zero encountered to move zeroes to the end.
Context in Android refers to the current state of the application. There are different types of context in Android with varying scopes and lifecycles.
Context is an abstract class in Android that allows access to application-specific resources and classes.
There are three main types of context in Android: Application Context, Activity Context, and Service Context.
Application Context is tied to the lifecycle of the applic...
I was interviewed in Aug 2021.
Round duration - 45 Minutes
Round difficulty - Easy
You are tasked with creating a class named BSTIterator
that acts as an iterator for the inorder traversal of a binary search tree. Implement the following functions:
BST...
Create a BSTIterator class for inorder traversal of a binary search tree.
Implement a constructor that takes the root of the binary search tree and initializes the iterator.
Implement next() function to return the next smallest element in the inorder traversal.
Implement hasNext() function to check if there is a next element in the inorder traversal.
Traverse the binary search tree in inorder to get the desired output.
Given an integer N
, convert it to its corresponding Roman numeral representation. Roman numerals comprise seven symbols: I, V, X, L, C, D, and M.
N = 2
Convert an integer to its corresponding Roman numeral representation.
Create a mapping of integer values to Roman numeral symbols.
Iterate through the mapping in descending order of values and build the Roman numeral representation.
Subtract the largest possible value from the integer at each step and append the corresponding Roman numeral symbol.
Repeat until the integer becomes 0.
Round duration - 45 Minutes
Round difficulty - Medium
Given a positive integer N
, find the number of ways to express N
as a sum of cubes of two integers, A
and B
, such that:
N = A^3 + B^3
Ensure you adhere to the following c...
The problem involves finding the number of ways to express a given positive integer as a sum of cubes of two integers.
Iterate through all possible values of A and B within the given constraints.
Check if A^3 + B^3 equals the given N, increment the count if true.
Handle the case where A = B separately to avoid counting duplicates.
You are given a set of 'N' stones, each with a specific weight and color. The goal is to fill a knapsack with exactly 'M' stones, choosing one stone of each color, so that the to...
The Colorful Knapsack Problem involves selecting one stone of each color to fill a knapsack with a given weight capacity, minimizing unused capacity.
Iterate through the stones and keep track of the minimum weight for each color.
Use dynamic programming to find the optimal solution by considering all possible combinations.
Handle cases where the knapsack cannot be filled under the given conditions by returning -1.
In the g...
Round duration - 15 Minutes
Round difficulty - Easy
Tip 1 : Clear all the topics related to Android with deep details about every topics.
Tip 2 : Practice DSA and algorithms from GFG, CodeStudio daily.
Tip 3 : Dry run code before running the code.
Tip 1 : Mention your open source contributions/ participation in hackathons.
Tip 2 : Provide links to your projects.
based on 2 interviews
Interview experience
based on 12 reviews
Rating in categories
Business Analyst
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Owner
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Test Engineer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Developer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Flipkart
Amazon
Snapdeal
Paytm