Binary Semantics
Ecom Express Interview Questions and Answers
Q1. Write sql query to extract the records based on particular date
The SQL query to extract records based on a particular date.
Use the SELECT statement to retrieve the desired columns from the table.
Use the FROM clause to specify the table from which to extract the records.
Use the WHERE clause to filter the records based on the desired date.
Use the DATE function to convert the date string to the appropriate format if needed.
Q2. What is abstract vs interface
Abstract class is a class that cannot be instantiated, while interface is a contract that defines a set of methods.
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
A class can implement multiple interfaces, but can only inherit from one abstract class.
Abstract class can have constructors, while interface cannot.
Abstract class can have instance variables, while interface cannot.
Example of abstract class: Animal (wit...read more
Q3. What is Static constructor
A static constructor is a special constructor that is used to initialize the static members of a class.
Static constructors are called automatically before any static member of the class is accessed.
They are used to initialize static variables or perform any necessary setup for the class.
Static constructors do not take any parameters and cannot be called directly.
They are typically used to set default values or initialize shared resources.
Example: public class MyClass { static...read more
Q4. Create dummy procedure with try catch block.
Create a dummy procedure with try catch block.
Create a function with a try block
Add code that may throw an error inside the try block
Add a catch block to handle the error
Optionally, add a finally block to execute code regardless of whether an error was thrown
Q5. Why you want to join Binary
I want to join Binary because of its innovative approach to technology and its reputation for fostering a collaborative and dynamic work environment.
Impressed by Binary's cutting-edge technology solutions
Excited about the opportunity to work in a collaborative and dynamic work environment
Attracted to Binary's reputation for fostering talent and growth
Believe that my skills and experience align well with Binary's values and goals
Q6. What is ITC 04 and it's due dates.
ITC 04 is a form used for claiming input tax credit on goods sent for job work.
ITC 04 is a form under the Goods and Services Tax (GST) regime in India.
It is used for claiming input tax credit on goods sent for job work.
The due date for filing ITC 04 is the 25th of the month succeeding the quarter for which the form is being filed.
Q7. Pillars of oops
Pillars of OOPs are Abstraction, Encapsulation, Inheritance, and Polymorphism.
Abstraction: Hiding implementation details and showing only necessary information.
Encapsulation: Binding data and functions together and restricting access to them.
Inheritance: Acquiring properties and behavior of a parent class by a child class.
Polymorphism: Ability of an object to take many forms and perform different actions based on context.
Top HR Questions asked in Ecom Express
Interview Process at Ecom Express
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month