Ansys Software Private Limited Intern Interview Questions and Answers

Q1. Sql joins and types of joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one 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.

• F...read more
Answered by AI
Add your answer
Q2. Powerbi and done projects
Add your answer

Q1. How to switch variable
Ans. 
To switch variable values, use a temporary variable to hold one value while swapping the other.
• Create a temporary variable to hold the value of one variable

• Assign the value of the second variable to the first variable

• Assign the value of the temporary variable to the second variable
Answered by AI
View 1 more answer
Q2. They about your introduction and background
Add your answer

Create a small code

Q1. How to switch variable
Ans. 
To switch variable values, use a temporary variable to hold one value while swapping the other.
• Create a temporary variable to hold the value of one variable

• Assign the value of the second variable to the first variable

• Assign the value of the temporary variable to the second variable
Answered by AI
View 1 more answer
Q2. They about your introduction and background
Add your answer

Create a small code