AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Assetsoft Consulting Database Developer Interview Questions and Answers
Assetsoft Consulting Database Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Stored procedure vs function
- Ans.
Stored procedures are used to perform a set of actions, while functions return a single value.
Stored procedures can perform multiple actions and can return multiple result sets.
Functions are used to return a single value based on input parameters.
Stored procedures can be called independently, while functions are typically called within SQL statements.
Stored procedures can contain DML statements, while functions cannot.
- Q2. Index and its difference
- Ans.
Index is a data structure that improves the speed of data retrieval in a database.
Indexes are used to quickly locate data without having to search every row in a database table.
They can be created on one or more columns in a table.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Examples of indexes are primary keys, foreign keys, and indexes created for frequently searched columns.
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Hr
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How do you get the second to last element from a SQL table?
- Ans.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Mar 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me something about yourself
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Basics about .Net and SQl server
- Q2. What are triggers
- Ans.
Triggers are database objects that automatically execute in response to certain events or changes in data.
Triggers are used to enforce business rules or data integrity.
They can be used to audit changes to data.
Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.
They can be defined on tables, views, or schemas.
Examples of triggers include sending an email notification ...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Dec 2019. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about your self
Interview Preparation Tips
I applied via Job Portal and was interviewed before Dec 2019. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. First they ask basic questions like HTML SQL Java.
Interview Preparation Tips
I appeared for an interview before Nov 2020.
(2 Questions)
Round duration - 90 minutes
Round difficulty - Medium
Timing was around 10am
It was quite a normal online examination kind of environment
People from the company were there to invigilate
All were quite nice and helpful in case the exam got stuck
- Q1.
Ninja and Alien Language Order Problem
An alien dropped its dictionary while visiting Earth. The Ninja wants to determine the order of characters used in the alien language, based on the given list of wor...
- Ans.
Determine the order of characters in an alien language based on a list of words.
Create a graph data structure to represent the relationships between characters in the words.
Perform a topological sort on the graph to find the order of characters.
Return the smallest lexicographical order of characters as the result.
- Q2.
Check Duplicate Within K Distance
Given an array of integers
arrof sizeNand an integerK, determine if there are any duplicate elements within a distance ofKfrom each other in the array. Return"true... - Ans.
Check if there are any duplicate elements within a distance of K from each other in the array.
Iterate through the array and keep track of the indices of elements using a hashmap.
For each element, check if it already exists in the hashmap within distance K.
Return true if a duplicate is found within distance K, otherwise return false.
(1 Question)
Round duration - 30 minutes
Round difficulty - Medium
Timing was 2pm when it started
Interviewer was polite
- Q1.
Kth Largest Element Problem Statement
Ninja enjoys working with numbers, and Alice challenges him to find the Kth largest value from a given list of numbers.
Input:
The first line contains an integer 'T... - Ans.
The task is to find the Kth largest element in a given list of numbers for each test case.
Read the number of test cases 'T'
For each test case, read the number of elements 'N' and the Kth largest number to find 'K'
Sort the array in descending order and output the Kth element
Round duration - 20 minutes
Round difficulty - Easy
Timing was 9 am onwards
Interviewer was good enough
Interview Preparation Tips
Tip 1 : Focus on specialization of any one skill and keep a basic knowledge of all the skills you mention in your resume
Tip 2 : Gain confidence in presenting yourself by practicing well before
Tip 3 : Gain a basic knowledge of the company you go for selection
Tip 1 : Resume should be simple and precise but pretty smart to cover your skills
Tip 2 : Mention what you really know,no false things
Skills evaluated in this interview
I applied via Applied in more than one job portal can't remember now. and was interviewed before Jan 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. About struts framework.
Interview Preparation Tips
I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions.
Interview Preparation Tips
If you are lucky you will get project with new technologies and you can learn.
Assetsoft Consulting Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- SQL Server Database Administrator Interview Questions
- Mysql Database Administrator Interview Questions
- DB2 Database Administrator Interview Questions
- Show more
Assetsoft Consulting Database Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
SQL Developer
6
salaries
|  ₹4 L/yr - ₹8.2 L/yr |
|
Business Analyst
4
salaries
| ₹6.3 L/yr - ₹16 L/yr |
|
Senior SQL Developer
4
salaries
| ₹5 L/yr - ₹9.4 L/yr |
|
QA
4
salaries
| ₹6 L/yr - ₹9 L/yr |
|
Software Developer
3
salaries
| ₹14 L/yr - ₹15.1 L/yr |
Wipro
Cognizant
Infosys
Tech Mahindra
- Home >
- Interviews >
- Assetsoft Consulting Interview Questions >
- Assetsoft Consulting Database Developer Interview Questions
