Filter interviews by
Functions return a value while stored procedures do not.
Functions are used to perform a specific task and return a value.
Stored procedures are used to execute a set of SQL statements and do not return a value.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions are deterministic while stored procedures may not be.
Functions can be use...
Yes, we can delete records from views. Views are virtual tables that display data from one or more tables.
Views are used to simplify complex queries by providing a virtual table with a specific subset of data.
Deleting records from a view will delete the corresponding records from the underlying table(s).
Views can also be used to restrict access to sensitive data by only allowing certain columns to be displayed.
Exa...
Temp table and magic table are used in SQL for temporary storage and tracking changes respectively.
Temp table is used to store intermediate results during a query execution.
Magic table is used to track changes made to a table during an INSERT, UPDATE or DELETE operation.
Temp table is created using CREATE TABLE statement with # or ## prefix.
Magic table is accessed using the special INSERTED and DELETED tables.
Temp ...
Indexing is a way to improve database performance by creating a separate data structure that allows faster data retrieval.
Clustered index: sorts and stores the data rows in the table based on their key values
Non-clustered index: creates a separate structure that includes the indexed columns and a pointer to the data row
Full-text index: enables full-text search on character-based data types
Filtered index: indexes a...
Constraints are limitations or rules that must be followed in software development.
Data constraints: limit the type or amount of data that can be entered
Domain constraints: limit the values that can be entered
Business rules: limit the actions that can be taken
Hardware constraints: limit the hardware that can be used
Time constraints: limit the time available for development or execution
Query optimization techniques aim to improve the performance of database queries.
Use indexes to speed up query execution
Avoid using SELECT * and instead specify only required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Use EXPLAIN to analyze query execution plan
I applied via Campus Placement and was interviewed before Mar 2021. There was 1 interview round.
Indexing is a way to improve database performance by creating a separate data structure that allows faster data retrieval.
Clustered index: sorts and stores the data rows in the table based on their key values
Non-clustered index: creates a separate structure that includes the indexed columns and a pointer to the data row
Full-text index: enables full-text search on character-based data types
Filtered index: indexes a subs...
Query optimization techniques aim to improve the performance of database queries.
Use indexes to speed up query execution
Avoid using SELECT * and instead specify only required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Use EXPLAIN to analyze query execution plan
Functions return a value while stored procedures do not.
Functions are used to perform a specific task and return a value.
Stored procedures are used to execute a set of SQL statements and do not return a value.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions are deterministic while stored procedures may not be.
Functions can be used in ...
Temp table and magic table are used in SQL for temporary storage and tracking changes respectively.
Temp table is used to store intermediate results during a query execution.
Magic table is used to track changes made to a table during an INSERT, UPDATE or DELETE operation.
Temp table is created using CREATE TABLE statement with # or ## prefix.
Magic table is accessed using the special INSERTED and DELETED tables.
Temp table...
Yes, we can delete records from views. Views are virtual tables that display data from one or more tables.
Views are used to simplify complex queries by providing a virtual table with a specific subset of data.
Deleting records from a view will delete the corresponding records from the underlying table(s).
Views can also be used to restrict access to sensitive data by only allowing certain columns to be displayed.
Example:...
Constraints are limitations or rules that must be followed in software development.
Data constraints: limit the type or amount of data that can be entered
Domain constraints: limit the values that can be entered
Business rules: limit the actions that can be taken
Hardware constraints: limit the hardware that can be used
Time constraints: limit the time available for development or execution
Top trending discussions
I appeared for an interview before Jun 2016.
I appeared for an interview before Aug 2016.
posted on 13 Jan 2021
I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.
We are using a variety of technologies, including some of the latest ones.
We are using React for our front-end development.
We are also using Node.js for our back-end development.
We are using Docker for containerization.
We are using Kubernetes for orchestration.
We are using AWS for cloud hosting.
We are constantly evaluating new technologies to see if they can improve our development process.
It depends on the specific requirements and constraints of the project.
Consider the project's goals and objectives
Evaluate the available technologies and their capabilities
Assess the project's budget and timeline
Consult with stakeholders and experts in the field
Examples: React vs Angular, MySQL vs MongoDB, Java vs Python
I applied via Company Website and was interviewed before Dec 2019. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Aug 2021. There was 1 interview round.
posted on 15 Feb 2022
I applied via Referral and was interviewed before Feb 2021. There were 3 interview rounds.
I'm a passionate software engineer with a strong background in full-stack development and a love for solving complex problems.
Graduated with a degree in Computer Science from XYZ University.
Worked at ABC Corp, where I developed a web application that improved user engagement by 30%.
Proficient in languages like JavaScript, Python, and Java, with experience in frameworks like React and Django.
Enjoy collaborating in agile...
Interview questions for Software Engineer position
Project explanation should include details on the project's purpose, scope, and technologies used
SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) are methodologies used in software development and testing respectively
Smoke testing is a type of testing that checks if the basic functionalities of the software are working fine, while Sanity tes...
For loop is used for iterating over a range of values while for each loop is used for iterating over elements of an array.
For loop is used when the number of iterations is known beforehand.
For each loop is used when the number of iterations is not known beforehand.
For loop can be used with any iterable object.
For each loop can only be used with arrays and other iterable objects.
For loop uses an index variable to access...
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
The HashMap class is used to represent key-value pairs in Java.
HashMap is a part of the Java Collections Framework.
It allows null values and only one null key.
It provides constant-time performance for basic operations like get and put.
Example: HashMap<String, Integer> map = new HashMap<>();
Abstraction is the process of simplifying complex systems by focusing on essential details and hiding unnecessary complexities.
Abstraction allows us to create models or representations of real-world objects or systems in software.
It helps in managing complexity by breaking down a system into smaller, more manageable parts.
Abstraction provides a level of indirection, allowing changes to be made in one part of the system...
try-catch is used in Java to handle exceptions and prevent program crashes.
try-catch blocks are used to catch and handle exceptions that may occur during program execution.
It allows the program to gracefully handle errors and prevent the program from crashing.
The try block contains the code that may throw an exception, and the catch block handles the exception.
Multiple catch blocks can be used to handle different types...
The statement to use for selecting based on integer inputs is the 'switch' statement.
The 'switch' statement allows for multiple cases to be evaluated based on the value of an integer input.
Each case represents a possible value of the input, and the corresponding code block is executed if the value matches.
The 'switch' statement also provides a 'default' case which is executed if none of the cases match the input value.
...
posted on 25 Aug 2021
Software Developer
8
salaries
| ₹3 L/yr - ₹6.6 L/yr |
Business Analyst
6
salaries
| ₹2 L/yr - ₹4.8 L/yr |
Laravel Developer
6
salaries
| ₹2.4 L/yr - ₹3.6 L/yr |
PHP Developer
6
salaries
| ₹2.6 L/yr - ₹4.4 L/yr |
UI/UX Designer
5
salaries
| ₹2 L/yr - ₹3.2 L/yr |
HCL Infosystems
Zidio Development
Northcorp Software
Accel Frontline