Add office photos
Filter interviews by
DSoft Infosystem SQL Developer Interview Questions, Process, and Tips for Freshers
DSoft Infosystem SQL Developer Interview Experiences for Freshers
1 interview found
Anonymous
I applied via AmbitionBox and was interviewed before Aug 2022. There were 3 interview rounds.
(4 Questions)
- Q1. What is stored procedure? what are the types of joins?
- Ans.
A stored procedure is a prepared SQL code that can be saved and reused.
Stored procedures are used to perform a specific task or set of tasks in a database.
They can accept input parameters and return output parameters.
Stored procedures can improve performance by reducing network traffic and improving security.
Examples: sp_GetCustomerDetails, sp_InsertEmployee
- Q2. What is view and explain type
- Ans.
A view in SQL is a virtual table based on the result set of a SELECT query. There are different types of views like simple, complex, indexed, etc.
Views are used to simplify complex queries by storing them as a virtual table.
Types of views include simple views, complex views, indexed views, etc.
Views can be used to restrict access to certain columns or rows of a table.
Views can improve performance by pre-computing expen
- Q3. Difference between function and stored procedure
- Ans.
Functions return a value while stored procedures do not. Functions can be used in SQL statements, while stored procedures cannot.
Functions return a single value, while stored procedures do not necessarily return any value.
Functions can be used in SQL statements like SELECT, WHERE, etc., while stored procedures cannot be used in such statements.
Functions are called using SELECT statement, while stored procedures are cal...
- Q4. Write a query to display nth highest salary
- Ans.
Query to display nth highest salary in SQL
Use the ORDER BY clause to sort salaries in descending order
Use the DISTINCT keyword to eliminate duplicates
Use the LIMIT clause to specify the nth highest salary
(1 Question)
- Q1. Current ctc ? how much u expect
Interview Preparation Tips
- stored procedure,views,indexes
- joins
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Asking method overloading and overriding concepts then coding test on oops concepts
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. EXPLAIN ABOUT UR PRJECT
- Ans.
Developed a PL/SQL project for managing inventory and sales data in a retail store.
Designed database tables to store product information, sales transactions, and customer details.
Implemented PL/SQL procedures and functions for adding, updating, and querying data.
Created triggers to enforce business rules and maintain data integrity.
Developed reports using PL/SQL queries to analyze sales performance and inventory levels
- Q2. How do you work on performance optimization
- Ans.
I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.
Analyzing query execution plans to identify bottlenecks
Creating appropriate indexes to improve query performance
Refactoring code to optimize resource usage
Using tools like Explain Plan and SQL Tuning Advisor
(1 Question)
- Q1. What is go routines
- Ans.
Goroutines are lightweight threads managed by the Go runtime, allowing concurrent execution of functions.
Goroutines are created using the 'go' keyword followed by a function call.
They are multiplexed onto multiple OS threads by the Go runtime.
Goroutines communicate using channels to share data safely.
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. All the OOPs concepts
(1 Question)
- Q1. Scrum & Agile Methodologies questions on previous projects
Interview Preparation Tips
Initially HR quoted a CTC and after me attending 3 rounds of interviewes they said they can't offer the quoted CTC.
So my suggestion is to get the things clear with the first call itself so that you can focus on better things
DEEPAK BISHOYI
I applied via Approached by Company and was interviewed in Feb 2024. There were 2 interview rounds.
(5 Questions)
- Q1. PLSQL basic to advanced.
- Q2. Explain collections in details?
- Ans.
Collections in PL/SQL are data structures used to store multiple elements of the same data type.
Collections can be nested tables, varrays, or associative arrays.
Nested tables are like one-dimensional arrays with no upper bounds.
Varrays are like arrays with a maximum size that is specified at declaration.
Associative arrays are like lookup tables where each element is accessed using a unique key.
Collections can be used t...
- Q3. Bulk collect concept
- Ans.
Bulk collect is a feature in PL/SQL that allows for fetching multiple rows of data at once.
Improves performance by reducing context switches between the PL/SQL engine and SQL engine
Reduces network traffic by fetching multiple rows in a single round trip
Can be used with SELECT INTO or FETCH INTO statements
- Q4. Decode and case
- Q5. Tuning of sql and some sql code
Bank product related questions and carrer expericnce .
I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. Android basics question to threads
Software Developer Intern Interview Questions & Answers
Tech Mahindra
Priyansh Jadon
posted on 17 Nov 2024
(2 Questions)
- Q1. Please introduce yourself .
- Q2. Why do you want to join tech mahindra
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
(1 Question)
- Q1. Tell me about yourself?
Selected
I applied via LinkedIn and was interviewed in Oct 2022. There were 6 interview rounds.
Aptitude test is best for first round.
Second round is best for coding test.
(3 Questions)
- Q1. Self introduction and technical information about front end developer.
- Ans. I say properly and uniqly for about my introduction.
- Q2. As a you are fresher or experience
- Q3. Reason for IT field.
- Ans.
IT field offers endless opportunities for innovation and growth.
IT is a constantly evolving field with new technologies and trends emerging regularly.
IT provides opportunities to work on exciting projects and solve complex problems.
IT offers a wide range of career paths, from development to design to project management.
IT is a field that is in high demand, with many job opportunities and competitive salaries.
IT has the...
(2 Questions)
- Q1. About front end developer likes html and css.
- Q2. About html and css and java script
Study about front end developer
Interview Preparation Tips
DSoft Infosystem Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
SQL Developer Interview Questions from Similar Companies
DSoft Infosystem SQL Developer Reviews and Ratings
based on 6 reviews
Rating in categories
|
Database Developer
33
salaries
|  ₹2.4 L/yr - ₹5.6 L/yr |
|
SQL Developer
16
salaries
| ₹2.4 L/yr - ₹3.3 L/yr |
|
Software Engineer
3
salaries
| ₹3 L/yr - ₹3.6 L/yr |
|
Software Developer
3
salaries
| ₹3 L/yr - ₹3.6 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- DSoft Infosystem Interview Questions >
- DSoft Infosystem SQL Developer Interview Questions for Fresher
