Filter interviews by
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are different.
Primary key enforces uniqueness and not null constraint
Unique key enforces uniqueness but allows null values
A table can have only one primary key but multiple unique keys
Primary key is automatically indexed for faster retrieval
Functions are defined by specifying the function name, parameters, return type, and body of the function.
Functions are defined using the 'function' keyword followed by the function name.
Parameters are listed inside parentheses after the function name.
The return type of the function is specified before the function name.
The body of the function is enclosed in curly braces {} and contains the code to be executed.
Exa...
Yes, stored procedures can return result sets or scalar values.
Stored procedures can return result sets containing multiple rows and columns
They can also return scalar values like integers, strings, etc.
Results can be accessed by calling the stored procedure and fetching the output
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
SQL statements are executed in a specific order to retrieve, manipulate, or delete data from a database.
SQL statements are parsed and validated first
Next, the query optimizer creates an execution plan
The execution plan is executed by the SQL engine
Finally, the results are returned to the user
Overcome
To conquer or defeat
To successfully deal with a problem or difficulty
To prevail over obstacles
Magic table is a virtual table in SQL Server that is used to access the inserted, deleted, or updated data during triggers.
Magic table is used in SQL Server triggers to access the data affected by INSERT, UPDATE, or DELETE operations.
It is not a physical table, but a virtual table that stores the affected data temporarily.
The 'inserted' and 'deleted' tables are examples of magic tables in SQL Server triggers.
Indexes are data structures used to improve the speed of data retrieval operations in databases.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Indexes can be created on one or multiple columns in a table.
Examples of indexes are primary key indexes, foreign key indexes, and secondary indexes.
I applied via Company Website and was interviewed before Jul 2023. There was 1 interview round.
SQL statements are executed in a specific order to retrieve, manipulate, or delete data from a database.
SQL statements are parsed and validated first
Next, the query optimizer creates an execution plan
The execution plan is executed by the SQL engine
Finally, the results are returned to the user
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are different.
Primary key enforces uniqueness and not null constraint
Unique key enforces uniqueness but allows null values
A table can have only one primary key but multiple unique keys
Primary key is automatically indexed for faster retrieval
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Overcome
To conquer or defeat
To successfully deal with a problem or difficulty
To prevail over obstacles
Yes, stored procedures can return result sets or scalar values.
Stored procedures can return result sets containing multiple rows and columns
They can also return scalar values like integers, strings, etc.
Results can be accessed by calling the stored procedure and fetching the output
Indexes are data structures used to improve the speed of data retrieval operations in databases.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Indexes can be created on one or multiple columns in a table.
Examples of indexes are primary key indexes, foreign key indexes, and secondary indexes.
Functions are defined by specifying the function name, parameters, return type, and body of the function.
Functions are defined using the 'function' keyword followed by the function name.
Parameters are listed inside parentheses after the function name.
The return type of the function is specified before the function name.
The body of the function is enclosed in curly braces {} and contains the code to be executed.
Example:...
Magic table is a virtual table in SQL Server that is used to access the inserted, deleted, or updated data during triggers.
Magic table is used in SQL Server triggers to access the data affected by INSERT, UPDATE, or DELETE operations.
It is not a physical table, but a virtual table that stores the affected data temporarily.
The 'inserted' and 'deleted' tables are examples of magic tables in SQL Server triggers.
Top trending discussions
I applied via Recruitment Consultant and was interviewed before Oct 2020. There was 1 interview round.
I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.
An interface defines a contract for classes, specifying methods without implementation, promoting abstraction and flexibility in OOP.
Interfaces allow multiple classes to implement the same set of methods, ensuring a consistent API.
Example: An interface 'Animal' with methods 'eat()' and 'sleep()' can be implemented by 'Dog' and 'Cat' classes.
They enable polymorphism, allowing objects to be treated as instances of their ...
I applied via Naukri.com and was interviewed in Jul 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before May 2021. There were 4 interview rounds.
VERBAL QUANT DI/LR and Picture based test
I appeared for an interview before Sep 2020.
Round duration - 90 minutes
Round difficulty - Easy
This round was held during university hours and consisted of 2 coding questions.
Round duration - 120 minutes
Round difficulty - Easy
Make sure you do no cutting and are clear about the approach you'd be following.
Running median of an input stream is the median value of the numbers seen so far in a continuous stream of data.
Maintain two heaps - a max heap for the lower half of the numbers and a min heap for the upper half.
Keep the number of elements in the two heaps balanced or differ by at most 1.
If the total number of elements is odd, the median is the root of the max heap. If even, it is the average of the roots of the two he...
Prepare for company-wise interview questions according to the company in which you are applying. Try to write the code yourself and if got stuck in between then take help from the internet. I recommend you Codezen of Coding Ninjas for practicing Data Structures and Algorithms based questions.
Application resume tips for other job seekersBe sure 100% of what you write in your resume and prepare for that before the interview what is written on resume.
Final outcome of the interviewSelectedI applied via Naukri.com and was interviewed before May 2021. There were 3 interview rounds.
based on 1 interview experience
Difficulty level
Duration
based on 1 review
Rating in categories
Software Engineer
18
salaries
| ₹4.3 L/yr - ₹9.5 L/yr |
Software Developer
12
salaries
| ₹3 L/yr - ₹6 L/yr |
Softwaretest Engineer
11
salaries
| ₹1.6 L/yr - ₹5.3 L/yr |
Data Analyst
10
salaries
| ₹3.5 L/yr - ₹5 L/yr |
RPA Developer
8
salaries
| ₹2.3 L/yr - ₹5 L/yr |
TCS
Accenture
Wipro
Cognizant