i
Unistal Systems
Filter interviews by
I applied via Walk-in and was interviewed in Jul 2021. There were 3 interview rounds.
Top trending discussions
I was interviewed in Jul 2021.
posted on 25 Nov 2022
posted on 28 Feb 2024
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 2 interview rounds.
It is not a aptitude just like a game
posted on 18 Mar 2024
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.
Aggregate functions can also be used with WHERE clause to filter rows before grouping.
WHERE clause filters rows before grouping, while HAVING clause filters groups aft...
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables involved in the query
WHERE: Filters the rows based on specified conditions
GROUP BY: Groups the rows that have the same values into summary rows
HAVING: Filters the groups based on specified conditions
SELECT: Selects the columns to be displayed in the result set
ORDER BY: Sorts the result set based on speci
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.
Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.
Triggers are special types of stored procedures that are auto...
Gave some scenario based questions
Case study walkthrough
posted on 18 Apr 2024
Scenario questions logical solving
Need to explain about problems solved in previous round
I applied via Campus Placement and was interviewed in Jan 2016. There were 3 interview rounds.
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
To find a loop in a linked list, we use Floyd's cycle-finding algorithm.
Floyd's cycle-finding algorithm uses two pointers, one moving at twice the speed of the other.
If there is a loop in the linked list, the two pointers will eventually meet.
To detect the meeting point, we reset one of the pointers to the head of the linked list and move both pointers at the same speed.
The meeting point is the start of the loop.
LRU, MRU and LFU are caching algorithms used to manage memory in computer systems.
LRU stands for Least Recently Used and removes the least recently used items from the cache when the cache is full.
MRU stands for Most Recently Used and removes the most recently used items from the cache when the cache is full.
LFU stands for Least Frequently Used and removes the least frequently used items from the cache when the cache i...
Project Engineer
40
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Project Coordinator
10
salaries
| ₹0 L/yr - ₹0 L/yr |
GIS Analyst
9
salaries
| ₹0 L/yr - ₹0 L/yr |
QA QC Engineer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
QUICK HEAL TECHNOLOGIES
Trend Micro
Gen
McAfee