Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by YASH Technologies Team. If you also belong to the team, you can get access from here

YASH Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

YASH Technologies SQL and BI Developer Interview Questions and Answers

Updated 11 Mar 2024

YASH Technologies SQL and BI Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Introduction your self
  • Q2. Power BI scinario base questions

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(13 Questions)

  • Q1. What are Types of joins
  • Ans. 

    Types of joins in SQL are Inner Join, Left Join, Right Join, and Full Join.

    • Inner Join: Returns rows when there is a 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.

  • Answered by AI
  • Q2. Difference between groupby and having clause
  • Ans. 

    GROUP BY is used to group rows that have the same values into summary rows, while HAVING is used to filter groups based on a specified condition.

    • GROUP BY is used with aggregate functions to group the result set by one or more columns.

    • HAVING is used to filter groups based on a specified condition after the GROUP BY clause.

    • GROUP BY is used before the HAVING clause in a query.

    • Example: SELECT department, COUNT(*) FROM empl

  • Answered by AI
  • Q3. What are DML commands
  • Ans. 

    DML commands are Data Manipulation Language commands used to manage data in a database.

    • DML commands include INSERT, UPDATE, DELETE, and SELECT.

    • INSERT is used to add new rows of data into a table.

    • UPDATE is used to modify existing data in a table.

    • DELETE is used to remove rows of data from a table.

    • SELECT is used to retrieve data from a database.

  • Answered by AI
  • Q4. Difference between Primary key and Unique key
  • Ans. 

    Primary key uniquely identifies each record in a table, while Unique key allows only one instance of a value in a column.

    • Primary key does not allow NULL values, while Unique key allows one NULL value.

    • Primary key automatically creates a clustered index, while Unique key creates a non-clustered index by default.

    • Primary key can be referenced by foreign keys, while Unique key cannot be referenced by foreign keys.

  • Answered by AI
  • Q5. What are Index and types of index
  • Ans. 

    Indexes are data structures that improve the speed of data retrieval operations in a database.

    • Indexes are used to quickly locate data without having to search every row in a database table.

    • Types of indexes include clustered, non-clustered, unique, and composite indexes.

    • Clustered indexes determine the physical order of data in a table, while non-clustered indexes store a separate copy of the indexed columns.

    • Unique index...

  • Answered by AI
  • Q6. What is execution plan
  • Ans. 

    Execution plan is a roadmap that SQL Server uses to execute a query, showing the steps taken to retrieve data.

    • Execution plan is generated by the query optimizer to determine the most efficient way to execute a query.

    • It shows the order in which tables are accessed, joins are performed, and filters are applied.

    • Execution plan can be viewed using tools like SQL Server Management Studio or by using the EXPLAIN statement in

  • Answered by AI
  • Q7. Explain about your Project ? challenges faced
  • Q8. Write a sql query depart wise max salary
  • Ans. 

    SQL query to retrieve the maximum salary for each department

    • Use the MAX() function to find the maximum salary

    • Group the results by department using the GROUP BY clause

    • Join the employee table with the department table to get the department information

  • Answered by AI
  • Q9. Given a table TEAM with only one column teamname, write a sql query where each team play with each other , no duplicate match
  • Q10. Provide o/p for innerjoin, left join, right join, cross join on a(1,1,1,2,2,3) b(1,1,2,4)
  • Ans. 

    Different types of SQL joins with given data sets a and b.

    • Inner join: Returns rows where there is a match in both tables (1,1)

    • Left join: Returns all rows from the left table and the matched rows from the right table (1,1,1,2,2)

    • Right join: Returns all rows from the right table and the matched rows from the left table (1,1,2,4)

    • Cross join: Returns the Cartesian product of the two tables (1,1,1,1,1,2,1,4,1,1,2,1,2,2,1,4,2,...

  • Answered by AI
  • Q11. Row_number, rank, dense_rank with example
  • Ans. 

    row_number, rank, dense_rank are window functions in SQL used to assign a unique number to each row based on specified criteria.

    • row_number() assigns a unique sequential integer starting from 1 to each row in the result set

    • rank() assigns a unique rank to each row based on the specified ordering criteria, with gaps in ranking for ties

    • dense_rank() assigns a unique rank to each row based on the specified ordering criteria,

  • Answered by AI
  • Q12. What is trigger
  • Ans. 

    A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.

    • Triggers can be used to enforce business rules, maintain referential integrity, and automate repetitive tasks.

    • Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

    • Triggers can be defined to execute before or after the triggering event.

  • Answered by AI
  • Q13. Diffrenc between function and store procedure
  • Ans. 

    Functions return a value, while stored procedures do not. Functions can be used in SELECT statements, stored procedures cannot.

    • Functions return a single value, while stored procedures can return multiple values or none at all.

    • Functions can be used in SELECT statements to return a value, while stored procedures cannot be used in this way.

    • Functions can be called from within stored procedures, but stored procedures cannot

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant

Round 1 - Technical 

(1 Question)

  • Q1. Ask for basic dot net questions
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. String litteral,
  • Q2. Collection hierarchy
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Tell me about yourself
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Profit and loss,percentage

Round 2 - HR 

(2 Questions)

  • Q1. Why do you this job ?
  • Q2. How can i believe you are the best to our company?

Interview Preparation Tips

Interview preparation tips for other job seekers - Never Give up
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference between comparator and comparison
  • Q2. Implement run time polymorphism
  • Q3. What is stack with an example

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare oops for global logic ans some basic coding questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Difference between sum() and sumx()
  • Ans. 

    sum() is used to calculate the sum of a column, while sumx() is used to calculate the sum of an expression evaluated for each row.

    • sum() is an aggregation function that calculates the sum of a column in a table.

    • sumx() is an iterator function that calculates the sum of an expression for each row in a table.

    • sumx() is useful when you need to perform calculations on a row-by-row basis, while sum() is used for simple column ...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
-

I applied via Job Fair and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

All good , questions are easy and simple

Round 2 - Coding Test 

Array related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - All good
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Oops, delegate, sql, joins, design pattern, solid pattern

YASH Technologies Interview FAQs

How many rounds are there in YASH Technologies SQL and BI Developer interview?
YASH Technologies interview process usually has 1 rounds. The most common rounds in the YASH Technologies interview process are Technical.

Tell us how to improve this page.

YASH Technologies SQL and BI Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
DXC Technology Interview Questions
3.7
 • 795 Interviews
Mphasis Interview Questions
3.4
 • 788 Interviews
Nagarro Interview Questions
4.0
 • 759 Interviews
View all
Senior Software Engineer
1.4k salaries
unlock blur

₹7 L/yr - ₹24.1 L/yr

Software Engineer
1.3k salaries
unlock blur

₹3.2 L/yr - ₹12 L/yr

Associate Consultant
775 salaries
unlock blur

₹2.2 L/yr - ₹10.3 L/yr

Consultant
732 salaries
unlock blur

₹5 L/yr - ₹20.3 L/yr

Module Lead
526 salaries
unlock blur

₹9.2 L/yr - ₹32 L/yr

Explore more salaries
Compare YASH Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Tech Mahindra

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview