Blazeclan Technologies Data Analyst Interview Questions and Answers

Simple aptitude and coding test, I was selected from national talent hunt exam

Q1. Discussion about projects and Areas of interest
Add your answer

Q1. Basic questions like ok with location, shifts etc
Add your answer

Q1. Basis HR questions
Add your answer
Q2. Answer confidently
Add your answer

Q1. Based on previous work
Add your answer
Q2. Answer correctly what you had worked in your previous work
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