EbixCash Limited Interview Questions and Answers

Q1. How many type of constraints in sql?
Ans. 
SQL constraints are rules applied to table columns to enforce data integrity and consistency.
• 1. NOT NULL: Ensures a column cannot have a NULL value. Example: `CREATE TABLE Employees (ID INT NOT NULL);`

• 2. UNIQUE: Ensures all values in a column are different. Example: `CREATE TABLE Users (Email VARCHAR(255) UNIQUE);`

• 3. PRIMARY KEY: A combination of NOT NULL and UNIQUE, uniquely identifies each row. Example: `CREATE TABLE...read more
Answered by AI
Add your answer

Q1. Find the last 2 row in sql?
Ans. 
To find the last 2 rows in SQL, use ORDER BY with LIMIT or FETCH depending on the SQL dialect.
• Use 'SELECT * FROM table_name ORDER BY column_name DESC LIMIT 2;' for MySQL.

• In SQL Server, use 'SELECT TOP 2 * FROM (SELECT * FROM table_name ORDER BY column_name DESC) AS temp_table;'

• For PostgreSQL, use 'SELECT * FROM table_name ORDER BY column_name DESC LIMIT 2;'

• Ensure to replace 'column_name' with the appropriate column to ...read more
Answered by AI
Add your answer

4 questions of coding, level - easy and medium

Q1. Asp.net mvc , sql server etc
Add your answer

Q1. Managerial round, .net and sql server related questions
Add your answer

Q1. Salary negotiation
Add your answer

Q1. What are the labour laws in Uttar Pradesh, and how can you implement the HR processes related to them?
Ans. 
Uttar Pradesh has various labour laws governing employment, wages, and workplace safety, crucial for HR compliance.
• The Industrial Disputes Act, 1947: Ensures fair treatment in case of disputes between employers and employees.

• The Minimum Wages Act, 1948: Mandates minimum wage rates for different sectors; HR must ensure compliance to avoid penalties.

• The Employees' Provident Funds and Miscellaneous Provisions Act, 1952: R...read more
Answered by AI
Add your answer

Q1. What is Common Term Expression?
Add your answer
Q2. What is Overloading and Overriding?
Ans. 
Overloading is having multiple methods in the same class with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.
• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding is when a subclass provides a specific implementation of a method that is already defined in its parent class.

• Example o...read more
Answered by AI
Add your answer
Q3. Examples of Server side session Management? Types of Session State?
Ans. 
Server side session management involves storing user data on the server to maintain state. Types include in-process, out-of-process, and database.
• In-process session state: Data stored in memory on the same server as the application.

• Out-of-process session state: Data stored in a separate server or service, such as a state server or Redis cache.

• Database session state: Data stored in a database, such as SQL Server or MySQ...read more
Answered by AI
Add your answer
Q4. How to Debug Stored Procedures?
Ans. 
Debugging stored procedures involves using tools like SQL Server Management Studio, setting breakpoints, and analyzing query execution.
• Use SQL Server Management Studio to debug stored procedures

• Set breakpoints in the stored procedure code to pause execution at specific points

• Analyze query execution using tools like SQL Profiler to identify issues

• Use PRINT or SELECT statements to output intermediate results for debuggin...read more
Answered by AI
Add your answer
Q5. What is Compile time binding and Runtime Binding?
Ans. 
Compile time binding occurs during compilation while runtime binding occurs during execution.
• Compile time binding is also known as early binding, where the method to be called is determined at compile time based on the type of the object.

• Runtime binding is also known as late binding, where the method to be called is determined at runtime based on the actual type of the object.

• Compile time binding is faster as it is don...read more
Answered by AI
Add your answer

Q1. Can you tell me a little about yourself
Ans. 
I am a detail-oriented finance professional with extensive experience in credit control and accounts receivable management.
• Over 5 years of experience in credit control, managing accounts for various clients.

• Successfully reduced overdue accounts by 30% in my previous role through effective communication and follow-up.

• Skilled in using accounting software like SAP and QuickBooks to track payments and manage customer accou...read more
Answered by AI
Add your answer
Q2. Why do you want to work for our company
Ans. 
I admire your company's commitment to financial integrity and customer relationships, making it an ideal place for my skills as a Credit Controller.
• Your company's strong reputation in the industry aligns with my values of professionalism and integrity.

• I am impressed by your innovative approach to credit management, which I believe enhances customer satisfaction.

• The opportunity to work with a diverse client base excites...read more
Answered by AI
Add your answer
Q3. How does this ole fit into your overall career aspiration ?
Ans. 
This role aligns with my goal to enhance financial expertise and contribute to organizational success through effective credit management.
• I aim to develop my financial acumen, and this role provides hands-on experience in credit control.

• Working as a Credit Controller will enhance my analytical skills, crucial for assessing credit risks.

• I aspire to take on leadership roles in finance, and this position will build my fou...read more
Answered by AI
Add your answer

Q1. Why are you leaving your current job
Ans. 
I'm seeking new challenges and opportunities for growth that my current role doesn't provide.
• Desire for professional growth: I've reached a plateau in my current position and am eager to take on more responsibilities.

• Looking for a better cultural fit: My current company culture doesn't align with my values, and I'm seeking a more collaborative environment.

• Interest in expanding my skill set: I want to work in a role tha...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in five years
Ans. 
In five years, I envision myself as a senior credit controller, leading a team and implementing innovative credit management strategies.
• Progressing to a senior credit controller role, overseeing a team of junior controllers.

• Implementing new credit assessment tools to improve efficiency, like automated credit scoring systems.

• Enhancing relationships with clients to reduce overdue accounts, aiming for a 20% decrease in ou...read more
Answered by AI
Add your answer