Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.
A recursive CTE is a Common Table Expression that references itself.
It is used to perform recursive operations on hierarchical data.
It consists of two parts: the anchor member and the recursive member.
The anchor member is the base case and the recursive member is the recursive case.
It can be used to traverse a tree structure or to calculate running totals.
It can improve performance and simplify complex queries.
Output parameters are variables used to return values from a function or stored procedure.
Output parameters are declared with the OUTPUT keyword in SQL Server.
They can be used to return a single value or a table of values.
Output parameters are useful for passing data between stored procedures or functions.
They can also be used to return status codes or error messages.
Transactions ensure data consistency and integrity in a database.
Allows multiple operations to be treated as a single unit of work
Ensures that all operations are either committed or rolled back as a whole
Prevents data inconsistencies and corruption
Provides ACID properties to the database
Example: transferring funds between bank accounts
Example: updating inventory levels after a purchase
File groups are logical containers for database files that can be used to manage storage and backup operations.
File groups allow for the organization of database files into logical units.
They can be used to manage storage and backup operations.
A database can have multiple file groups, each with its own set of files.
File groups can be used to control the placement of data and indexes on different physical disks.
File gro...
Magic tables are temporary tables created by SQL Server during DML operations.
Magic tables are used to access the data before and after an INSERT, UPDATE, or DELETE operation.
They are created automatically by SQL Server and cannot be modified by the user.
The inserted and deleted tables are examples of magic tables.
They are useful for auditing and logging changes to a database.
MERGE is a SQL command used to combine INSERT, UPDATE, and DELETE operations into a single statement.
MERGE is used to synchronize two tables by inserting, updating, or deleting rows based on a specified condition.
It is useful for data warehousing and ETL processes.
MERGE can improve performance by reducing the number of round trips between the client and server.
Syntax: MERGE INTO target_table USING source_table ON condi...
Temp tables are used to store intermediate results during query processing.
Temp tables are created in tempdb database.
They can be local or global.
Local temp tables are only visible to the current session.
Global temp tables are visible to all sessions.
They can be created using SELECT INTO or CREATE TABLE statements.
They can be used to store intermediate results during complex queries.
They are automatically dropped when ...
I applied via Newspaper Ad and was interviewed in Dec 2023. There were 3 interview rounds.
It was nice experience. amazing
posted on 25 Oct 2023
Basic aptitude,sql ques
Visualizing the dataset information
I applied via Job Fair and was interviewed in Mar 2023. There were 2 interview rounds.
To share documents in Sharply, follow these steps:
Open Sharply and log in to your account
Click on the 'Documents' tab
Select the document you want to share
Click on the 'Share' button
Enter the email address of the person you want to share the document with
Click 'Send'
The person will receive an email with a link to access the document
posted on 23 Mar 2023
I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.
posted on 18 Dec 2022
I applied via Company Website and was interviewed in Nov 2022. There were 2 interview rounds.
Freedom of speech is a fundamental human right that allows individuals to express their opinions without censorship or fear of retaliation.
Freedom of speech is protected by many countries' constitutions and international human rights treaties.
It allows individuals to express their opinions, ideas, and beliefs without fear of punishment or persecution.
However, freedom of speech does not protect hate speech, incitement t...
posted on 25 Oct 2022
I applied via LinkedIn and was interviewed in Sep 2022. There were 4 interview rounds.
Aptitude tests will test your ability to perform tasks and react to situations at work.
Coding tests are programming assessment tools used to objectively evaluate a candidate's programming skills across parameters such as problem-solving, coding aptitude, and de-bugging.
posted on 21 Nov 2022
I applied via Approached by Company and was interviewed in Oct 2022. There were 3 interview rounds.
Consisted almost three questions.
based on 42 reviews
Rating in categories
Software Developer
22
salaries
| ₹3 L/yr - ₹11.2 L/yr |
Software Engineer
8
salaries
| ₹3.6 L/yr - ₹12 L/yr |
Database Developer
7
salaries
| ₹4 L/yr - ₹5 L/yr |
Senior Software Developer
6
salaries
| ₹8.2 L/yr - ₹12.2 L/yr |
Team Lead
5
salaries
| ₹8 L/yr - ₹11.4 L/yr |
DELK
Procore
Trimble
Sage Group