Creative Valuers and Engineers Senior Technical Manager Interview Questions and Answers

Normal test with logical questions

Advance java interview questions on database and spring

Q1. Basic questions regarding salary and all
Add your answer
Q2. Normal discussion with hr
Add your answer

Q1. About joins in SQL.
Add your answer
Q2. Get different values in table.
Ans. 
To get different values in a table, you can use SQL queries with DISTINCT keyword.
• Use SELECT statement with DISTINCT keyword to retrieve unique values from a specific column in a table.

• You can also use GROUP BY clause to group the data by a specific column and retrieve distinct values.

• If you want to get distinct values from multiple columns, you can use the combination of DISTINCT and CONCAT functions.

• Example: SELECT D...read more
Answered by AI
Add your answer
Q3. Find duplicate values in table.
Ans. 
To find duplicate values in a table, you can use SQL queries with GROUP BY and HAVING clauses.
• Write a SQL query to select the columns that may contain duplicate values.

• Use the GROUP BY clause to group the rows based on the selected columns.

• Add the HAVING clause with a COUNT function to filter out the groups with more than one occurrence.

• Execute the query to retrieve the duplicate values.
Answered by AI
Add your answer

Q1. Project flow core concepts in dotnet and sitecore
Ans. 
Project flow core concepts in dotnet and sitecore
• Understanding the project requirements

• Creating a project plan and timeline

• Designing the architecture and database schema

• Developing the code using dotnet and sitecore

• Testing and debugging the code

• Deploying the code to production environment

• Maintaining and updating the code as needed
Answered by AI
Add your answer

DSA Easy and Medium questions were asked

Q1. DSA Easy and LLD
Add your answer
Q2. DSA Hard Questions
Add your answer

Q1. Managerial Questions
Add your answer

Q1. Any questions in technical
Add your answer

Q1. Explain about SQL joins.
Ans. 
SQL joins are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query.

• There are different types of joins: inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and matching rows from the right table.

• Right join returns all the...read more
Answered by AI
Add your answer
Q2. Explained about Joins. They asked Mose questions from SQL and queries. You can crack if you have very well query knowledge.
Add your answer