Spire Data Data Engineer 1 Interview Questions and Answers

Q1. They asked related to sql unix
Add your answer

Q1. Difference between Delete and Truncate
Ans. 
Delete removes specific rows from a table, while Truncate removes all rows from a table.
• Delete is a DML operation, while Truncate is a DDL operation.

• Delete can be rolled back, while Truncate cannot be rolled back.

• Delete operation is slower compared to Truncate operation.

• Delete operation maintains the integrity constraints, triggers, and indexes, while Truncate does not.
Answered by AI
Add your answer

Q1. What are joins and types, number of cols after all types of joins...
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include inner join, outer join (left, right, full), and cross join.

• Number of columns after join depends on the type of join and the columns being selected.

• For example, an inner join will only include rows that have matching values in both tables, resulting in a combined table with columns from both tables.

• A left...read more
Answered by AI
Add your answer
Q2. What are the window functions ...
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate cumulative sums, averages, ranks, and more.

• They operate on a set of rows related to the current row, known as the window frame.

• Examples include ROW_NUMBER(), RANK(), SUM() OVER(), and AVG() OVER().
Answered by AI
Add your answer

MCQ based technical questions they have asked. Covering most of the basic abinitio components

Q1. Technical questions like scd types ,rollup normalise join scenarios.
Add your answer

Q1. Basic Azure Data Engineer Questions, focused mainly on SQL
Add your answer

Aptitude Questions related to Basic Quanitative aptitue, psuedo code snippets,Computer Fundamental Questions, Related to Operating System

There are 3 coding question
1.Easy (Related to Arrays)
2.Medium(String related questions)
3.Medium(Stack related questions)

Q1. 1.Introduction 2.Discussion about my projects 3.Questions on some terms which was mentioned in my project 4.One easy level coding questions 5. Two sql questions related to Join Logic 6.Some questions relat...read more
Add your answer

Q1. Mainly for Document Verification
Add your answer

Basic question were asked, it was quite simple if you are from computer background you can pass easily

2 coding questions were there, if you are aware of concepts array, pointers, memory management it will be simple

Q1. Are you ready to relocate
Add your answer
Q2. What's your salary expectation
Add your answer