Agiliad Technologies Site Reliability Engineer 2 Interview Questions and Answers

First they conducted the testing round that is pseudo code only 2 they conducted.

In laptop then they conducted aptitude, logical reasoning and java mcqs

Q1. First the panel asked self introduction then oops concept and joins how many types of joins are there then normalization and view.
Add your answer
Q2. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

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

• Delete fires triggers, while truncate does not fire triggers.
Answered by AI
Add your answer

Q1. Explain Oops concepts in c# Solid and design principles Task vs thread Difference between interface and abstract class
Ans. 
OOPs concepts in C#, SOLID and design principles, Task vs Thread, Interface vs Abstract class
• OOPs concepts in C# include encapsulation, inheritance, polymorphism, and abstraction

• SOLID principles are Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion

• Task is a unit of work in C# that represents an asynchronous operation, while Thread is a separate path of execution wi...read more
Answered by AI
Add your answer

Q1. Same as 1 st round with programing questions
Add your answer

Q1. Explain singleton design pattern, And general questions
Add your answer

Q1. Interface why we use Basic OOPs Sorting Algo
Ans. 
Interfaces are used in OOP to define a contract for classes to implement, allowing for polymorphism and loose coupling.
• Interfaces in OOP define a set of methods that a class must implement, providing a contract for behavior.

• Interfaces allow for polymorphism, where different classes can be treated as instances of the same interface.

• Interfaces promote loose coupling between classes, as they only need to know about the in...read more
Answered by AI
Add your answer

Q1. About different types of sensors, about power factor. APFC, fundamental electrical and electronics such as uses of capacitor in a electronics card,uses of multimeter, meggar, based on what you show in your...read more
Add your answer

Q1. Describe designing of Conveyors
Add your answer
Q2. Iso questions
Add your answer

Q1. For installation department 1- Levelling and alignment of conveyors 2- brief knowledge of sensors 3- knowledge about rollers, bearings, cylinders, Solenoid, motors, sprocket. 4- knowledge about join...read more
Add your answer

Q1. Project related C C++
Add your answer

Q1. Salary negotiation
Add your answer