Filter interviews by
I applied via Walk-in and was interviewed in Jul 2022. There were 2 interview rounds.
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Sql
ddl
dml
tcl
dql
joins
view
date commit
Date commit
joins
view
sum
max
avg
count
min
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
A project in SQL developer involves designing, implementing, and maintaining databases for various applications.
Understand project requirements and design database schema accordingly
Write efficient SQL queries to retrieve and manipulate data
Optimize database performance by indexing, normalization, and query tuning
Collaborate with developers and stakeholders to ensure database meets project needs
Types of SQL include DDL, DML, DCL, and TCL.
DDL (Data Definition Language) - used to define the structure of database objects (CREATE, ALTER, DROP)
DML (Data Manipulation Language) - used to manipulate data in database objects (SELECT, INSERT, UPDATE, DELETE)
DCL (Data Control Language) - used to control access to data (GRANT, REVOKE)
TCL (Transaction Control Language) - used to manage transactions (COMMIT, ROLLBACK)
They asked to do installation
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
SSIS Architecture is a platform for data integration and workflow applications.
SSIS stands for SQL Server Integration Services
It includes a data flow engine, control flow engine, and event handling
SSIS packages can be created using SQL Server Data Tools (SSDT)
SSIS packages can be scheduled and executed using SQL Server Agent
Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.
Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.
Use the TransactionOption property to specify the level of transaction support needed for each task.
Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
Query to display the highest salary in a table
Use the SELECT statement to retrieve data
Use the MAX() function to find the highest salary
Specify the column name for salary in the query
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered indexes physically reorder the data in the table based on the index key.
Non-clustered indexes create a separate structure for the index, pointing back to the original table data.
Unique indexes ensure that no two rows have the same values in the indexed columns.
Composite indexes are created on multiple columns to improve...
based on 2 reviews
Rating in categories
Associate Software Engineer
26
salaries
| ₹2 L/yr - ₹4.5 L/yr |
Product Engineer
9
salaries
| ₹3 L/yr - ₹7.5 L/yr |
Softwaretest Engineer
8
salaries
| ₹2.4 L/yr - ₹5 L/yr |
Associate Product Engineer
8
salaries
| ₹3 L/yr - ₹3.4 L/yr |
full stack .net developer
7
salaries
| ₹3.4 L/yr - ₹5 L/yr |
TCS
Wipro
Infosys
HCLTech