Filter interviews by
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Views, functions, and stored procedures are database objects used to manipulate and retrieve data.
Views are virtual tables that display data from one or more tables in a specific way.
Functions are reusable code blocks that perform a specific task and return a value.
Stored procedures are precompiled SQL statements that can be executed with parameters.
All three objects can improve performance and simplify complex queries...
WHERE clause filters rows before grouping and HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition
HAVING clause is used to filter groups based on a condition
WHERE clause is used with SELECT, UPDATE, DELETE statements
HAVING clause is used with GROUP BY clause
WHERE clause is executed before GROUP BY clause
HAVING clause is executed after GROUP BY clause
Query to retrieve salary based on employee tenure
Use the DATEDIFF function to calculate the tenure of each employee
Join the employee and salary tables on the employee ID
Filter the results based on the tenure of the employee
Select the employee name and salary
Query to calculate manager commission based on employee commission
Join the employee and manager tables on the manager ID
Calculate the total commission earned by each employee
Calculate the total commission earned by all employees under each manager
Calculate the manager commission as a percentage of the total employee commission
Return the manager name and commission amount
Triggers are database objects that automatically execute in response to certain events or changes in data.
Triggers can be used to enforce business rules and data integrity
They can be used to audit changes to data
Triggers can be used to replicate data to other systems
Examples of events that can trigger a trigger include INSERT, UPDATE, and DELETE statements
To delete duplicate rows, use the DISTINCT keyword or GROUP BY clause.
Use the DISTINCT keyword to select unique rows from a table.
Use the GROUP BY clause to group rows with the same values together.
Use the HAVING clause to filter out groups with more than one row.
Use the DELETE statement with a subquery to delete duplicate rows.
Example: DELETE FROM table_name WHERE id NOT IN (SELECT MIN(id) FROM table_name GROUP BY col
Top trending discussions
I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2020. There were 5 interview rounds.
I applied via Campus Placement and was interviewed before Sep 2021. There were 2 interview rounds.
Basic logical program
I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.
Constructor is a special method that is called when an object is created.
Constructors have the same name as the class they belong to.
They are used to initialize the object's state.
They can take parameters to set initial values.
If a class does not have a constructor, a default one is provided.
Example: public class Person { public Person(String name) { this.name = name; } }
Triggers are special stored procedures that are automatically executed in response to certain events or actions in SQL.
Triggers can be used to enforce business rules and data integrity.
They can be used to audit changes to data.
Triggers can be used to replicate data to other tables or databases.
They can be used to send notifications or alerts based on certain conditions.
Examples of events that can trigger a trigger incl
Sorting an array of strings without using inbuilt function.
Implement bubble sort algorithm
Compare adjacent elements and swap if necessary
Repeat until no more swaps are needed
I applied via Campus Placement and was interviewed before Apr 2021. There were 2 interview rounds.
Aptitude, logical , reasoning, verbal
I applied via Referral and was interviewed before Dec 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in Mar 2020. There were 3 interview rounds.
based on 4 reviews
Rating in categories
Associate BI Consultant
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Intelligence Consultant
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Consultant
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Business Intelligence Consultant
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Consultant
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Trianz
Persistent Systems
Mphasis
LTIMindtree