i
Mindsprint
Filter interviews by
I appeared for an interview in Dec 2023.
Functions return a single value, while stored procedures can perform multiple operations.
Functions return a single value, while stored procedures can return multiple values or perform operations.
Functions can be used in SELECT statements, while stored procedures cannot be used in SELECT statements.
Functions cannot modify the database state, while stored procedures can modify the database state.
Functions can be called f...
An index is a data structure that improves the speed of data retrieval operations on a database table.
Types of indexes include clustered, non-clustered, unique, and filtered indexes.
Clustered indexes physically order the data in the table based on the index key.
Non-clustered indexes store a separate copy of the indexed columns and a pointer to the actual data.
Unique indexes ensure that no two rows have the same values ...
Avoid deadlocks by setting proper isolation levels, minimizing transaction duration, using indexes, and handling errors.
Set appropriate isolation levels to prevent locks from escalating to deadlocks
Minimize transaction duration to reduce the likelihood of deadlocks
Use indexes to improve query performance and reduce the chance of deadlocks
Handle errors gracefully to avoid leaving transactions in an inconsistent state
CTE is a temporary result set while views are permanent virtual tables.
CTE is defined using WITH keyword, while views are defined using CREATE VIEW statement.
CTEs can be referenced within the same query, while views can be referenced in multiple queries.
CTEs are not stored as objects in the database, while views are stored as objects.
CTEs are mainly used for complex queries or recursive queries, while views are used fo
Expected CTC should be based on industry standards, experience, skills, and responsibilities of the role.
Consider industry standards for MS SQL DBA roles
Take into account your level of experience and expertise
Factor in the responsibilities and workload of the position
Research average salaries for similar roles in your location
Be prepared to justify your expected CTC based on your qualifications and value you bring to t
There are approximately 70,000 petrol bunks in India.
India has a population of over 1.3 billion people, and a large number of them own vehicles.
The number of petrol bunks varies from state to state, with some having more than others.
According to a report by the Petroleum Planning and Analysis Cell, there were 69,648 petrol bunks in India as of January 2021.
Approximately 10 million cricket balls are sold in India every year.
Consider the number of cricket matches played in India each year
Take into account the number of cricket academies and schools in India
Factor in the popularity of cricket in India
Assume an average lifespan of a cricket ball
Approximately 10 million cricket balls are sold in India every year
I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.
Experienced in data analysis and project management
Highly motivated and detail-oriented
Strong communication and problem-solving skills
Short term goal is to gain experience and contribute to the company's success. Long term goal is to become a respected industry expert.
Short term goal: Gain experience and contribute to company's success
Long term goal: Become a respected industry expert
Examples: Attend industry conferences, take on challenging projects, seek mentorship
No major issues working in Gurgaon.
Traffic congestion during peak hours
Limited public transportation options
High cost of living compared to other cities
Pollution levels can be high
Availability of skilled resources
I am a software developer with experience in Java and Python.
I have a Bachelor's degree in Computer Science.
I have worked on various projects involving web development and data analysis.
I am proficient in Java and Python programming languages.
I am a quick learner and enjoy working in a team environment.
DBMS stands for Database Management System. It is used to manage and organize data in a structured manner.
DBMS is used in various industries such as healthcare, finance, education, and more.
It helps in creating, modifying, and deleting data in a database.
DBMS provides security features to protect data from unauthorized access.
Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.
An object is a self-contained entity that contains data and behavior.
Objects are instances of classes
They have attributes (data) and methods (behavior)
Objects can interact with each other through method calls
Example: A car object has attributes like color, make, and model, and methods like start and stop
Sorting is the process of arranging data in a particular order.
Sorting can be done in ascending or descending order.
Common sorting algorithms include bubble sort, insertion sort, and quicksort.
Sorting can be done on various data types, including strings, numbers, and objects.
Sorting can be done using built-in functions in programming languages such as sort() in JavaScript.
Sorting can be optimized for performance by cho...
C is a procedural programming language while C++ is an object-oriented programming language.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance than C.
C++ has a larger standard library than C.
C++ allows function overloading while C does not.
C++ supports exception handling while C does not.
I am a software developer with experience in Java and Python. I am passionate about coding and always eager to learn new technologies.
Experienced in Java and Python
Passionate about coding
Eager to learn new technologies
Yes, my family is supportive of my career and relocation decisions.
My family understands the importance of career growth and is supportive of my decisions.
We have discussed the possibility of relocation and they are willing to make the necessary adjustments.
They trust my judgment and believe that this move will be beneficial for my career.
We have also considered the quality of life in Hyderabad and believe that it will...
I appeared for an interview in Sep 2019.
I applied via Recruitment Consultant and was interviewed before Jan 2020. There were 5 interview rounds.
I am proficient in Java, Python, and C++. I have 2 years of experience in software development. I have excellent communication skills for client interaction.
Proficient in Java, Python, and C++
2 years of software development experience
Excellent communication skills for client interaction
I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.
Stored procedure is a precompiled set of SQL statements that can be executed multiple times.
Stored procedure is stored in a database and can be called by applications.
It can accept input parameters and return output parameters.
It can be used to simplify complex SQL queries and improve performance.
It can be used to enforce security by granting permissions to execute the procedure instead of individual SQL statements.
Exa...
I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.
posted on 15 Jul 2022
I applied via Approached by Company and was interviewed before Jul 2021. There were 2 interview rounds.
Basic programming questions
I applied via Naukri.com and was interviewed before May 2018. There were 5 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
based on 1 interview
Interview experience
Analyst
135
salaries
| ₹3.5 L/yr - ₹7.6 L/yr |
Specialist
127
salaries
| ₹4.6 L/yr - ₹11.2 L/yr |
Deputy Manager
115
salaries
| ₹10 L/yr - ₹24 L/yr |
Senior Associate
108
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
Senior Specialist
72
salaries
| ₹6.7 L/yr - ₹13 L/yr |
Luxoft
ARCADIS
Photon Interactive
Trigent Software