IDeaS Revenue Solutions Data Analyst Interview Questions and Answers

Q1. Difference between C and Java
Ans. 
C is a procedural language while Java is an object-oriented language.
• C is compiled while Java is interpreted

• C has pointers while Java does not

• Java has automatic garbage collection while C does not

• Java is platform-independent while C is not

• Java has built-in support for multithreading while C does not
Answered by AI
Add your answer

Q1. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets identity columns, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Truncate is used to quickly rem...read more
Answered by AI
Add your answer
Q2. What is an CTE
Ans. 
CTE stands for Common Table Expression, a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTEs are defined using the WITH keyword in SQL.

• They help in simplifying complex queries by breaking them into smaller, more manageable parts.

• CTEs can be recursive, allowing a query to reference itself in order to perform hierarchical or tree-like operations.
Answered by AI
Add your answer

Q1. I'm changing my domain because I don't see much scope for growth in my current domain and I want to make advantage of new opportunities for learning, creativity and success. Additional, I believe that the ...read more
Add your answer
Q2. I understand that being asked to work for an extended number of hours comes with a good reason in the first place, so I'm ok with it.
Add your answer
Q3. Over the year I have really upskilled my self. I believe based on the market standards for this particular role and my experience and skill set a salary range between 10000- 35000 would be fair and appreci...read more
Add your answer
Q4. Can you share more about the day to day responsibilities of this role?
Add your answer
Q5. If I am hired for this role, what would you want me to a achieve in my first two months?
Add your answer
Q6. No ma'am certainly not. Before coming here, I read the job description thoroughly and I have the right skills and qualification required for the role.
Add your answer
Q7. I believe a change in work environment with stimulate my creativity and drive for success.
Add your answer

Q1. SQL Coding question and Power BI
Add your answer

Dsa question were asked along with lr and sql

Tell _____ no of in Delhi