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 LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.
Easy logical questions
basic quant
Easy level coding questions
Counting frequency of alphabets
Multiple dispatch is not a feature of Redux. It can be achieved using middleware or custom logic.
Middleware like redux-thunk or redux-saga can be used to dispatch multiple actions based on a single action.
Custom logic can be implemented in the reducer to handle multiple actions based on a single action type.
For example, a single 'ADD_ITEM' action can trigger multiple actions like 'UPDATE_TOTAL', 'UPDATE_HISTORY', etc.
M...
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.
Faced various technical challenges, including system integration and performance optimization, which I successfully navigated through strategic solutions.
Integration of legacy systems with modern applications: I utilized APIs and middleware to ensure seamless data flow.
Performance bottlenecks in a web application: Implemented caching strategies and optimized database queries, resulting in a 40% speed increase.
Debugging...
I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Apr 2020. There was 1 interview round.
I am a passionate software developer with 5 years of experience in developing web applications using various technologies.
5 years of experience in software development
Proficient in developing web applications
Skilled in using various technologies
Passionate about coding and problem-solving
Deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlock occurs when two or more processes are stuck in a circular waiting state.
It happens when processes compete for resources and each process holds a resource that another process needs.
Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and ...
Answering questions related to software development and Salesforce administration.
Process Builder is a visual tool in Salesforce used to automate business processes.
Types of relationships in Salesforce include lookup, master-detail, and many-to-many relationships.
User represents an individual who can log in and access Salesforce, Profile defines the permissions and settings for a user, and Role determines the hierarchy...
I have configured various software systems and tools for development purposes.
Configured IDEs such as Eclipse and Visual Studio for development
Set up version control systems like Git and SVN
Installed and configured build tools like Maven and Gradle
Configured application servers like Tomcat and JBoss
Set up databases like MySQL and Oracle for development and testing
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
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
| ₹2.4 L/yr - ₹7 L/yr |
Data Analyst
10
salaries
| ₹3.5 L/yr - ₹5 L/yr |
RPA Developer
8
salaries
| ₹4.5 L/yr - ₹5 L/yr |
TCS
Accenture
Wipro
Cognizant