i
UKG
Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
Window functions are used to perform calculations across a set of rows in a table, while analytical functions compute values based on a group of rows.
Window functions include functions like ROW_NUMBER, RANK, and LAG.
They are used to calculate running totals, moving averages, and cumulative sums.
Analytical functions include functions like SUM, AVG, and COUNT.
They are used to compute aggregate values within a group of ro
A table with foreign keys and primary keys is created to establish relationships between tables.
Foreign keys are used to link a column in one table to the primary key of another table.
Primary keys uniquely identify each record in a table.
Foreign keys ensure referential integrity and maintain data consistency.
Example: Creating a 'Orders' table with a foreign key 'customer_id' referencing the 'Customers' table's primary
Top trending discussions
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
516
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Software Engineer
377
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Software Engineer
259
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Software Quality Assurance Engineer
105
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software QA Engineer
101
salaries
| ₹0 L/yr - ₹0 L/yr |
Accenture
IBM
Infosys
TCS