i
4i apps solutions
Filter interviews by
Top trending discussions
posted on 10 Aug 2024
A self join query is used to join a table to itself in a SQL query.
Self join is used when a table needs to be joined with itself to compare rows within the same table.
It requires aliasing the table with different names to distinguish between the two instances of the same table.
Commonly used in hierarchical data structures or when comparing related rows in a table.
Group by query is used to group data based on a specific category.
Use the GROUP BY clause in SQL to group data based on a specific column
Aggregate functions like COUNT, SUM, AVG can be used with GROUP BY to perform calculations on grouped data
Example: SELECT category, COUNT(*) FROM products GROUP BY category
posted on 8 Feb 2022
posted on 1 May 2023
I applied via Campus Placement and was interviewed in Nov 2022. There were 2 interview rounds.
A linked list is a data structure that consists of a sequence of nodes, each containing a reference to the next node.
Each node has a data field and a next field that points to the next node
Insertion and deletion can be done efficiently
Traversal starts from the head node and continues until the end node is reached
posted on 19 Sep 2024
I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.
It was around 2 hrs with 2 coding questions and some mcq questions on fundamentals
Print numbers in a tree format
Use recursion to print numbers in a tree structure
Start with the root node and recursively print child nodes
Use indentation to represent levels in the tree
Example: 1 --2 ----3 --4
Factorial of a number can be calculated using both iterative and recursive methods.
Iterative method involves using a loop to multiply numbers from 1 to n.
Recursive method involves calling the function with n-1 until n reaches 1.
Example: Factorial of 5 using iterative method: 5! = 5*4*3*2*1 = 120
Example: Factorial of 5 using recursive method: 5! = 5 * 4!
Example: Factorial of 4 using recursive method: 4! = 4 * 3!
posted on 5 Sep 2024
I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.
Medium level leetcode
Join queries are used to combine data from multiple tables based on a related column between them.
Use JOIN keyword to combine tables based on a common column
Specify the columns to select from each table
Use WHERE clause to specify the join condition
posted on 5 Sep 2023
It placed in hackerRank.question difficulty level was medium.
posted on 27 Oct 2023
I applied via Campus Placement and was interviewed before Oct 2022. There were 4 interview rounds.
It was a MCQ + Coding test
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
Sqlite database can be implemented in React Native using 'react-native-sqlite-storage' package.
Install 'react-native-sqlite-storage' package using npm.
Import SQLite from 'react-native-sqlite-storage'.
Create a database using SQLite.openDatabase() method.
Execute SQL queries using executeSql() method.
Close the database connection using close() method.
Generator functions are functions that can be paused and resumed, allowing for lazy evaluation of data.
Generator functions use the yield keyword to pause execution and return a value.
They can be used to generate an infinite sequence of values.
They are memory efficient as they only generate values when needed.
Example: function* myGenerator() { yield 1; yield 2; yield 3; }
Example: const infiniteGenerator = function*() {
Push notifications can be implemented in Android and iOS using Firebase Cloud Messaging (FCM) and Apple Push Notification service (APNs) respectively.
For Android, integrate FCM SDK in the app and use FCM console to send notifications.
For iOS, create an APNs certificate, configure the app to receive notifications, and use APNs to send notifications.
Both platforms require handling of notification payload in the app to di...
I used React Native for my last app.
Developed UI components using React Native
Integrated APIs to fetch and display data
Implemented Redux for state management
Used Firebase for authentication and database
Optimized app performance using React Native Debugger
Functional components are stateless and return UI elements based on input props, while non-functional components have state and can change UI based on user interaction.
Functional components are simpler and easier to test than non-functional components.
Non-functional components can have state and lifecycle methods, while functional components cannot.
Examples of functional components include buttons, labels, and icons, w...
I applied via Recruitment Consulltant and was interviewed in Sep 2023. There were 4 interview rounds.
Intermediate aptitude questions .
No negative marking .
Written test held at JMR infotech
based on 1 interview
Interview experience
Technical Consultant
74
salaries
| ₹4 L/yr - ₹13 L/yr |
Functional Consultant
46
salaries
| ₹4.9 L/yr - ₹20 L/yr |
Senior Associate Technical Consultant
45
salaries
| ₹2.3 L/yr - ₹7.5 L/yr |
Oracle Financial Functional Consultant
39
salaries
| ₹4.9 L/yr - ₹16.8 L/yr |
Oracle Technical Consultant
34
salaries
| ₹3.5 L/yr - ₹12 L/yr |
PC Solutions
RNF Technologies
JMR Infotech
Hidden Brains InfoTech